Oracle 1Z0 053 Exam

Exam Number/Code : 1Z0-053
Exam Name : Oracle Database 11g: Administration II
Questions and Answers : 167 Q&As
Update Time: 2010-05-15
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
Explanation:
To enable Flashback Database, you use the command ALTER DATABASE FLASHBACK ON.
Your database must be in ARCHIVELOG mode, you must have the flash recovery area configured, and
you must have DB_FLASHBACK_RETENTION_TARGET set to an appropriate value. A, B, and C are
incorrect because they all specify columns that do not exist.
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
Explanation:
You use the PLATFORM_NAME and ENDIAN_FORMAT columns to determine the supported endian
formats for all supported platforms.
B, C, and D are incorrect because none of these views exist.
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
Explanation:
Unless you explicitly specify a location for the block change tracking file using the USING FILE clause, the
file is created using Oracle Managed Files (OMF), w