A. Another repair session is running concurrently.
B. The failure ID has not been mentioned in the command for data file 5.
C. There are new failures recorded in the Automatic Diagnostic Repository (ADR).
D. The ADVISE FAILURE command has not been issued before the REPAIR FAILURE command.
Answer: A Section: (none)
Explanation/Reference:
QUESTION 286
The Oracle Database 11g database is running in the ARCHIVELOG mode. The archived redo log files are stored on three locations. The Flash Recovery Area is one of the locations. The details are given below:
LOG_ARCHIVE_DEST_1 = 'LOCATION = /disk1/archive' LOG_ARCHIVE_DEST_2 = 'SERVICE = stdb1' DB_RECOVERY_FILE_DEST = '/u01/oradata'
Examine the following RMAN command issued to set the deletion policy for archived log files:
RMAN> CONFIGURE ARCHIVELOG DELETION POLICY TO BACKED UP 2 TIMES TO sbt;
Which statement is true regarding what this command accomplishes?
A. All archived redo log files backed up at least twice to tape are deleted.
B. All archived redo log files backed up at least once to tape are eligible for deletion.
C. All archived redo log files backed up at least twice to tape are deleted from the flash recovery area. D. All archived redo log files in local archiving destinations and the flash recovery area backed up
at least twice to tape are eligible for deletion.
Answer: D Section: (none)
QUESTION 287
Evaluate the following command:
SQL> CREATE TABLE design_data (id NUMBER, doc CLOB)
LOB(doc) STORE AS SECUREFILE(DEDUPLICATE);
Which statement is true regarding the above command?
A. The LOB values are automatically compressed.
B. The LOB values are cached by default in the buffer cache. C. The LOB values are automatically stored in encrypted mode.
D. All LOB data that is identical in two or more rows in a LOB column share the same data blocks.
Answer: D Section: (none)
QUESTION 288
You are maintaining the SALES database. You have added a new disk to a disk group. Automatic Storage Management performs the rebalancing activity. You want to speed up the rebalancing activity. Which parameter should you specify to control the speed of the rebalancing activity?
A. ASM_POWER_LIMIT B. ASM_DISKSTRING C. ASM_DISKGROUPS D. INSTANCE_TYPE
Answer: A Section: (none)
Explanation/Reference:
QUESTION 289
You are managing the APPPROD database as a DBA which is not using the Oracle-managed files. You plan to duplicate this database in the same system with the name DUPDB.You want to create the same directory structure for duplicate database files as of the target database. You executed the following RMAN commands:
RMAN> CONNECT TARGET sys/sys@APPPROD RMAN> CONNECT AUXILIARY sys/sys@DUPDB RMAN> DUPLICATE TARGET DATABASE TO dupdb
FROM ACTIVE DATABASE PASSWORD FILE SPILE
NOFILENAMECHECK;
What are the implications of this command?
A. It creates database files for the duplicate database under the Oracle base with a different directory
for the duplicate database.
B. It overwrites data files of the target database because a different location for data files is not
mentioned for the duplicate database.
C. It creates database files for the duplicate database under the same Oracle home as that of the
target database with the same directory structure.
D. It creates database files for the duplicate database under the same Oracle home as that of the
target but with a different directory for the duplicate database.
Answer: B Section: (none)
QUESTION 290
What are the recommendations for Oracle Database 11g installation to make it Optimal Flexible Architecture (OFA)-compliant? (Choose all that apply.)
A. ORACLE_BASE should be set explicitly.
B. An Oracle base should have only one Oracle home created in it. C. Flash recovery area and data file location should be on separate disks.
D. Flash recovery area and data file location should be created under Oracle base in a
non-Automatic Storage Management (ASM) setup.
Answer: ACD Section: (none)
QUESTION 291
ENCRYPT_TS is an encrypted tablespace that contains tables with data. Which statement is true regarding the effect of queries and data manipulation language (DML) statements on the encrypted data in the tables?
A. The data is decrypted during SORT and JOIN operations. B. The data remains encrypted when it is read into memory. C. The data remains encrypted when it is stored in the redo logs.
D. The data remains encrypted in the UNDO tablespace provided that the UNDO tablespace
was created with the encryption option enabled.
Answer: C Section: (none)
Explanation/Reference:
QUESTION 292
You decided to use Direct NFS configuration in a non-RAC Oracle installation and created the oranfstab file in /etc. Which two statements are true regarding this oranfstab file? (Choose two.)
A. Its entries are specific to a single database.
B. It contains file systems that have been mounted by Direct NFS. C. It is globally available to all Oracle 11g databases on the machine. D. It contains file systems that have been mounted by the kernel NFS system.
Answer: CD Section: (none)
QUESTION 293
Observe the following warning in an RMAN session of your database instance:
WARNING: new failures were found since last LIST FAILURE command
Which statement describes the scenario that must have produced this warning?
A. The CHANGE FAILURE command has detected new failures recorded in the Automatic
Diagnostic Repository(ADR).
B. The VALIDATE DATABASE command has detected new failures recorded in the Automatic
Diagnostic Repository (ADR).
C. The ADVISE FAILURE command has detected new failures recorded in the Automatic
Diagnostic Repository (ADR) since the last LIST FAILURE.
D. The RECOVER command has detected new failures recorded in the Automatic Diagnostic
Repository (ADR) since the last LIST FAILURE command was executed.
Answer: C Section: (none)
QUESTION 294
Which tuning tool recommends how to optimize materialized views so that these views can take advantage of the general query rewrite feature?
A. Segment Advisor B. SQL Access Advisor C. Undo Advisor D. SQL Tuning Advisor
Answer: B Section: (none)
QUESTION 295
Which statement about using RMAN stored scripts is true?
A. To create and execute an RMAN stored script, you must use a recovery catalog.
B. When executing a stored script and a command fails, the remainder of the script is executed,
and a message is written to the alert log file.
C. RMAN stored scripts can always be executed against any target database that is registered
in the recovery catalog.