Oracle 1z0-063 問題集

質問 1：
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. All the PDBs are in closed state.
B. All redo log files are opened.
C. Only the root database is opened in read-write mode.
D. All the PDBs are opened in read-write mode.
E. The root, the seed, and all the PDBs are opened in read-write mode.
正解：B,C

質問 2：
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 archived redo log files are written to the fast recovery area until the mandatory destination is made available.
B. The database instance hangs and the redo log files are not overwritten.
C. 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.
D. The database instance is shutdown immediately.
正解：C

質問 3：
Which three conditions must be met before you Virtual Private Catalog (VPC) can be created and used by an Administrator? (Choose three.)
A. A base recovery catalog must exist.
B. The owner of the VPC cannot own recovery catalog.
C. The REGISTER DATABASE privilege should be granted to the virtual catalog owner.
D. At least one target database should be registered in the recovery catalog.
E. The DBA role must be granted to the virtual catalog owner.
正解：A,B,E

質問 4：
Examine the RMAN commands executed in your database:
RMAN> CONFIGURE DEFAULT DEVICE TYPE TO disk;
RMAN> CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO BACKUPSET;
RKAN> CONFIGURE CONTROLFILE AUTOBACKUP ON;
You issue the command:
RMAN> BACKUP DATABASE;
Which two statements are true about the command? (Choose two.)
A. It backs up only the used blocks in data files.
B. It backs up data files, the control file, and the server parameter file.
C. It performs a log switch.
D. It creates a backup of only the control file whenever the database undergoes a structural change.
E. It creates compressed backup sets by using binary compression by default.
正解：A,B

質問 5：
Which two statements are true when row-archival management is enabled? (Choose two.)
A. The ORA_ARCHIVE_STATE column is visible if it is referenced in the select list of a query.
B. The ORA_ARCHIVE_STATE column is updated automatically by the database based on activity tracking columns, to indicate that a row is no longer considered active.
C. The ORA_ARCHIVE_STATE column is updated manually or by a program that can reference activity tracking columns, to indicate that a row is no longer considered active.
D. Visibility of the ORA_ARCHIVE_STATE column is controlled by the row archival visibility session parameter.
E. The row archival visibility session parameter defaults to all rows.
正解：A,C

質問 6：
Which three statements are true about automated maintenance tasks? (Choose three.)
A. An Oracle Scheduler job is created for each maintenance tasks that is scheduled to run in a maintenance window.
B. A repository is maintained in the SYSTEM tablespace to store the history of execution of all tasks.
C. They run at predefined time intervals that are intended to occur during a period of low system loads.
D. A maintenance window is automatically extended until all the maintenance tasks defined are completed.
E. Predefined maintenance tasks consist of automatic optimizer statistics collection, running Automatic Segment Advisor, and running Automatic SQL Tuning Advisor.
正解：A,C,E