随笔分类 -  SCN

摘要:You are performing incomplete recovery using RMAN. You execute the following RUN block:RUN{SET UNTIL SCN 1107600;RESTORE DATABASE;RECOVER DATABASE;}Wh 阅读全文
posted @ 2017-11-16 15:06 巴啦啦大魔王 阅读(154) 评论(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 巴啦啦大魔王 阅读(106) 评论(0) 推荐(0)
摘要:The EMP table has some discrepancy in data entry with a particular employee ID. You execute thequery as shown in the Exhibit to retrieve all versions 阅读全文
posted @ 2017-11-15 17:01 巴啦啦大魔王 阅读(78) 评论(0) 推荐(0)
摘要:You executed the following query: Considering that all the redo logs are available, what information can you derive from the output of the preceding q 阅读全文
posted @ 2017-11-15 14:11 巴啦啦大魔王 阅读(119) 评论(0) 推荐(0)
摘要:Which of these are valid Flashback Database recovery point parameters? (Choose all that apply.)A. SCNB. TimestampC. Named recovery pointD. Transaction 阅读全文
posted @ 2017-11-13 17:33 巴啦啦大魔王 阅读(96) 评论(0) 推荐(0)
摘要:Which method could be utilized to identify both DML operations and the SQL statements needed toundo those operations for a specific schema owner? (Cho 阅读全文
posted @ 2017-11-13 16:47 巴啦啦大魔王 阅读(99) 评论(0) 推荐(0)
摘要:Which of the following statements is true regarding implementing a Flashback Table recovery?A. An SCN is never used to perform a Flashback Table recov 阅读全文
posted @ 2017-11-13 15:52 巴啦啦大魔王 阅读(203) 评论(0) 推荐(0)
摘要:Which of the following can be used in conjunction with a Flashback Versions Query to filter the results?(Choose all that apply.)A. A range of SCN valu 阅读全文
posted @ 2017-11-13 15:32 巴啦啦大魔王 阅读(108) 评论(0) 推荐(0)
摘要:What information does the report schema command not provide? (Choose all that apply.)A. Size of the datafiles B. Size of the tempfilesC. Date of last 阅读全文
posted @ 2017-11-10 18:26 巴啦啦大魔王 阅读(57) 评论(0) 推荐(0)
摘要:Which of the following are valid until command options when attempting point-in-time recovery inRMAN? (Choose all that apply.)A. until timeB. until ch 阅读全文
posted @ 2017-11-10 15:36 巴啦啦大魔王 阅读(91) 评论(0) 推荐(0)
摘要:What does the SCN represent?A. The system change number, which is a point in time relative to transactions within a given database.B. A number that re 阅读全文
posted @ 2017-11-09 16:18 巴啦啦大魔王 阅读(110) 评论(0) 推荐(0)
摘要:What methods of point-in-time recovery are available? (Choose all that apply.)A. Change-basedB. Cancel-basedC. Time-basedD. Sequence number-basedE. Tr 阅读全文
posted @ 2017-11-08 18:13 巴啦啦大魔王 阅读(136) 评论(0) 推荐(0)
摘要:What is the purpose of the until change option of the restore command?A. It allows you to select the SCN that you want to restore to. B. It allows you 阅读全文
posted @ 2017-11-06 17:25 巴啦啦大魔王 阅读(117) 评论(0) 推荐(0)