Oracle OCP 1Z0-053試験

Oracle OCP 1Z0-053
試験番号: 1Z0-053

試験の名称: Oracle Database 11g: Administration II

バージョン:V9.02
問題と解答:383 Q&As
価格(日本円): \ 2900.00 JPY
更新:2010-07-13

1.You are not sure if Flashback Database is enabled. What database column and view can you query to
see if the flashback logs are being created in the flash recovery area?
A. Query the initialization parameter FLASHBACK_DATABASE in VJINSTANCE.
B. Query the FLASHBACK_ENABLED column in VJDATABASE.
C. Query the FLASHBACK column in VJDATABASE..
D. Query the FLASHBACK_ON column in VJDATABASE.
Answer: D

2.What dynamic performance view can you query to list the supported platforms for transportable
tablespaces?
A. V$TRANSPORTABLE_PLATFORM
B. V$TRANSPORTABLE_TABLESPACE
C. V$SUPPORTED_PLATFORMS
D. V$DATABASE PLATFORM
Answer: A

3.You issue the following command to enable block change tracking:
SQL> ALTER DATABASE ENABLE BLOCK CHANGE TRACKING;
However, you receive an error message, and the tracking file is not created. What is a possible reason for
the error message?
A. The parameter DB_RECOVERY_FILE_DEST is not set.
B. You must use ALTER SYSTEM instead. )
C. Your database must be in the MOUNT state to create the block change tracking file.
D. The parameter DB_CREATE_FILE_DEST is not set.
Answer: D

4.You are restoring and recovering a database to a new host. What data dictionary view will you use to
identify the names of the datafiles on the new database?
A. DBA_DATAFILE
B. VJTABLESPACE
C. VJDATAFILE
D. V$DATAFILE_COPY
E. VJBACKUP DATAFILE
Answer: C

5.Your flash recovery area becomes full when you are running an RMAN backup (and has not yet reached
the value specified by DB_RECOVERY_FILE_DEST). It is the destination for archived redo log files and
backups. What will happen to the database? (Choose the best answer.)
A. If you have the flash recovery area set to autoextend, the backup will continue with no problem.
B. The database will hang until you add more space to the flash recovery area.
C. RMAN will delete obsolete backups from the flash recovery area to accommodate new backups.
D. The RMAN backup will hang until you add more space to the flash recovery area.
Answer: C

6.You want to ensure the recoverability of the recovery catalog itself. Which of the following steps should
you implement to maximize recoverability?
(Choose all that apply.)
A. Configure the database for ARCHIVELOG mode.
B. Use BACKUP DATABASE PLUS ARCHIVELOG when you back up the recovery catalog.
C. Put the recovery catalog in the target database, and include a backup of the recovery catalog with
every backup.
D. Use BACKUP DATABASE PLUS ARCHIVELOG when you back up the recovery catalog.
E. Back up the recovery catalog to disk and tape after each target database backup (in other words, two
separate media types).
Answer: A, B, D, E

7.For which of the following scenarios would you use user-managed incomplete recovery? (Choose all
that apply.)
A. You have lost a datafile and one or more of the archived redo log files are missing.
B. Several widespread logical errors have occurred in the database in the last day.
C. You want to create a test database as of a point in time in the past.
D. You have lost a datafile and you have all archived redo log files available.
E. You have lost one of the copies of the control file.
Answer: A, B, C

8.You want to leverage resource consumer groups when using the Scheduler. Which Scheduler object
uses resource plans directly?
A. A lightweight job
B. Ajob class
C. Ajob chain
D. A program
Answer: B

9.You need to recover the database after a disk is lost but you are missing two archived redo log files. You
need to run the RMAN RECOVER DATABASE UNTIL command. In what database state can you perform
this recovery?
A. OPEN
B. MOUNT
C. RESTRICTED
D. NOMOUNT
Answer: B

10.Which of the following methods can you use to enable duplexed RMAN backups? (Choose two
answers.)
A. Use the initialization parameter RMAN_BACKUP_COPIES.
B. Use the BACKUP COPIES option in the RMAN CONFIGURE command.
C. Use the BACKUP COPIES option in the ALLOCATE CHANNEL command.
D. Use the COPIES option in the RMAN BACKUP command.
Answer: B, D

11.Which of the following tablespaces can be recovered while the database is online? (Choose all that
apply.)
A. USERS
B. UNDO
C. SYSAUX
D. SYSTEM 3
E. EXAMPLE
Answer: A, C, E

12.Which of the following methods can you use to run a job chain? (Choose all that apply).
A. Create and schedule a job with CREATEJOB of type CHAIN.
B. Create and schedule a chain using the CREATE_CHAIN procedure.
C. Create and schedule a chain using the CREATE_JOB_CHAIN procedure.
D. Use the START_CHAIN procedure.
E. Use the RUN_CHAIN procedure.
Answer: A, E

13.Which of the following commands successfully allocates a channel? (Choose all that apply.)
A. ALLOCATE CHANNEL T2 TYPE TAPE;
B. ALLOCATE CHANNEL T2 TYPE SBT;
C. ALLOCATE CHANNEL DB2 TYPE DISK PARMS='SBT_LIBRARY=mmv.so';
D. ALLOCATE CHANNEL T1 TYPE DISK;
Answer: B, D