Oracle认证考试
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
相似问题和答案
第1题：
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 leaving
B.keep the buoy on the vessel’s port side when approaching a port and on the vessel’s starboard side when leaving
C.keep the buoy on the vessel’s starboard side when approaching and leaving
D.keep the buoy on the vessel’s port side when approaching and leaving
在海上浮标系统A区中，如何通过一个红色浮标？当驶进港口时，保持浮标在船舶的左侧，驶离港口时，保持浮标在船舶右侧。
第2题：
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 autoextensible
- B、When there are more than one undo tablespaces available in the database
- C、When the undo tablespace is of a fixed size and retention guarantee is not enabled
- D、When the undo tablespace is autoextensible and retention guarantee is not enabled
正确答案:C
第3题：
A.When is National Day
B.When is Labor’s Day
C.When is Teacher’s Day
D. When is Christmas Day
第4题：
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 Bin
- B、 when you want to obtain the SQL statements to undo the deletion of some important records from a table by a transaction
- C、when you want to restore a dropped user’s schema
- D、 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
正确答案:B
第5题：
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.
正确答案:D
第6题：
当UNDO_RETENTION参数被设置为1000时，下列叙述正确的是（）。
- A、Undo数据每隔1000s刷新一次
- B、1000s过后Undo数据会被永久保存
- C、已经提交的Undo数据可以在Undo表空间里保存1000s的时间
- D、1000s后Undo数据被移动到临时表空间，以便时刻可读
正确答案:C
第7题：
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.
正确答案:A,B
第8题：
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.
第9题：
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 autoextensible
- B、when there are more than one undo tablespaces available in the database
- C、when the undo tablespace is of a fixed size and retention guarantee is not enabled
- D、when the undo tablespace is autoextensible and retention guarantee is not enabled
正确答案:C
第10题：
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.
正确答案:A,B