Flash back
查看答案
相关试题
换一换
Note the following statements that use flashback technology: 1. FLASHBACK TABLE TO SCN ; 2. SELECT * FROM AS OF SCN 123456; 3. FLASHBACK TABLE TO BEFORE DROP; 4. FLASHBACK DATABASE TO TIMESTAMP ; 5. SELECT * FROM VERSIONS AS OF SCN 123456 AND 123999; Which of these statements will be dependent on the availability of relevant undo data in the undo segment?（）
A.1, 2, and 5 B.1, 3, and 4 C.2, 3, 4, and 5 D.1, 2, 3, 4, and 5
答案
You enabled Flashback Data Archive on the INVENTORY table.Which DDL operation is supported on the table after enabling Flashback Data Archive?（）
A.Drop the table. B.Partition the table C.Truncate the table. D.Add a column to the table. E.Rename a column in the table.
答案
You enabled Flashback Data Archive on the INVENTORY table.Which DDL operation is supported on the table after enabling Flashback Data Archive?（）
A.rop the table. B.Partition the table C.Truncate the table. D.dd a column to the table. E.Rename a column in the table.
答案
As to the functions of a flashback, which of the following statements is true（）
A.It weakens inner conflict B.It decreases tension C.It may spoil the complete story D.It is to convey to the readers information regarding the character’s background
答案
Which two are prerequisites for performing a flashback transaction?（）
A.lashback Database must be enabled. B.Undo retention guarantee for the database must be configured. C.XECUTE privilege on the DBMS_FLASHBACK package must be granted to the user flashing back transaction. D.Supplemental logging must be enabled. E.Recycle bin must be enabled for the database. F.lock change tracking must be enabled tor the database.
答案
What two are the prerequisites for enabling Flashback Database?（）
A.The database must be in ARCHIVELOG mode B.The database must be in MOUNT EXCLUSIVE mode C.The database must be opened in RESTRICTED mode D.The database instance must be started in the NOMOUNT state E.The database instance must have the keep buffer pool defined
答案
For narrative, we use the most is flashback.
答案
What do you think of the flashback narrative in Titanic（）
A.It is only a small episode, which lasts only a few minutes B.The flashback is as long enough as to go through the whole movie C.The narrator is Rose’s granddaughter D.It is insignificant
答案
Which three statements are true about Flashback Database?（）
A.lashback logs are written sequentially, and are archived. B.lashback Database uses a restored control file to recover a database. C.The Oracle database automatically creates, deletes, and resides flashback logs in the Fast RecoveryArea. D.lashback Database can recover a database to the state that it was in before a reset logs operation. E.lashback Database can recover a data file that was dropped during the span of time of the flashback. F.lashback logs are used to restore to the blocks' before images, and then the redo data may be used to roll forward to the desired flashback time.
答案
Which three actions are required to configure the Flashback Database? （）
A.set Flash Recovery Area B.enable Flashback logging C.create FLASHBACK tablespace D.start the database in the ARCHIVELOG mode E.start the database in the NOARCHIVELOG mode
答案
热门试题
Which one of the following statements about flashback is not true?
You plan to execute the following command to perform a Flashback Database operation in your database: SQL> FLASHBACK DATABASE TO TIMESTAMP (SYSDATE -5/24); Which two statements are true about this?（）
What are the prerequisites for performing flashback transactions? （）(Choose all that apply)
Which two statements regarding the Flashback Table feature are correct?（）
What two are the prerequisites for enabling Flashback Database?（） (Choose two)
You want to flash back a test database by five hours.You issue this command:SQL > FLASHBACK DATABASE TO TIMESTAMP (SYSDATE - 5/24);Which two statements are true about this flashback scenario?（）
What does the DB_FLASHBACK_RETENTION_TARGET parameter configure?（）
Which background process sequentially writes Flashback Database data from the flashback buffer to the Flashback Database logs？（）
What is the result of executing a TRUNCATE TABLE command on a table that has Flashback Archivingenabled?（）
Which two are the prerequisites to enable Flashback Data Archive?（） (Choose two.)
On which two database objects can the VERSIONS clause of the Flashback Versions Query be used?（）
Which are the two prerequisites before setting up Flashback Data Archive? （）(Choose two.)
Which three statements are true about using flashback database in a multitenant container database(CDB)?（）
Which are the two prerequisites before setting up Flashback Data Archive? （）(Choose two.)
You executed the following query in your database： SELECT oldest_flashback_scn， oldest_flashback_time FROM V$FLASHBACK_DATABASE_LOG； What would you determine from the output？（）
You are working in an online transaction processing (OLTP) environment. You use the FLASHBACKTABLE command to flash back the CUSTOMERS table. Before executing the FLASHBACK TABLE command, the system change number (SCN) was 663571. After flashing back the CUSTOMERS table, you realize that the table is not in the correct state. Now, you need to reverse the effects of the FLASHBACK TABLE command. Which is the fastest and the most efficient option to reverse the effects of the FLASHBACK TABLE command?（）
You are working in an online transaction processing (OLTP) environment. You use the FLASHBACKTABLE command to flash back the CUSTOMERS table. Before executing the FLASHBACK TABLE command, the system change number (SCN) was 663571. After flashing back the CUSTOMERS table, you realize that the table is not in the correct state. Now, you need to reverse the effects of the FLASHBACK TABLE command. Which is the fastest and the most efficient option to reverse the effects of the FLASHBACK TABLE command?（）
You executed the following query in your database： SELECT oldest_flashback_scn， oldest_flashback_time FROM V$FLASHBACK_DATABASE_LOG； What would you determine from the output？（）
Where does flashback often appear?: In a narrative.|In an academic paper.|In an argumentation.|In an exposition.
For which two database objects can the VERSIONS clause of the Flashback Versions Query be used?（）(Choose two.)
使用微信扫一扫登录
