1Z0-060
多选题Which two are prerequisites for performing a flashback transaction?（）AFlashback Database must be enabled.BUndo retention guarantee for the database must be configured.CEXECUTE privilege on the DBMS_FLASHBACK package must be granted to the user flashing
题目
Flashback Database must be enabled.
Undo retention guarantee for the database must be configured.
EXECUTE privilege on the DBMS_FLASHBACK package must be granted to the user flashing back transaction.
Supplemental logging must be enabled.
Recycle bin must be enabled for the database.
Block change tracking must be enabled tor the database.
相似问题和答案
第1题：
A. Flash recovery area must be defined
B. Undo retention guarantee must be enabled.
C. Database must be running in archivelog mode.
D. Automatic undo management must be enabled.
E. The tablespace in which the Flashback Data Archive is created must have automatic segment space Management (ASSM).
第2题：
A. Flashback Database must be enabled.
B. Undo retention guarantee for the database must be configured.
C. EXECUTE 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. Block change tracking must be enabled tor the database.
第3题：
A. ALTER DATABASE FLASHBACK ON;
B. GRANT SELECT any transaction TO scott;
C. GRANT EXECUTE ON dbms_flashback TO scott;
D. ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;
E. ALTER TABLESPACE undots1 RETENTION GUARANTEE;
F. ALTER DATABASE ADD SUPPLEMENTAL LOG DATA (PRIMARY KEY) COLUMNS;
第4题：
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
正确答案:A,B
第5题：
What two are the prerequisites for enabling Flashback Database?（） (Choose two)
- 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
正确答案:A,B
第6题：
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
第7题：
User SCOTT wants to back out the transactions on the REGIONS table in his schema. As a DBA, which commands must you execute to enable SCOTT to flash back the transactions?（）
- A、ALTER DATABASE FLASHBACK ON;
- B、GRANT SELECT any transaction TO scott;
- C、GRANT EXECUTE ON dbms_flashback TO scott;
- D、ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;
- E、ALTER TABLESPACE undots1 RETENTION GUARANTEE;
- F、ALTER DATABASE ADD SUPPLEMENTAL LOG DATA (PRIMARY KEY) COLUMNS;
正确答案:B,C,D,F
第8题：
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
第9题：
Which are the prerequisites for performing flashback transactions on your database？（）
- A、 Undo retention guarantee for the database must be configured.
- B、 Supplemental log must be enabled for the primary key.
- C、 Supplemental log must be enabled.
- D、 Execute permission on the DBMS_FLASHBACK package must be granted to the user.
正确答案:B,C,D
第10题：
Which are the two prerequisites before setting up Flashback Data Archive? （）(Choose two.)
- A、Flash recovery area must be defined
- B、Undo retention guarantee must be enabled.
- C、Database must be running in archivelog mode.
- D、Automatic undo management must be enabled.
- E、The tablespace in which the Flashback Data Archive is created must have automatic segment space Management (ASSM).
正确答案:D,E