CMS专题
多选题Which three operations require undo data（）Acommitting a transactionBflashing back a transactionCrecovering a failed transactionDrunning a read-consistent queryEchanging a tablespace status from READ ONLY to READ WRITE
题目
committing a transaction
flashing back a transaction
recovering a failed transaction
running a read-consistent query
changing a tablespace status from READ ONLY to READ WRITE
参考答案和解析
相似问题和答案
第1题：
Which three wireless service components belong to the operate phase？（）
- A、operations plan
- B、operations assessment
- C、security administration
- D、system monitoring
- E、operations implementation
- F、incident management
正确答案:C,D,F
第2题：
Which three service components belong to the operate phase（）
- A、Change Management
- B、Operations Implementation
- C、System monitoring
- D、Incident Management
- E、Operations Assessment
正确答案:A,C,D
第3题：
ENCRYPT_TS is an encrypted tablespace that contains tables with data. Which statement is true regarding the effect of queries and data manipulation language (DML) statements on the encrypted data in the tables?（）
A. The data is decrypted during SORT and JOIN operations.
B. The data remains encrypted when it is read into memory.
C. The data remains encrypted when it is stored in the redo logs.
D. The data remains encrypted in the UNDO tablespace provided that the UNDO tablespace was created with the encryption option enabled.
第4题：
Which statement is true about the UNDO_RETENTION parameter when retention guarantee is notenabled（）
- A、It is the time period after which the undo data becomes obsolete.
- B、It is the time period after which the committed undo data would be transferred to a temporarytablespace.
- C、It is the minimum time period up to which the committed undo data would be retained if free undo spaceis available.
- D、It is the time period after which the undo data is transferred to the Flash Recovery Area to provide readconsistency.
正确答案:C
第5题：
You work as a database administrator for Certkiller .com. The UNDO_RETENTION parameter in your database is set to 1000 and undoretention is not guaranteed. Which statement regarding retention of undo data is correct？（）
- A、Undo data becomes obsolete after 1，000 seconds.
- B、Undo data gets refreshed after 1，000 seconds.
- C、Undo data will be stored permanently after 1，000 seconds.
- D、Committed undo data would be retained for 1，000 seconds if free undo space is available.
- E、Undo data will be retained in the UNDOtablespacefor 1，000 seconds， then it gets movedmovedto the TEMPORARYtablespaceto provide read consistency.
正确答案:D
第6题：
ou need to create a data block for query operations in the RETIRED_EMPLOYEES form module. Which three data sources can you use for this block?（）
- A、vector
- B、database view
- C、database table
- D、transactional trigger
- E、PL/SQL table of records
- F、multi-dimensional array
正确答案:B,C,D
第7题：
In your database， UNDO_RETENTION has been set to 600 sec and UNDO tablespace is configured for RETENTION GUARANTEE. Which statement regarding RETENTION GUARANTEE is true？ （）
- A、Undo data is retained until the next full database backup.
- B、No committed undo data will be overwritten for 10 minutes.
- C、Committed undo data will be kept forever if not overwritten within 600 seconds.
- D、Guarantees that requested undo information are available until the instance is shut down.
正确答案:B
第8题：
You must track all transactions that modify certain tables in the sales schema for at least three years.Automatic undo management is enabled for the database with a retention of one day.Which two must you do to track the transactions?（）
A. Enable supplemental logging for the database.
B. Specify undo retention guarantee for the database.
C. Create a Flashback Data Archive in the tablespace where the tables are stored.
D. Create a Flashback Data Archive in any suitable tablespace.
E. Enable Flashback Data Archiving for the tables that require tracking
第9题：
Which three operations require undo data（）
- A、committing a transaction
- B、flashing back a transaction
- C、recovering a failed transaction
- D、running a read-consistent query
- E、changing a tablespace status from READ ONLY to READ WRITE
正确答案:B,C,D
第10题：
You are working as a DBA on the decision support system. There is a business requirement to track and store all transactions for at least three years for a few tables in the database. Automatic undo management is enabled in the database. Which configuration should you use to accomplish this task？（）
- A、 Enable Flashback Data Archive for the tables.
- B、 Specify undo retention guarantee for the database.
- C、 Enable supplemental logging for the database.
- D、 Query V$UNDOSTAT to determine the amount of undo that will be generated and create an undo tablespace for that size.
- E、 Create Flashback Data Archive on the tablespace on which the tables are stored.
正确答案:A