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.
You are using a recovery catalog to maintain Recovery Manager (RMAN) backup information for your production database. You have registered your production database and are performing regular backups. Because of a new requirement you have added a few new tablespaces to your production database and you want them to be included in backups. Identify two options for completing this task. (Choose two.)
A. Reregistering the target database in recovery catalog
B. Transporting the new tablespaces to the recovery catalog database
C. Syncronizing the recovery catalog with the target database control file
D. Performing a fresh backup of the target database to include the new data files in the catalog database
Which statements about the MEMORY_TARGET initialization parameter are true? (Choose all that apply.)
A. MEMORY_TARGET can be increased up to the value of MEMORY_MAX_TARGET,
if MEMORY_MAX_TARGET is set to a value greater than zero
B. MEMORY_MAX_TARGET defaults to a value of zero if MEMORY_TARGET is not set
C. MEMORY_TARGET represents the total amount of memory that can be allocated to SGA and PGA memory structures.
D. MEMORY_TARGET is static and cannot be modified without shutting down the instance