Oracle 1Z0-053 問題集

質問 1：
You are managing an Oracle Database 11g database. You want to take a backup on tape drives of the USERS tablespace that has a single data file of 900 MB. You have tape drives of 300 MB each. To accomplish the backup, you issued the following RMAN command:
RMAN>BACKUP
SECTION SIZE 300M
TABLESPACE users;
What configuration should be effected to accomplish faster and optimized backups by using the above command?
A. The COMPATIBLE initialization parameter for the database instance must be set to at least
10.0.
B. The SBT channel must be configured, with the parallelism setting for the SBT device set to 3.
C. The SBT channel must be configured, with the MAXPIECESIZE set to 300 MB.
D. The SBT channel must be configured, with the default parallelism setting for the SBT device set to 1.
正解：B
解説: (Topexam メンバーにのみ表示されます)

質問 2：
Which of the following information will be gathered by the SQL Test Case Builder for the problems pertaining to SQL-related problems? (Choose all that apply.)
A. all the optimizer statistics
B. PL/SQL functions, procedures, and packages
C. ADR diagnostic files
D. the table and index definitions and actual data
E. initialization parameter settings
正解：A,B,E
解説: (Topexam メンバーにのみ表示されます)

質問 3：
Which of the following most closely represents an image copy?
A. Windows COPY command of a file
B. Bit-by-bit copy of a file
C. Unix cp command of a file
D. All of the above
正解：D

質問 4：
You have the following requirements in relation to the detection of block corruption for your database instance:
-Check for logical self-consistency of data blocks when modified in memory.
-Checksums are calculated before and after the block change.
-Checks are performed for the lost writes to the physical standby database.
Which method would help you perform the above checks automatically?
A. Set the DB_SECUREFILE parameter to PERMITTED.
B. Set the DB_LOST_WRITE_PROTECT parameter to TYPICAL.
C. Set the DB_LOCK_CHECKSUM parameter to TYPICAL.
D. Set the DB_ULTRA_SAFE parameter to DATA_ONLY.
正解：D
解説: (Topexam メンバーにのみ表示されます)

質問 5：
You notice that a job in a chain has not completed on a nonconstrained RAC database. Which of these are valid reasons why that might occur?
A. The job affinity is to a service and one node in that service is unavailable.
B. There is no service affinity.
C. The job priority is 1 and the resource consumer group CPU emphasis allocation is a low percentage.
D. None of the above.
E. The job affinity is to an instance and that instance is unavailable.
正解：E

質問 6：
What methods of point-in-time recovery are available? (Choose all that apply.)
A. Time-based
B. Change-based
C. Cancel-based
D. Transaction number-based
E. Sequence number-based
正解：A,B,C,E

質問 7：
You execute the following command to set the redundancy retention policy in Recovery Manager (RMAN):
RMAN> CONFIGURE RETENTION POLICY TO REDUNDANCY 3;
Identify the statement that correctly describes the implications of this command.
A. when there are already three backup, one of the existing backups must be removed manually before taking the fourth backup.
B. when there are already three backups, for the fourth backup RMAN removes the oldest backup.
C. the number of backups that are retained is equal to three and it includes full, incremental, and cumulative backups.
D. When there are already three backups, for the fourth backup RMAN marks the oldest backup as obsolete.
正解：D
解説: (Topexam メンバーにのみ表示されます)