Oracle Database 12c: Advanced Administration Free Practice Exam Questions

177 real Oracle Database 12c: Advanced Administration exam questions with answers and AI explanations. Oracle certification prep — page 10 of 18.

Question 96: Your database is on ARCHIVELOG mode and an incremental backup exists. A media failure in the loss of a data file and an online redo log. Examine these commands…
Question 97: Your multitenant container database (CDB) CDB1, has no startup triggers and contains multiple pluggable databases (PDBs). It was started up by using the comman…
Question 98: Automatic Undo Management is enabled for your database. You want a user to retrieve metadata and historical data for a given transaction or for transactions in…
Question 99: Which two statements are true regarding the Oracle Data Pump export and import operations?
Question 100: You are required to migrate your 11.2.0.3 database to an Oracle 12c database. Examine the list of steps that might be used to accomplish this task: 1. Place al…
Question 101: You want to consolidate databases for the CRM, ERP, and SCM applications by migrating them to pluggable databases (PDBs). You have already created a test syste…
Question 102: Which three statements are true about Oracle Secure Backup (OSB)?
Question 103: LDAP_DIRECTORY_SYSAUTH is set to YES. Users requiring DBAs access have been granted the sysdba enterprise role in Oracle Internet Directory(OID). SSL has been…
Question 104: Your database is running in archivelog mode and regular nightly backups are taken. Due to a media failure, the current online redo log group, which has one mem…
Question 105: Examine the command to back up the ASM metadata: ASMCMD>md_backup /backup/ASM_backup In which three situations can you use the backup?