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

Question 137: You want to create a database with a block size other than the default 8 KB by using the Database Configuration Assistant (DBCA). Which option should you use?
Question 140: Which three statements are true about Oracle Restart?
Question 141: Which three methods can be used to create a pluggable database (PDB) in an existing multitenant container database (CDB)?
Question 142: You want to export the pluggable database (PDB) hr_pdb1 from the multitenant container database (CDB) CDB1 and import it into the cdb2 CDB as the emp_pdb1 PDB.…
Question 143: Examine these Data Pump commands to export and import objects from and to the same database. The dba has not yet created users hr1 and oe1. $expdp system/manag…
Question 144: One of the four database suffered an instance failure. At the next startup, from which point in the redo logs does instance recovery begin?
Question 145: Examine this command: SQL> CREATE DATABASE cdb1 - DEFAULT TABLESPACE users - DEFAULT TEMPORARY TABLESPACE temp UNDO TABLESPACE undotbs1 - ENABLE PLUGGABLE DATA…
Question 146: Which three statements are true about compression of backup sets?
Question 147: Examine the command to create a pluggable database (PDB): SQL> CREATE PLUGGABLE DATABASE pdb2 FROM pdb1 FILE_NAME-_CONVERT = ('/disk1/oracle/pdb1/', '/disk2/or…
Question 148: Your database is running in archivelog mode. You are taking a backup of your database by using RMAN with a recovery catalog. Because of a media failure, one of…