A. when a table is dropped and you restore it from the Recycle Bin
B. when a user’s schema is dropped and you recover the user’s schema
C. when some incorrect data is inserted in the table and you retrieve the table to a state that was at a certain timestamp
D. when a row of a table is updated frequently and committed, and you view all the versions of the row within a specific duration
您可能感兴趣的试卷
你可能感兴趣的试题
An important tablespace of your database is dropped by mistake. You use the Flashback Database feature to retrieve the tablespace. You perform the following steps to retrieve the tablespace:
1. You log on to Enterprise Manager as SYSDBA.
2. You select the maintenance screen.
3. You choose Perform Recovery option on the maintenance screen.
4. You choose Whole Database in the Object Type drop-down list Perform Recovery: Type screen. 5. You choose Recover to Current Time from the Operation Type on the Perform Recovery: Type screen.
6. You provide the Host Credentials for a database user. on the Perform Recovery: Type screen.
7. You click the continue button.
An information screen appears saying that the database is unavailable. What is this information screen?()
A.Recovery Manager
B.Recovery Window
C.Recovery Wizard
D.Enterprise Manager Home Page
A. V$DATABASE
B. V$UNDOSTAT
C. V$FLASHBACK_DATABASE_LOG
D. V$FLASHBACK_DATABASE_STAT
You are working as a DBA on Oracle Database 9i. You plan to upgrade your 9i database to Oracle 10g. To be familiar with the new database technology, you decide to install Oracle Database 10g on your workstation at home. You create a general purpose database.
After the installation, you make the following changes in your initialization parameter file:LOG_ARCHIVE_DEST_1=’LOCATION=USE_DB_RECOVERY_FILE_DEST’
DB_RECOVERY_FILE_DEST =
’LOCATION=d:\product\10.1.0\flash_recovery_area’
DB_RECOVERY_FILE_DEST_SIZE=10g
Where are the archived redo logs stored for your database?()
A. The archived redo logs are stored in an operating system-dependent location.
B. The archived redo logs are stored in the location specified by LOG_ARCHIVE_DEST_1.
C. The archived redo logs are stored in the location specified by DB_RECOVERY_FILE_DEST.
D. The archived redo logs are stored in the locations specified by both LOG_ARCHIVE_DEST_1 and DB_RECOVERY_FILE_DEST.
A. multiplexed control files
B. RMAN obsolete backups
C. multiplexed online redo log files
D. archived redo logs that have not been copied to tape
Your Oracle Database 10g is online when you execute the following statement:
SQL>ALTER TABLESPACE MY_TABLESPACE FLASHBACK OFF;
What is the result of executing this statement if the Flashback Database feature is already enabled in the database?()
A. The database does not record flashback logs for MY_TABLESPACE
B. The tables residing in MY_TABLESPACE are not protected by the Recycle Bin.
C. All the tablespaces except MY_TABLESPACE can be recovered using Flashback Database feature.
D. None of the flashback technologies, such as Flashback Table, Flashback Transaction Query and Flashback Version Query can be used to recover individual rows within the objects from MY_TABLESPACE
A. DBA_PENDING_TRANSACTIONS
B. DBA_AUDIT_STATEMENT
C. V$FLASHBACK_DATABASE_STATS
D. FLASHBACK_TRANSACTION_QUERY
A. Open the database in read-only mode.
B. Set the retention target with the DB_FLASHBACK_RETENTION_TARGET initialization parameter.
C. Enable the block change tracking feature.
D. Execute the ALTER DATABASE FLASHBACK ON statement.
You dropped a schema of a user in an Oracle 10g by mistake. You decide to flash the database back to its previous state to restore the deleted schema.
Which process writes the before images of the physical database blocks to the flashback database logs?()
A. LGWR
B. DBWR
C. MMON
D. RVWR
A. Query the V$FLASHBACK_DATABASE_LOG view.
B. Query the V$FLASHBACK_DATABASE_STAT view.
C. Check the value of the DB_FLASHBACK_RETENTION_TARGET initialization parameter.
D. Query the V$RECOVERY_FILE_DEST view.
In which two scenarios should you issue the following command?()
FLASHBACK TABLE SCOTT.EMP TO TIMESTAMP SYSTIMESTAP- INTERVAL ’15’ MINUTE;
A. when the schema of the user, SCOTT, was deleted by mistake 15 minutes ago
B. when the table EMP of the SCOTT schema was dropped by mistake 15 minutes ago
C. when some rows of the table, EMP, in the SCOTT schema were deleted by mistake 15 minutes ago
D. when some incorrect values were inserted in the EMP table in the user Scott’s schema during the last 15 minutes
E. never, because FLASHBACK TABLE is not a valid command in Oracle 10g.
最新试题
You used the following command in Recovery Manager (RMAN) as part of the recovery process: RESTORE CONTROLFILE FROM AUTOBACKUP; How does RMAN find the control file autobackup?()
In which case would you use the Flashback Database feature to perform a recovery?()
You disabled the Flashback Database feature by using the following command: SQL> ALTER DATABASE FLASHBACK OFF; What would be the effect of this command on the existing flashback logs?()
A data file became corrupted in your database due to bad sectors on the disk. Because of corruption, you lost all the important tables in that data file.Which method would you use for recovery?()
You are using Oracle Database 10g. The LOG_ARCHIVE_FORMAT parameter is set to ’LOG%t_%s_%r.dbf’. Why is %r used in the file name format?()
Your database operates in ARCHIVELOG mode and usermanaged consistent backups are performed every Sunday night. On Tuesday, at 9:00 a.m. the current log sequence number was 369. Also, on Tuesday you lost the data file belonging to the SYSTEM tablespace and an archivelog file (sequence number 356) that contained redo entries between 8:00 a.m. and 8:30 a.m. With reference to this scenario, what would you do to recover the database?()
Your database operates in ARCHIVELOG mode and all the tablespaces are online. Due to a user error, you decided to perform an incomplete recovery. Which two tasks would you be required to perform in the recovery process? ()
View the Exhibit and examine the Flashback Database architecture. Identify the missing component (shown with a "?") in the Flashback Database architecture.()
You enabled the flashback logging feature, but you have not specified the location of the flash recovery area. Which location would be used as the default location for the flash recovery area?()
You are working on an Oracle Database 10g database. Because of data loss, you decided to perform a Flashback Database operation using the following command: SQL> FLASHBACK DATABASE TO TIMESTAMP(SYSDATE 5/24); Which two statements are true? ()