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
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