OCP Database Architecture & Configuration

Question 1

What is the role of the Oracle SGA (System Global Area)?

Accepted Answer

To store shared memory for Oracle processes

Answer

To store user data

Answer

To manage backup processes

Answer

To manage network connections

Question 2

What is the purpose of the Oracle instance?

Accepted Answer

It manages the database's processes and memory

Answer

It stores the physical data files

Answer

It is responsible for backup and recovery

Answer

It maintains user access control

Question 3

Which Oracle process is responsible for performing background database tasks like recovery and managing transactions?

Accepted Answer

DBWR

Answer

PMON

Answer

SMON

Answer

LGWR

Question 4

What is the Oracle Redo Log used for?

Accepted Answer

To track the changes to the database for recovery

Answer

To store archived log files

Answer

To track user login details

Answer

To store temporary session data

Question 5

What is the Oracle Archive Log Mode?

Accepted Answer

It allows point-in-time recovery

Answer

It allows backup of all database files

Answer

It enables undo tablespace operations

Answer

It ensures high availability

Question 6

Which Oracle memory structure holds all the necessary information for managing a user’s session?

Accepted Answer

Program Global Area (PGA)

Answer

Shared pool

Answer

Redo log buffer

Answer

Buffer cache

Question 7

What is a key feature of Oracle RAC (Real Application Clusters)?

Accepted Answer

Multiple instances accessing a shared database

Answer

Single database instance

Answer

Replication of data across multiple sites

Answer

Load balancing across multiple storage devices

Question 8

What is the function of the Oracle Data Pump?

Accepted Answer

It helps move data between Oracle databases

Answer

It optimizes SQL queries

Answer

It facilitates the backup of archived logs

Answer

It monitors real-time performance of databases

Question 9

What is Oracle ASM (Automatic Storage Management)?

Accepted Answer

It automates storage management for Oracle databases

Answer

It is a backup solution for Oracle databases

Answer

It provides high availability for storage

Answer

It compresses Oracle data files