When an UNDO segment is created manually by you, its availability status is set to which of the following automatically by Oracle?（）A、Online B、Pending online C、Offline D、Stale
When an UNDO segment is created manually by you, its availability status is set to which of the following automatically by Oracle?（）
- A、Online
- B、Pending online
- C、Offline
- D、Stale
相关考题：
–____________________ –It’s September 10th. A.When is National DayB.When is Labor’s DayC.When is Teacher’s DayD. When is Christmas Day
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.
How would you pass a red buoy in the maritime buoyage system “A”?______.A.keep the buoy on the vessel’s starboard side when approaching a port and on the vessel’s port side when leavingB.keep the buoy on the vessel’s port side when approaching a port and on the vessel’s starboard side when leavingC.keep the buoy on the vessel’s starboard side when approaching and leavingD.keep the buoy on the vessel’s port side when approaching and leaving
当UNDO_RETENTION参数被设置为1000时，下列叙述正确的是（）。A、Undo数据每隔1000s刷新一次B、1000s过后Undo数据会被永久保存C、已经提交的Undo数据可以在Undo表空间里保存1000s的时间D、1000s后Undo数据被移动到临时表空间，以便时刻可读
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
When youre performing a tablespace point-in-time recovery， which tablespaces will always be restored to the auxiliary instance？（）A、 The SYSTEM tablespace.B、 The UNDO tablespace.C、 All tablespaces with tables.D、 All tablespaces with indexes.E、 No tablespaces are automatically restored.
You are maintaining your database in Oracle10g. You set the value of the UNDO_RETENTION initialization parameter to zero in the initialization parameter file. What will be the impact of specifying this setting？（） A、 The database will not start.B、 The database will start but will not retain the undo data in the undo segment.C、 The database will start， and the undo segment will contain the undo data for at least one hour.D、 The database will start， and the undo segment will retain the undo data for at least 15 minutes.
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 scenario will you use the Flashback Transaction Query feature？（）A、 when you want to restore an important table that is dropped from the Recycle BinB、 when you want to obtain the SQL statements to undo the deletion of some important records from a table by a transactionC、when you want to restore a dropped user’s schemaD、 when a row of a table is updated many times within a specific time period and you want all the versions of the row in the specified time period
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.
What is true if you want to switch undo tablespaces from the current one， called UNDO1， to a new one called UNDO2？（）A、It is NOT possible to switch unless no active transaction exist in UNDO1. B、It is possible to switch to UNDO2； but current active transactions will abort. C、It is possible to switch to UNDO2； current active transactions will be automatically migrated to UNDO2. D、It is possible to switch to UNDO2； only current active transactions will continue to execute inside UNDO1.
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 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
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 two statements are true regarding transactions in an Oracle database（）AMultiple transactions can use the same undo segment.BA transaction is assigned an undo segment when it is started.CMore than one transaction cannot share the same extent in the undo tablespace.DThe transactions use system undo segment to store undo data if all the segments in the undo tablespaceare used.
单选题When an UNDO segment is created manually by you, its availability status is set to which of the following automatically by Oracle?（）AOnline BPending online COffline DStale
单选题Users in your PROD database complain about the slow response of the transactions. While investigating the reason， you find that the transactions are waiting for the undo segments to be available， and undo retention has been set to zero. What would you do to overcome this problem？（）Aincrease the undo retentionBcreate more undo segmentsCcreate another undo tablespaceDincrease the size of the undo tablespace
单选题在oracle数据库中，数据库配置为自动undo表空间管理和undo_retention 900s，执行下面的命令确保undo强制保留策略。SQLALTER TABLESPACE undotbs1 RETENTION GUARANTEE；此命令对数据库有什么影响？（）A包含commit数据的undo extent不能被重写，直到下次实例重启B非空的undo表空间extent一直保留数据直到下次全库备份C包含commit数据的undo extent保留至少15分钟不能被重写D包含commit数据的undo extent不能被重写，直到刷新到快速回复区
单选题What is true if you want to switch undo tablespaces from the current one， called UNDO1， to a new one called UNDO2？（）AIt is NOT possible to switch unless no active transaction exist in UNDO1. BIt is possible to switch to UNDO2； but current active transactions will abort. CIt is possible to switch to UNDO2； current active transactions will be automatically migrated to UNDO2. DIt is possible to switch to UNDO2； only current active transactions will continue to execute inside UNDO1.
多选题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.
单选题When determining the number of UNDO segments in a database, which of the following choices identifies a factor to consider? （）ASize of typical transactions BConcurrent transactions CSize of rows in table most frequently changed DNumber of anticipated disk sorts
单选题Which statement is true about the UNDO_RETENTION parameter when retention guarantee is notenabled（）AIt is the time period after which the undo data becomes obsolete.BIt is the time period after which the committed undo data would be transferred to a temporarytablespace.CIt is the minimum time period up to which the committed undo data would be retained if free undo spaceis available.DIt 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（）AIt is the time period after which the undo data becomes obsolete.BIt is the time period after which the committed undo data would be transferred to a temporary tablespace.CIt is the minimum time period up to which the committed undo data would be retained if free undo space isavailable.DIt is the time period after which the undo data is transferred to the Flash Recovery Area to provide readconsistency.
单选题You work as a database administrator for Supportcenter.cn. Your database is configured for automatic undo management. UNDO_RETENTION is set to 3 hours. You want to flash back a table that was created last year. How far back can the flashback query go？（）A3 hoursB6 monthsCuntil last yearDuntil last commitEuntil the point when the undotablespacewas refreshedFuntil the database is shut down and the memory erased
单选题In which situation is the UNDO_RETENTION parameter be ignored， even if it is set to a value（）AWhen the data file of the undo tablespace is autoextensibleBWhen there are more than one undo tablespaces available in the databaseCWhen the undo tablespace is of a fixed size and retention guarantee is not enabledDWhen 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?（）AThe data is decrypted during SORT and JOIN operations.BThe data remains encrypted when it is read into memory.CThe data remains encrypted when it is stored in the redo logs.DThe data remains encrypted in the UNDO tablespace provided that the UNDO tablespace was created with the encryption option enabled.
单选题How would you pass a red buoy in the maritime buoyage system“A” （）.Akeep the buoy on the vessel's starboard side when approaching a port and on the vessel's port side when leavingBkeep the buoy on the vessel's port side when approaching a port and on the vessel's starboard side when leavingCkeep the buoy on the vessel's starboard side when approaching and leavingDkeep the buoy on the vessel's port side when approaching and leaving
单选题In which scenario will you use the Flashback Transaction Query feature？（）A when you want to restore an important table that is dropped from the Recycle BinB when you want to obtain the SQL statements to undo the deletion of some important records from a table by a transactionCwhen you want to restore a dropped user’s schemaD when a row of a table is updated many times within a specific time period and you want all the versions of the row in the specified time period