1z0-063 Exam Dumps - Oracle Database 12c: Advanced Administration

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:

1. STARTUP NOMOUNT

2. STARTUP MOUNT

3. RESTORE DATABASE

4. RECOVER DATABASE

5. RECOVER DATABASE UNTIL CANCEL

6. ALTER DATABASE OPEN

7. ALTER DATABASE OPEN RESETLOGS

Which commands are required to recover your database?

You are administering a multitenant container database (CDB) that contains multiple pluggable databases (PDBs). RMAN is connected to CDB$ROOT.

Examine the command:

RMAN> LIST FAILURE;

Which statement is true about this command?

In which situation can you use Flashback Database?

What can be automatically implemented after the SQL Tuning Advisor is run as part of the Automated Maintenance Task?

Your database is running in archivelog mode. Examine the parameters for your database instance:

LOG_ARCHIVE_DEST_l ='LOCATION=/disk1/arch MANDATORY'

LOG_ARCHIVE_DEST_2 ='LOCATION=/disk2/arch'

LOG_ARCHIVE_DEST_3 ='LOCATIO=/disk3/arch'

LOG_ARCHIVE_DEST _4 ='LOCATIONs/disk4/arch'

LOG_ARCHIVE _MIN_SUCCEED_DEST = 2

While the database is open, you notice that the destination set by the log_archive_dest_1 parameter is not available. All redo log groups have been used.

What happens at the next log switch?

A telecom company wishes to generate monthly bills to include details of customer calls, listed in order of time of call.

Which table organization allows for generating the bills with minimum degree of row sorting?

Which activity is audited by default and recorded in the operating system audit trail irrespective of whether or not database auditing is enabled?

View the Exhibit showing steps to create a database resource manager plan.

SQL>execute dbms_resource_manager.create_pendingarea();

PL/SQL procedure successfully completed.

SQL>exec dbms_resource_manager, create_consumergroup (consumer_group=>’OLTP,,comment=>,onlineuser’)

PL/SQL procedure successfully completed.

SQL>exec bras resource_manager.create plan(plan=>’PRIU3ER3',comment=>'dssprio’);

SQL>exec

Dbms_resource_manager.create_plan_directive(plan=>’PRIU3ER3’,group_or_subplan=>'OLTP’,comment=>'onlinegrp'CPU_Pl=>60);

PL/3QLproceduresuccessfullycompleted.

After executing the steps in the exhibit you execute this procedure, which results in an error:

SQL> EXECUTE dbms_resource_manager. validate_pending_area ();

What is the reason for the error?