随笔分类 - Flashback
摘要:You are using the flash recovery area (fast recovery area in 11g Release 2) to store backup related files in your database. After regular monitoring o
阅读全文
摘要:You enabled Flashback Data Archive on the INVENTORY table. Which DDL operation issupported on the table after enabling Flashback Data Archive?A. Drop
阅读全文
摘要:You configured the Flash Recovery Area (FRA) for your database. The database instance is running in ARCHIVELOG mode. The default location for the arch
阅读全文
摘要:Which three operations require undo data? (Choose three.)A.committing a transactionB.flashing back a transaction – 回退操作C.recovering a failed transacti
阅读全文
摘要:Which two are the prerequisites to enable Flashback Data Archive? (Choose two.)A. Database must be running in archivelog mode.B. Automatic undo manage
阅读全文
摘要:You plan to use Flashback Drop feature to recover a dropped table SALES_EMP. No other table with the same name exists in the schema.You query RECYCLEB
阅读全文
摘要:You want to track and store all transactional changes to a table over its lifetime. To accomplish thistask, you enabled Flashback Data Archive with th
阅读全文
摘要:The EMP table exists in your schema. You want to execute the following query:SELECT ename, salFROM empAS OF TIMESTAMP (SYSTIMESTAMP - INTERVAL '6' MIN
阅读全文
摘要:For which two database objects can the VERSIONS clause of the Flashback Versions Query be used?(Choose two.)A.viewsB.fixed tablesC.heap tablesD.extern
阅读全文
摘要:User SCOTT wants to back out the transactions on the REGIONS table in his schema. As a DBA, which commands must you execute to enable SCOTT to flash b
阅读全文
摘要:What does the DB_FLASHBACK_RETENTION_TARGET parameter configure?A. An upper limit on how far you can flash back the database, depending on the informa
阅读全文
摘要:You are working in an online transaction processing (OLTP) environment. You use theFLASHBACKTABLE command to flash back the CUSTOMERS table. Before ex
阅读全文
摘要:You want to configure the Flashback Database feature and retain flashback logs for three days.Presently the database is open and configured in ARCHIVE
阅读全文
摘要:Note the following statements that use flashback technology: 1. FLASHBACK TABLE <table> TO SCN <scn>;2. SELECT * FROM <table> AS OF SCN 123456;3. FLAS
阅读全文
摘要:You need to maintain a record of all transactions on some tables for at least three years. Automatic undo management is enabled for the database.What
阅读全文
摘要:You want to set the following initialization parameters for your database instance:LOG_ARCHIVE_DEST_1 = 'LOCATION=/disk1/arch' LOG_ARCHIVE_DEST_2 ='LO
阅读全文
摘要:Before a Flashback Table operation, you execute the following command:ALTER TABLE employees ENABLE ROW MOVEMENT;Why would you need this to be executed
阅读全文
摘要:You want to use the automatic management of backup and recovery operations features for your database.Which configuration must you set?A. Enable the f
阅读全文
摘要:Examine the following commands and their output:SQL> SELECT ename, sal FROM emp WHERE ename='JAMES';ENAME SAL JAMES 1050SQL> UPDATE emp SET sal=sal+sa
阅读全文
摘要:What two are the prerequisites for enabling Flashback Database? (Choose two)A. The database must be in ARCHIVELOG modeB. The database must be in MOUNT
阅读全文