1z1-063 試験問題を無料オンラインアクセス

Your database is running in ARCHIVELOG mode. Examine the initialization parameters you plan to set for your database instance.
LOG_ARCHIVE_DEST_1 = 'LOCATION=/disk1/arch'
LOG_ARCHIVE_DEST_2 = 'L0CATI0N=/disk2/3rch'
LOG_ARCHIVE_DEST_3 = 'LOCATION=/disk3/arch'
L0G_ARCHIVE_DEST_4 = 'L0CATI0N=/disk4/3rch MANDATORY'
Identify the statement that correctly describes these settings.

• A.An online redo log file is not allowed to be overwritten if the archived log file cannot be created in the location specified for LOG_ARCHIVE_DEST_4.
• B.An online redo log file is not allowed to be overwritten if the archived log file cannot be created in any of the LOG_ARCHIVE_DEST_.n destinations.
• C.Optional destinations cannot use the fast recovery area.
• D.These settings work only if LOG__ARCHIVE_MIN_SUCCEED_DEST is set to a value of 4.

Examine this query:
SELECT cust_name, amt_due
FROM customers
AS OF TIMESTAMP (SYSTIMESTAMP - INTERVAL '6' MINUTE)
WHERE cust_no = 'AYR2011';
Which two requirements guarantee that the query will execute successfully? (Choose two.)

• A.FLASHBACK must be ON for the database.
• B.Supplemental logging must be enabled.
• C.Undo retention guarantee must be enabled.
• D.The database must be in ARCHIVELOG mode.
• E.Row movement must be enabled for CUSTOMERS.
• F.Automatic Undo Management must be configured.

You are administering a multitenant container database (CDB) CDB1 that is running in ARCHIVELOG mode and contains pluggable databases (PDBs), PDB_1 and PDB_2.
While opening PDB_1, you get an error:
SQL> alter pluggable database pdb_1 open;
ORA-01157: cannot identify/lock data file 11 - see DBWR trace file
ORA-01110: data file 11: '/u01/app/oracle/oradata/cdb1/pdb_1/example01.dbf' To repair the failure, you open an RMAN session for the target database CDB$ROOT. You execute the following as the first command:
RMAN> REPAIR FAILURE;
Which statement describes the consequence of the command?

• A.The command produces an error because the ADVISE FAILURE command was not executed before the REPAIR FAILURE command.
• B.The command executes successfully, performs recovery, and opens PDB_1.
• C.The command produces an error because RMAN is not connected to the target database PDB_1.
• D.The command performs the recovery and closes the failure.

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?

• A.2, 3, 5, and 7
• B.2, 3, and 4
• C.1, 3, 5, and 6
• D.2, 3, 5, and 6
• E.1, 3, and 4

Your multitenant container database (CDB) CDB1, which has no startup triggers and contains multiple pluggable databases (PDBs), is started up by using the command:
SQL> STARTUP
Which two statements are true about the successful execution of the command? (Choose two.)

• A.Only the root database is opened in read-write mode.
• B.All the PDBs are in closed state.
• C.The root, the seed, and all the PDBs are opened in read-write mode.
• D.All the PDBs are opened in read-write mode.
• E.All redo log files are opened.