随笔分类 - SCN
摘要:You are performing incomplete recovery using RMAN. You execute the following RUN block:RUN{SET UNTIL SCN 1107600;RESTORE DATABASE;RECOVER DATABASE;}Wh
阅读全文
摘要:You are working in an online transaction processing (OLTP) environment. You use theFLASHBACKTABLE command to flash back the CUSTOMERS table. Before ex
阅读全文
摘要: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
阅读全文
摘要: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
阅读全文
摘要:Which of these are valid Flashback Database recovery point parameters? (Choose all that apply.)A. SCNB. TimestampC. Named recovery pointD. Transaction
阅读全文
摘要:Which method could be utilized to identify both DML operations and the SQL statements needed toundo those operations for a specific schema owner? (Cho
阅读全文
摘要: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
阅读全文
摘要: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
阅读全文
摘要: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
阅读全文
摘要: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
阅读全文
摘要: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
阅读全文
摘要:What methods of point-in-time recovery are available? (Choose all that apply.)A. Change-basedB. Cancel-basedC. Time-basedD. Sequence number-basedE. Tr
阅读全文
摘要: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
阅读全文
浙公网安备 33010602011771号