随笔分类 -  undo

052-32
摘要：Your database instance is running with full workload after database creation. You have decided to use a fixed-size undo tablespace. You want to use th 阅读全文
posted @ 2017-12-05 15:04 巴啦啦大魔王 阅读(97) 评论(0) 推荐(0)
052-31
摘要：Which statement is true about the UNDO_RETENTION parameter when retention guarantee is not enabled?A.It is the time period after which the undo data b 阅读全文
posted @ 2017-12-05 14:58 巴啦啦大魔王 阅读(69) 评论(0) 推荐(0)
052-30
摘要：In which situation may the UNDO_RETENTION parameter be ignored, even if it is set to a value?A. When the data file of the undo tablespace is autoexten 阅读全文
posted @ 2017-12-05 14:48 巴啦啦大魔王 阅读(100) 评论(0) 推荐(0)
052-28
摘要：View the Exhibit and examine the undo tablespace attributes. Your database instance is experiencing a large volume of transactions from non-DBA users 阅读全文
posted @ 2017-12-05 14:41 巴啦啦大魔王 阅读(71) 评论(0) 推荐(0)
052-26
摘要：Which two statements are true regarding undo tablespaces? (Choose two.)A.The database can have more than one undo tablespace.B.The UNDO_TABLESPACE par 阅读全文
posted @ 2017-12-05 14:35 巴啦啦大魔王 阅读(101) 评论(0) 推荐(0)
052-25
摘要：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)
053-143
摘要：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)
053-69
摘要：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 巴啦啦大魔王 阅读(102) 评论(0) 推荐(0)
053-678
摘要：Which are the two prerequisites before setting up Flashback Data Archive? (Choose two.)A.Flash recovery area must be definedB.Undo retention guarantee 阅读全文
posted @ 2017-11-15 17:13 巴啦啦大魔王 阅读(103) 评论(0) 推荐(0)
053-690
摘要：The database users regularly complain about the difficulty in performing transactions. On investigation, you find that some users perform long-running 阅读全文
posted @ 2017-11-15 13:35 巴啦啦大魔王 阅读(89) 评论(0) 推荐(0)
053-379
摘要：Users notify you that their application is failing every time they try to add new records. Because ofpoor application design, the actual ORA error mes 阅读全文
posted @ 2017-11-13 15:22 巴啦啦大魔王 阅读(208) 评论(0) 推荐(0)
053-377
摘要：AUM has been retaining about 15 minutes worth of undo. You want to double the retention period, but not at the expense of new transactions failing. Yo 阅读全文
posted @ 2017-11-13 15:12 巴啦啦大魔王 阅读(74) 评论(0) 推荐(0)
053-373
摘要：Which of the following Oracle features utilize the undo tablespace? (Choose all that apply)A. Flashback QueryB. Flashback DropC. Flashback TableD. Fla 阅读全文
posted @ 2017-11-13 14:53 巴啦啦大魔王 阅读(123) 评论(0) 推荐(0)