分类：
2010-10-23 09:40:21
是Oracle OCP认证考试中的重要的一门考试。通过OCP你进可以对这方面的技术熟练的运用，而且作为ORACLE认证专家，您将具有对业界最具挑战性的机遇更深的洞察力，并获取更多的收获。：
这门考题的信息如下：
VUE/Prometric考试代号：
认证名称: Oracle Database 11g: Administration II
版本号：V9.02
考题数量：383道
更新日期：2010-9-29
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
如需下载OCP认证的完整的题库，可登陆。
