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 8 of 18.

Question 75: In your database, there are tablespaces that were read-only when the last backup was taken. These tablespaces have not been made read/write since then. You wan…
Question 77: RMAN is configured to create backupset backups for your database. You issue the command to back up the database: RMAN> BACKUP DATABASE PLUS ARCHIVELOG DELETE I…
Question 78: You issue the RMAN command: RMAN> BACKUP SECTION SIZE 300M TABLESPACE users; Which statement is true about the execution of the command?
Question 79: Your production database is running in archivelog mode. You use RMAN with a recovery catalog to back up your database to media and the database is uniquely ide…
Question 80: Your database instance is started using an SPFILE. You are connected to cdb$root, as a DBA. You issue: SQL> ALTER SYSTEM SET STATISTICS_LEVEL=ALL SCOPE=BOTH; W…
Question 81: You are administering a multitenant container database (CDB). Identify two ways to access a pluggable database (PDB) that is open in read-only mode.
Question 82: Automatic Shared Memory Management (ASMm) is enabled for your database instance, but parameters for the managed components are not defined. You execute this co…
Question 83: Examine the backup requirement for your company: 1) Every Sunday, a backup of all used data file blocks is performed. 2) Every Wednesday and Friday, a backup o…
Question 84: You are administering a multitenant container database (CDB) that contains multiple pluggable databases (PDBs). You are connected to cdb$root as the sys user.…
Question 85: You are administering a multitenant container database (CDB) cdb1 that has multiple pluggable databases (PDBs). As the sys user on cdb$root, you execute the co…