OCP 11G认证考试
多选题What two are the prerequisites for enabling Flashback Database?（）AThe database must be in ARCHIVELOG modeBThe database must be in MOUNT EXCLUSIVE modeCThe database must be opened in RESTRICTED modeDThe database instance must be started in the NOMOUNT s
题目
The database must be in ARCHIVELOG mode
The database must be in MOUNT EXCLUSIVE mode
The database must be opened in RESTRICTED mode
The database instance must be started in the NOMOUNT state
The database instance must have the keep buffer pool defined
参考答案和解析
相似问题和答案
第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.Delivering information about changes in health benefit enrollment to all personnel
B.Enabling online collaboration among research personnel
C.Enabling an interactive virtual classroom for sales personnel in remote locations
D.Delivering a strategic business update from the CEO to all personnel
第3题：
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
第4题：
What are two interfaces created when enabling a chassis cluster？（）
- A、st0
- B、fxp1
- C、fab0
- D、reth0
正确答案:B,C
第5题：
Which of the following statements best describes Flashback Versions Query？（）
- A、 Flashback Versions Query is used to make changes to multiple versions of data that existed between two points in time.
- B、 Flashback Versions Query is used to view all version changes on rows that existed between the time the query was executed and a point in time in the past.
- C、 Flashback Versions Query is used to view version changes and the SQL to undo those changes on rows that existed between two points in time.
- D、 Flashback Versions Query is used to view all version changes on rows that existed between two points in time.
正确答案:D
第6题：
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.
第7题：
What are two appropriate uses for Internet Protocol TV broadcasting (IP/TV) technology? （）
- A、Enabling online collaboration among research personnel
- B、Delivering a strategic business update from the CEO to all personnel
- C、Enabling an interactive virtual classroom for sales personnel in remote locations
- D、Delivering information about changes in health benefit enrollment to all personnel
正确答案:B,D
第8题：
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.
第9题：
Refer to the exhibit. What is the configuration an example of？（）
- A、enabling modular QoS over Frame Relay
- B、enabling Real-Time Transport Protocol （RTP） header compression
- C、enabling distributed compressed Transmission Control Protocol
- D、enabling latency and jitter reduction for Transmission Control traffic
- E、enabling TCP header compression
正确答案:E
第10题：
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