Free Oracle Database Administration II Practice Test

Your database is running in ARCHIVELOG mode and you need to perform a complete database recovery after a media failure. You have a valid RMAN backup and all archived redo logs. Which command sequence should you use to restore and recover the database?

A DBA needs to configure automatic segment space management for better performance and reduced contention. Which tablespace parameter should be specified during tablespace creation?

You are troubleshooting poor SQL performance and notice high wait events for 'db file sequential read'. The Automatic Workload Repository (AWR) report shows this as the top wait event. What is the most likely cause and recommended action?

Your organization requires that all attempts to access sensitive data in the HR.EMPLOYEES table be audited, including both successful and failed access attempts. Which auditing approach provides the most comprehensive coverage with minimal performance impact?

During an RMAN backup, you want to ensure that blocks are checked for corruption. Which RMAN command option should you use?

A critical tablespace was accidentally dropped in your production database. You have a valid RMAN backup from last night and all archived logs. What is the correct approach to recover only the dropped tablespace without affecting other tablespaces?

You need to implement data redaction to hide credit card numbers from application users while allowing the application to function normally. Which Oracle feature should you use?

Your database is experiencing performance issues. Upon investigation, you find that the shared pool is being flushed frequently. What is the most likely cause and solution?

You need to configure RMAN to automatically delete obsolete backups based on a retention policy of keeping backups for 7 days. Which RMAN configuration command should you use?

A database administrator needs to grant a user the ability to perform queries on all tables in the database without granting individual object privileges. However, the user should not be able to modify any data. Which approach is most appropriate?

You are performing incomplete recovery and need to recover the database to a specific System Change Number (SCN) 5234567. Which RMAN command should you use after restoring the database?

Your production database has a tablespace with multiple datafiles, and one datafile has been corrupted. The database is in ARCHIVELOG mode and currently open. What is the most efficient recovery approach?

You notice that automatic segment space management is causing performance issues due to frequent extent allocations in a rapidly growing table. What is the best approach to minimize this overhead?

A DBA needs to analyze SQL statements that are consuming excessive CPU resources. Which view provides the most comprehensive historical information about SQL execution statistics?

You need to implement separation of duties to prevent a database administrator from accessing sensitive application data while still allowing them to perform administrative tasks. Which Oracle Database security feature is most appropriate?

You are configuring RMAN for backup optimization. Which RMAN configuration will skip backing up datafiles that have already been backed up to the specified device type and have not changed?

The Automatic Database Diagnostic Monitor (ADDM) has identified that the database is spending excessive time on log file sync waits. What is the most likely cause and recommended action?

You need to reclaim unused space from a table that has had many rows deleted but don't want to invalidate dependent objects or cause downtime. Which approach should you use?

Your organization's compliance requirements mandate that audit records must be protected from modification or deletion, even by privileged users. Which audit configuration best meets this requirement?

You are analyzing an AWR report and observe that the buffer cache hit ratio is 65%. What is the most appropriate interpretation and action?