Oracle 1Z0-053 問題集

質問 1：
You plan to use SQL Performance Analyzer to analyze the SQL workload. You created a SQL Tuning Set as a part of the workload capturing. What information is captured as part of this process? (Choose all that apply.)
A. the system change number (SCN)
B. the execution frequency
C. the execution context
D. the execution plan
E. the SQL text
正解：B,C,E
解説: (Topexam メンバーにのみ表示されます)

質問 2：
Which operation requires that you create an auxiliary instance manually before executing the operation? (Choose all that apply.)
A. Backup-based database duplication.
B. Tablespace point-in-time recovery.
C. Active database duplication.
D. No operation requires the creation of an auxiliary instance.
正解：A,C

質問 3：
You are using recovery Manager (RMAN) with a recovery catalog to backup up your production database. The backups and the archived redo log files are copied to a tape drive on a daily basis. The database was open and transactions were recorded in the redo logs. Because of fire in the building you lost your servers having the production database and the recovery catalog database. The archive log files generated after the last backup are intact on one of the remote locations.
While performing a disaster recovery of the production database what is the next step that you must perform after restoring the data files and applying archived redo logs?
A. Open the database with the RESETLOGS option
B. Open the database in read-only mode
C. Open the database in RESTRICTED mode
D. Open the database in NORMAL mode
正解：A
解説: (Topexam メンバーにのみ表示されます)

質問 4：
Which of the following commands will perform an active database duplication of the ORCL database to the ORCL2 database?

A. Option E
B. Option A
C. Option C
D. Option D
E. Option B
正解：A

質問 5：
What is the proper procedure to recover a lost tempfile?
A. Re-create the tempfile with the create tempfile command.
B. Restore the backup copy of the tempfile from the backup media.
C. Copy an existing tempfile from another database.
D. Re-create the tempfile with the create tablespace command.
E. Re-create the tempfile with the alter tablespace command.
正解：E
解説: (Topexam メンバーにのみ表示されます)

質問 6：
Which command do you use to generate a report of database incarnations?
A. report database incarnation
B. list incarnation of database
C. database incarnation list
D. list database incarnation
E. report incarnation of database
正解：B
解説: (Topexam メンバーにのみ表示されます)

質問 7：
You want to back up your 100-GB database on a remote tape device. You are required to ensure that minimum network bandwidth is consumed while transferring the backups to the tape device. The current consumption of your CPU is approximately 40 percent.
Which type of backup should you perform?
A. user-managed backup
B. standard backup set
C. compressed backup
D. image copy
正解：C