The safer , easier way to help you pass any IT exams. The steps to recover the damaged data files are follows: 1. Mount the database 2. Open the database 3. Recover the data file 4. Restore the data file 5. Make the data file offline 6. Make the data file online
Which option identifies the correct sequence that you must use to recover the data files? A. 2, 4, 3 B. 1, 4, 3, 2 C. 2, 5, 4, 3, 6 D. 5, 2, 4, 3, 6 E. 1, 5, 4, 3, 6, 2
Answer: E
87.You want to perform an RMAN backup of database as a copy. Which two factors will you consider while performing the backup operation? (Choose two). A. The backup as copy can only be taken to disk B. The backup as copy can only be taken to tape
C. Backup can be performed only when the instance is shutdown D. Backup will constitute all used and unused blocks in the database
Answer: AD
88.In your database, the flash recovery area (FRA) is configured as the default for RMAN backups. You executed the following commands to configure the settings in RMAN:
Which statement is true about the outcome?
A. Only one channel is allocated and the backup is created in the flash recovery area
B. Only one channel is allocated and the backup is created in the destination specified for channel
C. Two channels are allocated and backup sets are created in the destinations specified for channels 1 and 2
D. Three channels are allocated and backup sets are created in the destinations specified for channels 1, 2, and FRA Answer: A
89.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
21 / 193
The safer , easier way to help you pass any IT exams.
files and applying archived redo logs? A. Open the database in NORMAL mode B. Open the database in read-only mode
C. Open the database in RESTRICTED mode
D. Open the database with the RESETLOGS option Answer: D
90.View the exhibit and examine the output. Which statement can be an inference from the output? Exhibit:
A. The FRA disk group has an asynchronous I/O bottleneck
B. The least number of I/Os are performed on the last data file in the list
C. The number of times that the backup or restore process directed the OS to wait until an I/O was complete is the highest for the last data file in the list
D. The number of times that the backup or restore process made an OS call to poll for I/O completion in Nonblocking mode is the least for the FRA disk group Answer: A
91.Your database interface is running. A user SCOTT starts a SQL *Plus session, and issues the following query:
SQL> SELECT * FROM sales;
Which process would retrieve the result from the database and return it to the client program? A. User process B. Server process
C. System Monitor (SMON) D. Process Monitor (PMON) E. Checkpoint process (CKPT) Answer: B
22 / 193
The safer , easier way to help you pass any IT exams.
92.You observed the following output for a user session:
What do you infer from the preceding output? A. Resumable set for session with sid 18
B. The user session has entered into a deadlock
C. The database instance is enabled to use asynchronous commit
D. The threshold warning limit is exceeded for the tablespace that is used by the user session Answer: A
93.The database is configured in ARCHIVELOG mode and regular complete database backups are taken.The loss of which two types of files may require a recovery with the RESETLOGS option? (Choose two) A. Control files B. Password files
C. Inactive online redo log file
D. Archived log files required to perform recovery E. Newly created tablespace which is not backed up
Answer: AD
94.Multiple RMAN sessions are connected to the database instance.
Examine the following output when backup commands are running in server sessions: What could have helped you to correlate server sessions with channels?
A. Implement RMAN multiplexing
B. Set the DEBUG ON in the RMAN script
C. Specify the command ID in the RMAN script D. Use a tag with the RMAN BACKUP command Answer: C
95.Examine the following scenario: The target database instance is running. The most recent backup available for the target database was taken two days ago. Log files switches have occurred in last two days. The target database is duplicated on the same host, using the Recovery Manager (RMAN) duplicate command as follows:
RMAN> RUN { ALLOCATE AUXILIARY CHANNEL aux 1 DEVICE TYPE DISK; DUPLICATE TARGET DATABASE TO auxdb; }
Which statement is true about the duplicate database in this scenario? A. It contains data till the last backup
B. It contains all data from target database until the current time
23 / 193
The safer , easier way to help you pass any IT exams.
C. It contains all data from only the committed transactions in the target database
D. It contains all data except that which is used by the transactions in the current online redo file of target database Answer: D
96.Examine the following command:
SQL> ALTER TABLE booking SHRINK SPACE COMPACT;
Which activity is performed when the preceding command is executed? A. The shrink operation touches every block in the BOOKING table
B. The high-water mark (HWM) for the BOOKING table is shifted from its original position C. The progress of the shrink operation is saved in the bitmap blocks of the BOOKING table
D. The data manipulation language (DML) triggers on the BOOKING table are executed because the shrink operation is internally handled by the INSERT/DELETE operation Answer: C
97.The RECYCLEBIN parameter is set to ON for your database. You drop a table, PRODUCTS, from the SCOTT schema.
Which two statements are true regarding the outcome of this action? (Choose two) A. All the related indexes and views are automatically dropped B. The flashback drop feature can recover only the table structure
C. Only the related indexes are dropped whereas views are invalidated
D. The flashback drop feature can recover both the table structure and its data Answer: CD
98.You plan to execute the following command to perform a Flashback Database operation in your database:
SQL> FLASHBACK DATABASE TO TIMESTAMP (SYSDATE -5/24); Which two statements are true about this? (Choose two) A. The database must have multiplexed redo log files
B. The database must be in the MOUNT state to execute the command C. The database must be in the NOMOUNT state to execute the command D. The database must be opened in RESTRICTED mode before this operation
E. The database must be opened with the RESETLOGS option after the flashback operation Answer: BE
99.View the Exhibit and examine the steps that you executed to create a database resource plan. Subsequently, you execute the following procedure which results in an error: SQL> EXECUTE dbms_resources_manager.validate_pending_area ( ); What could be the reason? Exhibit:
24 / 193
The safer , easier way to help you pass any IT exams.
A. The pending area is automatically submitted after the plan creation
B. The procedure must be executed before creating the resources plan directive
C. The SYS_GROUP resource consumer group is not included in the resource plan directive
D. The OTHER_GROUPS resources consumer group is not included in the resource plan directive Answer: D
100.Examine the following command that is used to duplicate a database on the same host: RMAN> RUN
{ALLOCATE AUXILIARY CHANNEL, aux 1 DEVICE TYPE DISK; DUPLICATE TARGET DATABASE TO auxdb SKIP READONLY; \\ }
Which two statements describe the effect after the database is duplicated successfully? (Choose two) A. The data files of the read-only tablespaces in the target database are not duplicated
B. The read-only tablespaces in the target database are still defined in new the database C. The read-only tablespaces in the target database are changed to online after duplication D. The data files of the read-only tablespaces in the target database get duplicated
E. The read-only tablespaces in the target database are not defined in the new database Answer: AB
101.Identify two situations in which you can use Data Recovery Advisor for recovery. (Choose two.) A. The user has dropped an important table that needs to be recovered. B. The database files are corrupted when the database is open.
C. You are not able to start up the database instance because the required database files are missing. D. The archived log files are missing for which backup is not available. Answer: BC
102.Examine the following values of the initialization parameters in the database having the SID ORCL: BACKGROUND_DUMP_DEST=/u01/app/oracle/product/11.1.0/db_1/bdump USER_DUMP_DEST=/u01/app/oracle/product/11.1.0/db_1/udump CORE_DUMP_DEST=/u01/app/oracle/product/11.1.0/db_1/cdump DIAGNOSTIC_DEST=
The environment variables have the following value: ORACLE_BASE=/u01/app/oracle
ORACLE_HOME=/u01/app/oracle/product/11.1.0/db_1
What is the location of the Automatic Diagnostic Repository (ADR) home? A. /u01/app/oracle/product/11.1.0/db_1 B. /u01/app/oracle 25 / 193