Oracle Database Questions and Answers – Oracle Database 11g Architecture

This set of Oracle Database Multiple Choice Questions & Answers (MCQs) focuses on “Oracle Database 11g Architecture”.

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

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

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

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

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

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

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

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

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

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

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

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

10. The redo log buffer and Shared pool are elements of?
a) PGA
b) Buffer cache
c) PGA and Buffer cache
d) SGA
View Answer

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

Sanfoundry Global Education & Learning Series – Oracle Database.

To practice all areas of Oracle Database, here is complete set of 1000+ Multiple Choice Questions and Answers.

If you find a mistake in question / option / answer, kindly take a screenshot and email to [email protected]

advertisement
advertisement
Subscribe to our Newsletters (Subject-wise). Participate in the Sanfoundry Certification contest to get free Certificate of Merit. Join our social networks below and stay updated with latest contests, videos, internships and jobs!

Youtube | Telegram | LinkedIn | Instagram | Facebook | Twitter | Pinterest
Manish Bhojasia - Founder & CTO at Sanfoundry
Manish Bhojasia, a technology veteran with 20+ years @ Cisco & Wipro, is Founder and CTO at Sanfoundry. He lives in Bangalore, and focuses on development of Linux Kernel, SAN Technologies, Advanced C, Data Structures & Alogrithms. Stay connected with him at LinkedIn.

Subscribe to his free Masterclasses at Youtube & discussions at Telegram SanfoundryClasses.