网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
多选题
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
参考答案
参考解析
解析：
暂无解析
更多 “多选题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” 相关考题
考题
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.
考题
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 three wireless service components belong to the operate phase？（）A、operations planB、operations assessmentC、security administrationD、system monitoringE、operations implementationF、incident management
考题
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
考题
Which three service components belong to the operate phase（）A、Change ManagementB、Operations ImplementationC、System monitoringD、Incident ManagementE、Operations Assessment
考题
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.
考题
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 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.
考题
Which three descriptions are correct about the effects of the TRUNCATE command on a table（）A、The corresponding indexes for the table are also truncated.B、Delete triggers on the table are fired during the execution of the TRUNCATE command.C、The child table is truncated when the TRUNCATE command is applied on the parent table.D、The high-water mark （HWM） is set to point to the first usable data block in the table segment.E、No undo or very little undo data is generated during the execution of the TRUNCATE command
考题
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 three statements are true about database recovery operations？（）A、Damaged or lost data files are restored from backups.B、Redo log file entries are used to roll forward the database.C、Undo segments are used to roll back any uncommitted transactions.D、Transactions that were active when the failure occurred are restarted.E、Transactions that were active when the failure occurred are automatically committed during the recover procedure.
考题
Which 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 three types of information does the control file contain？（）A、Current log sequence.B、Recover tuning parameters.C、Redo log names and locations.D、Data file names and locations.E、Undo segment names and locations.
考题
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 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.
考题
多选题Identify three situations in which you would NOT be able to drop a tablespace. （）Awhen the tablespace is onlineBwhen the tablespace has segments with data in itCwhen the tablespace is a default permanent tablespace for the databaseDwhen the tablespace contains a table that is currently being used by transactionsEwhen the tablespace contains undo data that is needed to rollback an uncommitted transaction
考题
多选题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?（）AvectorBdatabase viewCdatabase tableDtransactional triggerEPL/SQL table of recordsFmulti-dimensional array
考题
单选题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.
考题
单选题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 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
热门标签
最新试卷
