Oracle 1Z0-053 問題集

質問 1：
You have backed up your database using image copies. You have lost the SYSTEM tablespace and need to restart your database as quickly as possible. What is the correct solution?
A. Restore the SYSTEM tablespace from the last backup set and then recover the database.
B. Use the switch datafile command to instantly switch to the datafile copy, recover the tablespace, and open the database.
C. Restore the SYSTEM tablespace image copy using the restore command and then restore the database.
D. The database is not recoverable in this situation with image copies.
E. Manually copy the datafile image copy to the correct location and then manually restore the database from SQL*Plus.
正解：B

質問 2：
You upgraded Oracle Database 10g to Oracle Database 11g. How would this affect the existing users' passwords?
A. All passwords automatically become case-sensitive.
B. All passwords remain non-case-sensitive until their password attribute in the profile is altered.
C. All passwords remain non-case-sensitive and cannot be changed.
D. All passwords remain non-case-sensitive till they are changed.
正解：D

質問 3：
You issued the following commands to configure setting in RMAN;
RMAN> CONFIGURE DEVICE TYPE sbt PARALLELISM 1;
RMAN> CONFIGURE DEFAULT DEVICE TYPE TO sbt;
RMAN> CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE sbt TO 2;
RMAN> CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE sbt TO 2;
RMAN> CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 2;
Then you issued the following command to take the backup:
RMAN> BACKUP DATABASE PLUS ARCHIVELOG;
Which statement is true about the execution of the above command?
A. It backs up two copies of data files to tape and disk, and two copies of archived log file on tape
B. It backs up the data files and archived log files to tape, making two copies of each data file and archived log file
C. The backup will terminate because the FORMAT clause was not configured for the channel
D. It backs up the data files and archived log files to disk, making two copies of each data file and archived log file
正解：B

質問 4：
Examine the following ALTER command;
SQL> ALTER DISKGROUP dgroup1 UNDROP DISKS;
What is the purpose of the command?
A. It mounts disks in the disk group for which the drop-disk operation has already been completed.
B. It restores all the dropped disks in the disk group for which the drop-disk operation has already been completed.
C. It restores disks that are being dropped as the result of a DROP DISKGROUP operation.
D. It cancels all pending disk drops within the disk group.
E. It adds previously dropped disks back into the disk group.
正解：D
解説: (Topexam メンバーにのみ表示されます)

質問 5：
You executed the following command:
RMAN> RECOVER COPY OF DATAFILE '/u01/app/oracle/oradata/orcl/users01.dbf';
Which statement regarding the above command is correct?
A. The '/u01/app/oracle/oradata/orcl/users01.dbf' data file is recovered from the image copy.
B. Image copies of the '/u01/app/oracle/oradata/orcl/users01.dbf' data file are updated with all changes up to incremental backup SCN.
C. Image copies of the '/u01/app/oracle/oradata/orcl/users01.dbf' data file are recovered using the above command if data file recovery fails.
D. The '/u01/app/oracle/oradata/orcl/users01.dbf' data file is recovered from the last incremental backup.
正解：B

質問 6：
Which of the following is NOT an advantage of block media recovery (BMR)?
A. Reduced MTTR.
B. A and C
C. Datafiles remain offline while corrupt blocks are repaired.
D. Datafiles remain online while corrupt blocks are repaired.
正解：C
解説: (Topexam メンバーにのみ表示されます)

質問 7：
View the Exhibit and examine the parameter settings in your server-side parameter file (SPFILE). When you tried to start the database instance, you received the following error:
SQL> startup
ORA-00824: cannot set SGA_TARGET or MEMORY_TARGET due to existing internal settings, see alert log for more information
Why did the instance fail to start?
Exhibit:

A. Because both the SGA_TARGET and MEMORY_TARGET parameters are set.
B. Because the PGA_AGGREGATE_TARGET parameter is not set
C. Because MEMORY_TARGET and MEMORY_MAX_TARGET cannot be equal
D. Because the STATISTICS_LEVEL parameter is set to BASIC
正解：D
解説: (Topexam メンバーにのみ表示されます)