Oracle 11gocmu Actual Free Exam Questions & Community Discussion
Note the output of the following query;
SQL> SELECT flashback_archieve_name, status FROM dba_flashback_archieve;
FLASHBACK_ARCHIEVE_NAME STATUS
FLA1
You executed the following command to enable Flashback Data Archive on the EXCHANGB_PATE table:
ALTER TABLE exchange_rate FLASHBACK ARCHIEVE;
What is the outcome of this command?
SQL> SELECT flashback_archieve_name, status FROM dba_flashback_archieve;
FLASHBACK_ARCHIEVE_NAME STATUS
FLA1
You executed the following command to enable Flashback Data Archive on the EXCHANGB_PATE table:
ALTER TABLE exchange_rate FLASHBACK ARCHIEVE;
What is the outcome of this command?
Correct Answer: D
Vote an answer
You are using Recovery Manager (RMAN) with a recovery catalog to back up your production database. The backups and the archived redo log files are copied to a tape drive on a daily basis. Because of media failure, you lost your production database completely along with the recovery catalog database. You want to recover the target database and make it functional.
You could consider performing the following steps to accomplish this task:
1) Restore an autobackup of the server parameter file.
2) Restore the control file.
3) Start the target database Instance.
4) Mount the database.
5) Restore the data files.
6) Open the database with the RESETLOGS option.
7) Recover the data files.
8) Set DBID for the target database
Which option illustrates the correct sequence that you must use?
You could consider performing the following steps to accomplish this task:
1) Restore an autobackup of the server parameter file.
2) Restore the control file.
3) Start the target database Instance.
4) Mount the database.
5) Restore the data files.
6) Open the database with the RESETLOGS option.
7) Recover the data files.
8) Set DBID for the target database
Which option illustrates the correct sequence that you must use?
Correct Answer: A
Vote an answer
Explanation: Only visible for EduDump members. You can sign-up / login (it's free).
You observed the following output for a user session:
What do you infer from the preceding output?
What do you infer from the preceding output?
Correct Answer: D
Vote an answer
Which two statements are true about encrypting RMAN backup? (Choose two.)
Correct Answer: A,B
Vote an answer
Explanation: Only visible for EduDump members. You can sign-up / login (it's free).
You have configured flash recovery area in your database and you set the following Initialization parameters for your database instance:
LOG_ARCHIVE_DEST 1 = 'LOCATION=/disk1/arch MANDATORY' LOG _ARCHIEVE_DEST 2 = 'LOCATION=/disk2/arch'
LOG_ARCHIVK_DEST_3 = 'LOCATION=/diSk3/arch'
LOG_ARCH1VK_DEST_4 = ' LOCATION=/disk4/arch'
LOG_ARCHIVE_MIN-SUCCEED_DEST = 2
While the database instance is functional, you realized that the destination set by the LOG_ARCHIVE_DEST_I parameter Is not available for the archived redo log file to be created in. All redo log groups have been used. What happens in an event of log switch?
LOG_ARCHIVE_DEST 1 = 'LOCATION=/disk1/arch MANDATORY' LOG _ARCHIEVE_DEST 2 = 'LOCATION=/disk2/arch'
LOG_ARCHIVK_DEST_3 = 'LOCATION=/diSk3/arch'
LOG_ARCH1VK_DEST_4 = ' LOCATION=/disk4/arch'
LOG_ARCHIVE_MIN-SUCCEED_DEST = 2
While the database instance is functional, you realized that the destination set by the LOG_ARCHIVE_DEST_I parameter Is not available for the archived redo log file to be created in. All redo log groups have been used. What happens in an event of log switch?
Correct Answer: B
Vote an answer
The SQL Tuning Advisor has been configured with default configurations in your database instance. Which recommendation is automatically implemented without the DBA's intervention after the SQL Tuning Advisor is run as part of the AUTOTASK framework?
Correct Answer: A
Vote an answer
How long will this backup be allowed to run?
Backup as compressed backupset duration 2:00 minimize load database ;
Backup as compressed backupset duration 2:00 minimize load database ;
Correct Answer: A
Vote an answer
Why should you back up a duplicated tablespace after a TSPITR is complete?
Correct Answer: E
Vote an answer
0
0
0
10