Oracle 1Z0-053 問題集

質問 1：
View the Exhibit to examine the Automatic SQL Tuning result details. Which action would you
suggest for the selected SQL statement in the Exhibit?

A. Collect statistics for the related objects.
B. Run the Segment Advisor for recommendations.
C. Run the Access Advisor for the SQL statement.
D. Accept the recommended SQL profile.
正解：C

質問 2：
Which two statements correctly describe the relationship among the Scheduler components: job, program, and schedule? (Choose two)
A. A program and job can be specified as part of a schedule definition
B. A job is specified as part of a program definition
C. A program and schedule can be specified as part of a job definition
D. A program can be used in the definition of multiple jobs
正解：C,D
解説: (Topexam メンバーにのみ表示されます)

質問 3：
You are an Oracle DBA responsible for an ASM instance. The disk controller on your system fails. You suspect that the disk itself is okay. You know it will take 24 hours to replace the controller and you don't want to have to rebuild the disks from scratch.
What do you do?
A. Change the attribute DISK_REPAIR_TIME on the disk group to a time greater than 24 hours.
B. Change the ASM parameter ASM_PREFERRED_READ_FAILURE_GROUPS to indicate that you want to read from the non-failed disk. Once the disk controller is replaced, reset the parameter to its original value.
C. Take the whole disk group offline and wait for the controller card to be installed. Once it's installed, bring the disk group online again.
D. If you are using any setting other than REDUNDANCY EXTERNAL for your disk group, you will have to recover any data on that disk from a backup. The database will be unavailable until you can correct the problem and perform recovery.
E. You have no choice but to rebuild the disk. Drop the disk from the disk group and wait for the controller to be replaced. Once the controller is replaced, add the disk back into the disk group and allow ASM to rebuild it.
正解：A

質問 4：
You issue the following RMAN command to set a retention policy on a database:
RMAN>CONFIGURE RETENTION POLICY TO REDUNDANCY 2;
What will be the outcome of issuing this command?
A. If the RMAN repository has records of two or more recent backups of a file, then older backups will be marked obsolete.
B. If the RMAN repository has records of two or more recent backups of a file, then older backups will be deleted from the media.
C. After two days, a backup will be marked obsolete
D. After two days, a backup will be deleted from the media
正解：A

質問 5：
Which of the following are valid settings for the NLS_COMP parameter? (Choose all that apply.)
A. ASCII
B. MULTILINGUAL
C. BINARY
D. MONOLINGUAL
E. ANSI
正解：C,E
解説: (Topexam メンバーにのみ表示されます)

質問 6：
You observed the following output for a user session:

What do you infer from the preceding output?
A. The database instance is enabled to use asynchronous commit
B. The threshold warning limit is exceeded for the tablespace that is used by the user session
C. Resumable set for session with sid 18
D. The user session has entered into a deadlock
正解：C

質問 7：
After you have restored and recovered a database to a new host by using a previously performed Recovery Manager (RMAN) backup, which is the best option you would consider for the new database?
A. Restoring the server parameter file (SPFILE) to the new host
B. Opening the database with the RESETLOGS option
C. Setting a new DBID for the newly restored database
D. Opening the database in RESTRICTED mode
正解：B