单选题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 tablespac

题目

单选题

In which situation is the UNDO_RETENTION parameter be ignored， even if it is set to a value（）

When the data file of the undo tablespace is autoextensible

When there are more than one undo tablespaces available in the database

When the undo tablespace is of a fixed size and retention guarantee is not enabled

When the undo tablespace is autoextensible and retention guarantee is not enabled

如果没有搜索结果或未解决您的问题，请直接联系老师获取答案。

相似问题和答案

第1题：

The EMP table exists in your schema. You want to execute the following query:SELECT ename, salFROM empAS OF TIMESTAMP (SYSTIMESTAMP - INTERVAL ‘6‘ MINUTE)WHERE ename = ‘ALLEN‘;What are the minimum requirements for the statement to execute successfully? （）

A. ARCHIVELOG mode must be enabled

B. Row Movement must be enabled for the table

C. FLASHBACK must be set to ON for the database

D. The UNDO_MANAGEMENT parameter must be set to AUTO

E. The UNDO_RETENTION parameter must be set appropriately

参考答案：D, E

第2题：

The author suggests that a mathematician asked to solve a problem in an ill-defined situation would first attempt to do which of the following？( )

A.Identify an analogous situation
B.Simplify and define the situation
C.Vary the underlying assumptions of a description of the situation
D.Determine what use would be made of the solution provided

答案：B

解析：

第3题：

The human can react to any situation, some of which he may never have imagined.()

参考答案：正确

第4题：

You are working on a test database where instance recovery takes a considerable amount of time.How can reduce the recovery time？（）

A、By multiplexing the control files
B、By multiplexing the redo log files
C、By decreasing the size of redo log files
D、By configuring mean time to recover （MTTR） to a lower value
E、By setting the UNDO_RETENTION parameter to a higher value

正确答案:C,D

第5题：

On Friday at 11:30 am you decided to flash back the database because of a user error that occurred at 8:30 am. Which option must you use to check whether a flashback operation can recover the database to the specified time? （）

A、Check the alert log file
B、Query the V$FLASHBACK_DATABASE_LOG view
C、Query the V$RECOVERY_FILE_DEST_SIZE view
D、Query the V$FLASHBACK_DATABASE_STAT view
E、Check the value assigned for the UNDO_RETENTION parameter

正确答案:B

第6题：

The author suggests that a mathematician asked to solve a problem in an ill-defined situation would first attempt to do which of the following？( )

A.Identify an analogous situation.
B.Simplify and define the situation.
C.Vary the underlying assumptions of a description of the situation.
D.Determine what use would be made of the solution provided.

答案：B

解析：

第7题：

The remote host parameter configured on the LNS must match which parameter on the LAC?（）

A、hostname
B、host
C、client-name
D、remote-host

正确答案:C

第8题：

A. Check the alert log file

B. Query the V$FLASHBACK_DATABASE_LOG view

C. Query the V$RECOVERY_FILE_DEST_SIZE view

D.Query the V$FLASHBACK_DATABASE_STAT view

E. Check the value assigned for the UNDO_RETENTION parameter

参考答案：B

第9题：

Which statement regarding the contents of the V$PARAMETER view is true？（）

A、displays only the list of default values
B、displays only the list of all basic parameters
C、displays the currently in effect parameter values
D、displays only the list of all advanced parameters
E、displays the list of all the parameter files of a database

正确答案:C

第10题：

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

In which situation is the UNDO_RETENTION parameter be ignore

题目

相似问题和答案

更多相关问题

相关内容