1z1-063 무료 덤프문제 온라인 액세스

One of your database suffered an instance failure.
At the next startup, from which point in the redo logs does instance recovery begin?

• A.from a point corresponding to the most recent successful transaction commit
• B.from a point corresponding to the most recent checkpoint of any kind
• C.from a point corresponding to the most recent log switch checkpoint
• D.from a point corresponding to the most recent incremental checkpoint
• E.from a point corresponding to the most recent log instance checkpoint

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.The destination set by the LOG_ARCHIVE_DEST_1 parameter is ignored and the archived redo log files are created in the next two available locations to guarantee archive log success.
• B.The archived redo log files are written to the fast recovery area until the mandatory destination is made available.
• C.The database instance is shutdown immediately.
• D.The database instance hangs and the redo log files are not overwritten.

You notice a performance change in your production Oracle 12c database. You want to know which change caused this performance difference.
Which method or feature should you use?

• A.Taking a new snapshot and comparing it with a preserved snapshot
• B.AWR Compare Period report
• C.Active Session History (ASH) report
• D.Compare Period ADDM report

Which statement is true about the loss or damage of a temp file that belongs to the temporary tablespace of a pluggable database (PDB)?

• A.The PDB is closed and the temp file is re-created automatically when the PDB is opened.
• B.The PDB does not close and the temp file is re-created automatically whenever the container database (CDB) is opened.
• C.The PDB is closed and requires media recovery at the PDB level.
• D.The PDB does not close and starts by using the default temporary tablespace defined for the CDB.

You issue the command:
SQL> ALTER DATABASE BACKUP CONTROLFILE TO TRACE;
Which statement is true about the command?

• A.It creates a copy of the control file and stores it in the location specified in the diagnostic_dest initialization parameter.
• B.It creates a binary backup of the control file.
• C.It updates the alert log file with the location and contents of the control file.
• D.It creates a file that contains the SQL statement, which is required to re-create the control file.