随笔分类 - Flashback
摘要：On Friday at 11:30 am you decided to flash back the database because of a user error that occurred at 8:30 am.Which option must you use to check wheth
阅读全文
摘要：You plan to execute the following command to perform a Flashback Database operation in your database:SQL> FLASHBACK DATABASE TO TIMESTAMP (SYSDATE -5/
阅读全文
摘要：The RECYCLEBIN parameter is set to ON for your database. You drop a table, PRODUCTS, from the SCOTT schema.Which two statements are true regarding the
阅读全文
摘要：View the exhibit and examine the output. Which statement can be an inference from the output?Exhibit: A. The FRA disk group has an asynchronous I/O bo
阅读全文
摘要：What are the prerequisites for performing flashback transactions? (Choose all that apply)A.Supplemental log must be enabledB.Supplemental log must be
阅读全文
摘要：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
阅读全文
摘要：You execute the following FLASHBACK TABLE command: Which two statements are correct?(Choose two.)A.The EMP table that was dropped by mistake earlier i
阅读全文
摘要：To clean up old records that are in a Flashback Data Archive and are past the retention period, what must the DBA do?A. TRUNCATE the archive table.B.
阅读全文
摘要：When setting up the Flashback Data Archive, which of these key parameters are required? (Choose all that apply.)A. Tablespace nameB. Storage quotaC. R
阅读全文
摘要：Which of these are valid Flashback Database recovery point parameters? (Choose all that apply.)A. SCNB. TimestampC. Named recovery pointD. Transaction
阅读全文
摘要：The _______ writes the Flashback Database logs in the flash recovery area.A. FLSHB. FLDBC. RVWRD. RVRWE. FBDA The Flashback Database architecture cons
阅读全文
摘要：Flashback Database relies on which technologies to recover to a point in time?A. Flashback Data ArchiveB. Flashback logs in the flash recovery areaC.
阅读全文
摘要：Which method could be utilized to identify both DML operations and the SQL statements needed toundo those operations for a specific schema owner? (Cho
阅读全文
摘要：You have just performed a FLASHBACK TABLE operation using the following command:flashback table employees to scn 123456;The employees table has trigge
阅读全文
摘要：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 statements is true regarding the VERSIONS BETWEEN clause?A. The VERSIONS BETWEEN clause may be used in DML statements.B. The VE
阅读全文
摘要：At the request of a user, you issue the following command to restore a dropped table: flashback table "BIN$F2JFfMq8Q5unbC0ceE9eJg==$0" to before drop;
阅读全文
摘要：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
阅读全文
摘要：Which pseudocolumn could you use to identify a unique row in a Flashback Versions Query?A. XIDB. VERSIONS_PKC. VERSIONS_XIDD. VERSIONS_UNIQUE
阅读全文
摘要：Which of the following statements best describes Flashback Versions Query?A. Flashback Versions Query is used to make changes to multiple versions of
阅读全文
浙公网安备 33010602011771号