Note the output of the following query;
SQL> SELECT flashback_archieve_name, status FROM dba_flashback_archieve; FLASHBACK_ARCHIEVE_NAME STATUS
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?
A. The table uses the default Flashback Data Archive.
B. The Flashback Data Archive Is created In the SYSAUX tablespace.
C. The Flashback Data Archive is created in the same tablespace where the tables are stored.
D. The command generates an error because no flashback Data Archive name is specified and there is no default Flashback Data Achieve.
While working on a data problem, Curt, Bill, Ben, Mike, and Matt introduced a vast amount of corrupted data into the database. Pablo has discovered this problem and he needs you to recover the database to the point in time prior to the introduction of the corruption. The logical corruption was introduced at 6:30 p.m. on September 6, 2008. Which of the following would be the correct commands to use to restore the database to a point in time before the orruption?
A. restore database until time ’06-SEP-2008 06:30:00′); recover database until time ’06-SEP-2008 06:30:00′); alter database open;
B. restore database until time ’06-SEP-2008 06:30:00′); recover database until time ’06-SEP-2008 06:30:00′); alter database open resetlogs;
C. restore database until time ’06-SEP-2008 18:29:55′); recover database until time ’06-SEP-2008 18:29:55′); alter database open resetlogs;
D. restore database until time ’06-SEP-2008 18:29:55′); alter database open resetlogs;
E. restore database until time ’06-SEP-2008 18:29:55′); recover database; alter database open resetlogs;
Your database has a backup that was taken yesterday (Tuesday) between 13:00 and 15:00 hours. This is the only backup you have. You have lost all the archived redo logs generated since the previous Monday, but you have archived redo logs available from the previous Sunday and earlier. You now need to restore your backup due to database loss. To which point can you restore your database?
A. 13:00 on Tuesday.
B. 15:00 on Tuesday.
C. Up until the last available archived redo log on Sunday.
D. To any point; all the redo should still be available in the online redo logs.
E. The database is not recoverable.
After executing the command alter diskgroup disk group2 drop disk dg2a; you issue the following command from the ASM instance:
Select group_number, count(*) from v$asm_operation;
What is the implication if the query against V$ASM_OPERATION returns zero rows?
A. The drop disk operation is still proceeding and you cannot yet run the undrop disks operation.
B. The drop disk operation is complete and you can run the undrop disks command if needed.
C. The drop disk operation is complete and you cannot run the undrop disk command.
D. The query will fail since there is not a V$ASM_OPERATION view available in an ASM instance.
E. None of the above is true.
Exhibit: View the Exhibit to examine the parameter values. You are planning to set the value for the MEMORY_TARGET parameter of your database instance. What value would you assign?
A. 1440 MB
B. 90 MB
C. 362 MB
D. 272 MB
Which three statements are true regarding the functioning of the Autotask Background Process (ABP)? (Choose three.)
A. It creates jobs without considering the priorities associated with them.
B. It translates tasks into jobs for execution by the scheduler.
C. It determines the list of jobs that must be created for each maintenance window.
D. It is spawned by the MMON background process at the start of the maintenance window.
E. It maintains a repository in the SYSTEM tablespace to store the history of the execution of all tasks.