Practice Questions

Which background process is responsible for writing redo log entries?

A. DBWn B. LGWR C. SMON D. PMON

What is the purpose of a Pluggable Database (PDB)?

A. To manage physical storage B. To isolate user data within a container C. To replace tablespaces D. To store redo logs

Which tool is used to create and configure Oracle databases?

A. RMAN B. DBCA C. SQL*Plus D. OEM

What does RMAN primarily manage?

A. User authentication B. Database backups and recovery C. SQL execution D. Network connections

Which feature allows recovery of data to a previous point in time?

A. Data Pump B. Flashback Database C. ASM D. AWR

What is the main function of ASM (Automatic Storage Management)?

A. Manage user roles B. Optimize SQL queries C. Manage database storage efficiently D. Monitor sessions