Oracle Database Multiple Choice Questions and Answers on Oracle Database 11g Architecture for Freshers

1. What is the use of Library cache?

a) Contains User information, such as user privileges
b) Used to store shared SQL
c) Log of changes made to the database
d) All of the Mentioned

Answer: b

Explanation: Oracle Library cache is like a data buffer cache, except that it is not for data, but a cache for SQL PL/SQL programs and Java classes.

2. Which processes is an instance made of Oracle?

a) Oracle background processes
b) Memory processes
c) Data processes
d) All of the Mentioned

Answer: a

Explanation: Oracle creates a set of background processes for an instance to manage memory structure, asynchronously perform I/O to write data to disk, and do general maintenance tasks.

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

a) Data Segment
b) Object Segment
c) Temporary Segment
d) All of the Mentioned

Answer: c

Explanation: After each block is formatted/finished, the new index keys are put in a sort (temporary) segment.

4. What is the use of an index?

a) Retrieve data more quickly and efficiently
b) Related data requires much less I/O overhead if accessed simultaneously
c) Simplify the user’s perception of data access
d) All of the Mentioned

Answer: a

Explanation: Index is used for to perform the quick operation on the data.

5. Which of the following components comprise an Oracle architecture?

a) Database related background processes
b) Tablespaces
c) Datafiles
d) All of the Mentioned

Answer: d

Explanation: Oracle architecture consists of DB process, Table space, Datafiles.

6. What is the use of extent in Oracle?

a) Stores user data within the database
b) Stores rollback information used when data must be rolled back
c) Minimize the amount of wasted (empty) storage
d) None of the Mentioned

Answer: c

Explanation: An extent is a logical unit of database storage space allocation made up of a number of contiguous data blocks.

7. Which area of PGA stores binding variables and run-time buffers information?

a) SQL area
b) Private SQL area
c) Stack space
d) Session area

Answer: b

Explanation: PGA (Program Global Area) is a non-shared memory region that contains data and control information exclusively for use by an Oracle process.The PGA is created by Oracle Database when an Oracle process is started.

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

a) PGA
b) Library cache
c) Data dictionary
d) SGA

Answer: c

Explanation: The data dictionary is structured in tables and views, just like other database data. All the data dictionary tables and views for a given database are stored in that database’s SYSTEM tablespace.

9. In Oracle, which of below are types of segments?

a) Permanent Segment
b) Object Segment
c) Data Segment
d) All of the Mentioned

Answer: c

Explanation: Oracle has 4 type of data segment :1)data segments 2)index segments 3)rollback segments 4)temporary segments.

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

a) PGA
b) Buffer cache
c) PGA and Buffer cache
d) SGA

Answer: d

Explanation: SGA (System Global Area) contains Shared Pool, Database Buffer Cache, Java Pool, redo Log Buffer.