Oracle MCQ Questions and Answers – Oracle Architecture

December 31, 2021 John Howard

MS Oracle MCQ questions and answers for the preparation of tests, exams, and certifications. So you will find questions about the Datafiles, Control Files, Redo Log Files, Archive Log Files, Parameter Files, Trace Log, Backup, and much more. This systematic learning method will easily prepare anyone to pass their exam.

1. What is the use of the “Library cache” in Oracle?

A Contains information about the user, such as user privileges

B Used to store shared SQL

C Contains the changes made to the database

D All the answers are true

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

[st_adsense]

2. Which process is an Oracle instance?

A Background processes

B Memory processes

C Data processes

D All the answers are true

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

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

A Data Segment

B Object segment

C Temporary segment

D All the answers are true

After formatting or ending each block, the new index keys are placed in a (temporary) sort segment.

4. The “redo log buffer” and “Shared pool” are elements of ______ ?

A PGA

B Buffer cache

C Cache PGA and Buffer

D SGA

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

[st_adsense]

5. In Oracle, what are the following segment types?

A Permanent segment

B Object segment

C Data Segment

D All the answers are true

Oracle has 4 types of data segments:

Data segments
Index segments
Rollback segments
Temporary segments

6. ____________ 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

Data dictionary is structured into tables and views, just like other database data. All Data dictionary tables and views for a database are stored in the SYSTEM table space of that database.

7. Which PGA zone stores binding variables and information about running buffers ?

A SQL area

B Private SQL area

C Stack space

D Session area

PGA (Program Global Area) is a non-shared memory area that contains data and control information exclusively for an Oracle process. The PGA database is created by Oracle Database when an Oracle process starts.

8. What is the use of extent in Oracle?

A Stores user data in the database

B Stores undo information used when data is to be undone

C Minimize the amount of wasted storage

D None of the above

Extent is a logical unit of database storage space allocation composed of a number of contiguous data blocks.

[st_adsense]

9. Which of the following components are part of an Oracle architecture?

A Database-related background processes

B Tablespaces

C Datafiles

D All the answers are true

The Oracle architecture includes a database process, Table space and Datafiles.

10. What is the use of an index?

A Get data back faster and more efficiently

B Related data requires much less I/O overhead if accessed simultaneously

C Simplify the user’s perception of data access

D All the answers are true

The index is used to perform quick operations on the data.

[st_adsense]

1. What is the use of the “Library cache” in Oracle?

2. Which process is an Oracle instance?

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

4. The “redo log buffer” and “Shared pool” are elements of ______ ?

5. In Oracle, what are the following segment types?

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

7. Which PGA zone stores binding variables and information about running buffers ?

8. What is the use of extent in Oracle?

9. Which of the following components are part of an Oracle architecture?

10. What is the use of an index?

You May Also Like

Oracle MCQ Questions and Answers – Instances

Leave a Reply Cancel reply