网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
多选题
Which 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
参考答案
参考解析
解析：
暂无解析
更多 “多选题Which 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” 相关考题
考题
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.
考题
Which two are the prerequisites to enable Flashback Data Archive?() (Choose two.)
A. Database must be running in archivelog mode.B. Automatic undo management must be enabled.C. Undo retention guarantee must be enabled.D. The tablespace on which the Flashback Data Archive is created must be managed with Automatic Segment Space Management (ASSM).
考题
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
考题
Which are the two prerequisites before setting up Flashback Data Archive? （）(Choose two.)A、Flash recovery area must be definedB、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).
考题
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.
考题
Your database is running under automatic undo management and the UNDO_RETENTION parameter is set to 900 sec. You executed the following command to enable retention guarantee： SQL ALTER TABLESPACE undotbs1 RETENTION GUARANTEE; What effect would this statement have on the database？（）A、The extents in undo tablespace retain data until the next full database backup.B、The extents containing committed data in the undo tablespace are never overwritten.C、The extents which no longer contain uncommitted data in the undo tablespace are not overwritten for at least15 minutes.D、The extents containing committed data in the undo tablespace are not overwritten until the instance is shut down.
考题
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.
考题
Which two statements are true regarding transactions in an Oracle database（）A、Multiple transactions can use the same undo segment.B、A transaction is assigned an undo segment when it is started.C、More than one transaction cannot share the same extent in the undo tablespace.D、The transactions use system undo segment to store undo data if all the segments in the undo tablespaceare used.
考题
Which three operations require undo data（）A、committing a transactionB、flashing back a transactionC、recovering a failed transactionD、running a read-consistent queryE、changing a tablespace status from READ ONLY to READ WRITE
考题
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.
考题
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.
考题
You find pockets of empty space in the USER_DATA tablespace due to a lot of DML operations on the objects in the USER_DATAtablespace. The pockets of empty spaces are too small to be reused individually. This is leading to wastage of space. You decide to perform the shrink operation to reclaim the wasted space. Which advisor will you use to determine the objects in the USER_DATA tablespace that are good candidates for the shrink operation？（）A、 SQL Tuning AdvisorB、 SQL Access AdvisorC、 Undo AdvisorD、 Segment Advisor
考题
Which of the following operations does not require Oracle to store information in an UNDO segments as part of the transaction?（）A、INSERT B、SELECT C、UPDATE D、DELETE
考题
Which two are the prerequisites to enable Flashback Data Archive？（）A、 Database must be running in archivelog mode.B、 Automatic undo management must be enabled.C、 Undo retention guarantee must be enabled.D、 The tablespace on which the Flashback Data Archive is created must be managed with Automatic Segment Space Management （ASSM）.
考题
The UNDO_RETENTION parameter in your database is set to 1000 and undo retention 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 every 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 UNDO tablespace for 1，000 seconds，then it gets moved to the TEMPORARY tablespace to provide read consistency.
考题
单选题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.
考题
多选题Which two operations require undo data？（）Acommitting a transactionBrolling back a transactionCrecovering from failed transactionsDrecording a transaction to redo log filesErolling forward during instance recovery
考题
多选题You require the Oracle server to manage the undo segments and space among various active sessions automatically. You created an undo tablespace， UNDO_TBS1， in your database. Which two additional steps would you perform to achieve this？（）ASet the UNDO_RETENTION parameter to 900 or more.BCreate an initial undo segment in the undo tablespace.CEnable the retention guarantee for the undo tablespace.DSet the UNDO_TABLESPACE parameter to UNDO_TBS1.ESet the UNDO_MANAGEMENT initialization parameter to AUTO.
考题
单选题Your database is running under automatic undo management and the UNDO_RETENTION parameter is set to 900 sec. You executed the following command to enable retention guarantee： SQL ALTER TABLESPACE undotbs1 RETENTION GUARANTEE; What effect would this statement have on the database？（）A
The extents in undo tablespace retain data until the next full database backup.B
The extents containing committed data in the undo tablespace are never overwritten.C
The extents which no longer contain uncommitted data in the undo tablespace are not overwritten for at least15 minutes.D
The extents containing committed data in the undo tablespace are not overwritten until the instance is shut down.
考题
单选题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.
考题
单选题Which statement is true about the UNDO_RETENTION parameter when retention guarantee is not enabled（）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 temporary tablespace.C
It is the minimum time period up to which the committed undo data would be retained if free undo space isavailable.D
It is the time period after which the undo data is transferred to the Flash Recovery Area to provide readconsistency.
考题
单选题In which situation may the UNDO_RETENTION parameter be ignored， even if it is set to a value（）A
when the data file of the undo tablespace is autoextensibleB
when there are more than one undo tablespaces available in the databaseC
when the undo tablespace is of a fixed size and retention guarantee is not enabledD
when the undo tablespace is autoextensible and retention guarantee is not enabled
考题
单选题In which situation is the UNDO_RETENTION parameter be ignored， even if it is set to a value（）A
When the data file of the undo tablespace is autoextensibleB
When there are more than one undo tablespaces available in the databaseC
When the undo tablespace is of a fixed size and retention guarantee is not enabledD
When the undo tablespace is autoextensible and retention guarantee is not enabled
考题
单选题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.
考题
单选题The UNDO_RETENTION parameter in your database is set to 1000 and undo retention 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 every 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 UNDO tablespace for 1，000 seconds，then it gets moved to the TEMPORARY tablespace to provide read consistency.
考题
多选题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
考题
单选题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.
热门标签
最新试卷