随笔分类 -  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 阅读全文
posted @ 2018-01-05 18:13 巴啦啦大魔王 阅读(172) 评论(0) 推荐(0) 编辑
摘要:You enabled Flashback Data Archive on the INVENTORY table. Which DDL operation issupported on the table after enabling Flashback Data Archive?A. Drop 阅读全文
posted @ 2018-01-05 17:52 巴啦啦大魔王 阅读(149) 评论(0) 推荐(0) 编辑
摘要:You configured the Flash Recovery Area (FRA) for your database. The database instance is running in ARCHIVELOG mode. The default location for the arch 阅读全文
posted @ 2017-12-08 11:20 巴啦啦大魔王 阅读(89) 评论(0) 推荐(0) 编辑
摘要:Which three operations require undo data? (Choose three.)A.committing a transactionB.flashing back a transaction – 回退操作C.recovering a failed transacti 阅读全文
posted @ 2017-12-05 14:32 巴啦啦大魔王 阅读(89) 评论(0) 推荐(0) 编辑
摘要:Which two are the prerequisites to enable Flashback Data Archive? (Choose two.)A. Database must be running in archivelog mode.B. Automatic undo manage 阅读全文
posted @ 2017-11-16 14:54 巴啦啦大魔王 阅读(95) 评论(0) 推荐(0) 编辑
摘要: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 阅读全文
posted @ 2017-11-16 14:46 巴啦啦大魔王 阅读(83) 评论(0) 推荐(0) 编辑
摘要: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 阅读全文
posted @ 2017-11-16 14:38 巴啦啦大魔王 阅读(116) 评论(0) 推荐(0) 编辑
摘要:The EMP table exists in your schema. You want to execute the following query:SELECT ename, salFROM empAS OF TIMESTAMP (SYSTIMESTAMP - INTERVAL '6' MIN 阅读全文
posted @ 2017-11-16 14:02 巴啦啦大魔王 阅读(101) 评论(0) 推荐(0) 编辑
摘要: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 阅读全文
posted @ 2017-11-16 13:51 巴啦啦大魔王 阅读(71) 评论(0) 推荐(0) 编辑
摘要: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 阅读全文
posted @ 2017-11-16 13:48 巴啦啦大魔王 阅读(127) 评论(0) 推荐(0) 编辑
摘要: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 阅读全文
posted @ 2017-11-16 13:45 巴啦啦大魔王 阅读(102) 评论(0) 推荐(0) 编辑
摘要:You are working in an online transaction processing (OLTP) environment. You use theFLASHBACKTABLE command to flash back the CUSTOMERS table. Before ex 阅读全文
posted @ 2017-11-16 13:43 巴啦啦大魔王 阅读(100) 评论(0) 推荐(0) 编辑
摘要:You want to configure the Flashback Database feature and retain flashback logs for three days.Presently the database is open and configured in ARCHIVE 阅读全文
posted @ 2017-11-16 13:35 巴啦啦大魔王 阅读(119) 评论(0) 推荐(0) 编辑
摘要: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 阅读全文
posted @ 2017-11-16 11:40 巴啦啦大魔王 阅读(90) 评论(0) 推荐(0) 编辑
摘要: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 阅读全文
posted @ 2017-11-15 17:14 巴啦啦大魔王 阅读(142) 评论(0) 推荐(0) 编辑
摘要:You want to set the following initialization parameters for your database instance:LOG_ARCHIVE_DEST_1 = 'LOCATION=/disk1/arch' LOG_ARCHIVE_DEST_2 ='LO 阅读全文
posted @ 2017-11-15 17:04 巴啦啦大魔王 阅读(84) 评论(0) 推荐(0) 编辑
摘要:Before a Flashback Table operation, you execute the following command:ALTER TABLE employees ENABLE ROW MOVEMENT;Why would you need this to be executed 阅读全文
posted @ 2017-11-15 16:59 巴啦啦大魔王 阅读(99) 评论(0) 推荐(0) 编辑
摘要: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 阅读全文
posted @ 2017-11-15 16:11 巴啦啦大魔王 阅读(150) 评论(0) 推荐(0) 编辑
摘要: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 阅读全文
posted @ 2017-11-15 16:00 巴啦啦大魔王 阅读(96) 评论(0) 推荐(0) 编辑
摘要: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 阅读全文
posted @ 2017-11-15 15:47 巴啦啦大魔王 阅读(115) 评论(0) 推荐(0) 编辑

点击右上角即可分享
微信分享提示