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

Question 86: You create a default Flashback Data Archive FLA1 and enable it for the EMPLOYEES table in the HR schema. After a few days, you want to alter the EMPLOYEES tabl…
Question 87: Which two statements are true about Flashback Version Query?
Question 88: Which statement is true about Enterprise Manager (EM) express in Oracle Database 12c?
Question 89: Your database is running in ARCHIVELOG mode. You use RMAN to take image copies and you update these copies incrementally every six hours. After a regular maint…
Question 90: You are administering a multitenant container database (CDB) cdb1. Examine the command and its output: SQL>show parameterfile - NAMETYPEVALUE - ---------------…
Question 91: You want to migrate your Oracle 11g database as a pluggable database (PDB) in a multitenant container database (CDB). The following are the possible steps to a…
Question 92: Your database is running in ARCHIVELOG mode and flashback is enabled. In which scenario must you use RMAN backups for recovering tables and table partitions?
Question 93: Because of logical corruption of data in a table, you want to recover the table from an RMAN backup to a specified point in time. Examine the steps to recover…
Question 94: You wish to create jobs to satisfy these requirements: 1. Automatically bulk load data from a flat file. 2. Rebuild indexes on the SALES table after completion…
Question 95: database, you attempt to load data into the HR.EMPLOYEES table in a pluggable database (PDB):
gt; sqlldr hr/hr@pdb table=employees Which three are true? (Choose…