Oracle Database and True Incorrect Correct

Oracle-Architecture Test Breakdown:
1. How many layers does the Oracle database have?
Correct

2. Which of the following components comprise an oracle architecture?
Correct

3. A _______________ is used to logically group data together
Correct

4. Oracle automatically creates the SYSTEM tablespace
Correct

5. A _____________ is a set of tables physically stored together as one table that shares a common column
Correct

6. What is the use of an index?
Correct

7. Which is the smallest unit of storage in an Oracle database?
Correct

8. Identify, which of the following below are types of segments?
You answered: All of the above
Incorrect

Correct answer: Data Segment

9. Which of the following segment is destroyed when the SQL statement is finished?
Correct

10. Which of the following is the most probable use of an extent?
You answered: Stores user data within the database
Incorrect

Correct answer: Minimize the amount of wasted (empty) storage

11. The basic memory structures associated with Oracle are the System Global Area (SGA) and the Program Global Area (PGA).
Correct

12. The redo log buffer and Shared pool are elements of?
Correct

13. What is the use of Library cache?
Correct

14. The ____________ contains a set of tables and views that Oracle uses as a reference to the database.
Correct

15. The size and content of the PGA is independent on the Oracle server options installed
You answered: True
Incorrect

Correct answer: False

16. Which area of PGA stores binding variables and runtime buffers information?
You answered: Session area
Incorrect

Correct answer: Private SQL area

17. Where is the data dictionary kept?
Correct

18. Can there be more than one datafile per tablespace?
Correct

19. What do the schema objects comprise of?
Correct

20. Which processes is an instance made of?
You answered: All of the above
Incorrect

Correct answer: Oracle background processes

1. What is the