MCQ

Oracle MCQ Questions and Answers – Oracle Architecture

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

B
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

A
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

C
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

D
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

C

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

C
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

B
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

C
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

D
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

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

 

 
[st_adsense] mcqMCQPractice competitive and technical Multiple Choice Questions and Answers (MCQs) with simple and logical explanations to prepare for tests and interviews.Read More

Leave a Reply

Your email address will not be published. Required fields are marked *