网友您好, 请在下方输入框内输入要搜索的题目:

题目内容 (请给出正确答案)
单选题
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


参考答案

参考解析
解析: 暂无解析
更多 “单选题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” 相关考题
考题 The human can react to any situation, some of which he may never have imagined.()

考题 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 fileB. Query the V$FLASHBACK_DATABASE_LOG viewC. Query the V$RECOVERY_FILE_DEST_SIZE viewD.Query the V$FLASHBACK_DATABASE_STAT viewE. Check the value assigned for the UNDO_RETENTION parameter

考题 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 enabledB. Row Movement must be enabled for the tableC. FLASHBACK must be set to ON for the databaseD. The UNDO_MANAGEMENT parameter must be set to AUTOE. The UNDO_RETENTION parameter must be set appropriately

考题 Which of the following best summarizes the U. S. economic situation today?[A]American economists are painting a gloomy picture.[B]It is slowly warming up with moderate growth.[C]Recession may come back anytime in the coming months.[D]Most sectors are picking up at a surprisingly fast pace.

考题 According to the passage,mathematicians present a danger to scientists for which of the following reasons?( ) A.Mathematicians may provide theories that are incompatible with those already developed by scientists B.Mathematicians may define situation in a way that is incomprehensible to scientists C.Mathematicians may convince scientists that theoretical assumptions are facts D.Scientists may begin to provide arguments that are convincing but imprecise

考题 According to the passage,mathematicians present a danger to scientists for which of the following reasons?( ) A.Mathematicians may provide theories that are incompatible with those already developed by scientists. B.Mathematicians may define situation in a way that is incomprehensible to scientists. C.Mathematicians may convince scientists that theoretical assumptions are facts. D.Scientists may begin to provide arguments that are convincing but imprecise.

考题 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

考题 The remote host parameter configured on the LNS must match which parameter on the LAC?()A、hostnameB、hostC、client-nameD、remote-host

考题 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 fileB、Query the V$FLASHBACK_DATABASE_LOG viewC、Query the V$RECOVERY_FILE_DEST_SIZE viewD、Query the V$FLASHBACK_DATABASE_STAT viewE、Check the value assigned for the UNDO_RETENTION parameter

考题 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 filesB、By multiplexing the redo log filesC、By decreasing the size of redo log filesD、By configuring mean time to recover (MTTR) to a lower valueE、By setting the UNDO_RETENTION parameter to a higher value

考题 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.

考题 An RMAN backup job fails, displaying the following error:  ORA/x7f19809: limit exceeded for recovery files  Your analysis shows that the Flash Recovery area is full. Which two actions could you take to resolve the error and avoid this error in future?()A、take the backup of the flash recovery area less frequentlyB、increase the value of the UNDO_RETENTION initialization parameterC、change the value of the WORKAREA_SIZE_POLICY initialization parameter to AUTOD、change the backup retention policy to retain the backups for a smaller period of time E、increase the value of the DB_RECOVERY_FILE_DEST_SIZE initialization parameterF、increase the value of the CONTROL_FILE_RECORD_KEEP_TIME initialization parameter

考题 多选题An RMAN backup job fails, displaying the following error:  ORA-19809: limit exceeded for recovery files  Your analysis shows that the Flash Recovery area is full.  Which two actions could you take to resolve the error and avoid this error in the future? ()Atake the backup of the flash recovery area less frequentlyBincrease the value of the UNDO_RETENTION initialization parameterCchange the value of the WORKAREA_SIZE_POLICY initialization parameter to AUTODchange the backup retention policy to retain the backups for a smaller period of timeEincrease the value of the DB_RECOVERY_FILE_DEST_SIZE initialization parameterFincrease the value of the CONTROL_FILE_RECORD_KEEP_TIME initialization parameter

考题 单选题A stand-on vessel is().A required to give way in a crossing situationB required to sound the first passing signal in a meeting situationC free to maneuver in any crossing or meeting situation as it has the right-of-wayD required to maintain course and speed in a crossing situation but may take action to avoid collision

考题 多选题You work as a database administrator for Certkiller .com. You want to create your database with the automatic undo management feature enable.Which two tasks must you perform to achieve this?()ASet the UNDO_RETENTION parameter to AUTO.BCreate an initial undo segment in undotablespace.CSet the UNDO_RETENTION parameter to 900 or moreDSet the initialization parameter UNDO_MANAGEMENT to AUTOESet the UNDO_MANAGEMENT parameter to the name of an undotablespace

考题 多选题Which three pieces of information are considered while deciding the size of the undo tablespace in your database?()Athe size of an undo blockBthe size of the redo log filesCundo blocks generated per secondDthe size of the database buffer cacheEthe value of the UNDO_RETENTION parameter

考题 多选题The EMP table exists in your schema. You want to execute the following query:   SELECT ename, sal FROM emp AS OF TIMESTAMP (SYSTIMESTAMP - INTERVAL ’6’ MINUTE)   WHERE ename = ’ALLEN’;   What are the minimum requirements for the statement to execute successfully?()AARCHIVELOG mode must be enabledBRow Movement must be enabled for the tableCFLASHBACK must be set to ON for the databaseDThe UNDO_MANAGEMENT parameter must be set to AUTOEThe UNDO_RETENTION parameter must be set appropriately

考题 多选题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.

考题 单选题The remote host parameter configured on the LNS must match which parameter on the LAC?()A hostnameB hostC client-nameD remote-host

考题 单选题The database is being restored from a closed backup. The data files, control files, password file, and parameter file are available, but the online redo logs are not. Because the online redo logs are not available, you must simulate recovery and alter the database open with the reset logs option so the online redo logs are created while the database opens. Which type of recover is used in this situation?()A until SCNB until timeC until cancelD using backup control file

考题 问答题Practice 1  When a new movement in art attains a certain fashion, it is advisable to find out what its advocates are aiming at, for, however farfetched and unreasonable their principles may seem today, it is possible that in years to come they may be regarded as normal. With regard to Futurist poetry, however, the case is rather difficult, for whatever Futurist poetry may be even admitting that the theory on which it is based may be right, it can hardly be classed as Literature.  This, in brief, is what the Futurist says. Over one century, the life situation in the past had been changed rapidly. And now, we live in the world which is full of noise, violence and speed.

考题 单选题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.

考题 多选题An RMAN backup job fails, displaying the following error:  ORA/x7f19809: limit exceeded for recovery files  Your analysis shows that the Flash Recovery area is full. Which two actions could you take to resolve the error and avoid this error in future?()Atake the backup of the flash recovery area less frequentlyBincrease the value of the UNDO_RETENTION initialization parameterCchange the value of the WORKAREA_SIZE_POLICY initialization parameter to AUTODchange the backup retention policy to retain the backups for a smaller period of timeEincrease the value of the DB_RECOVERY_FILE_DEST_SIZE initialization parameterFincrease the value of the CONTROL_FILE_RECORD_KEEP_TIME initialization parameter

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

考题 单选题Although some countries have taken action to solve the shortage of water,it may be sometime_____ the situation improves•A beforeB whenC sinceD until

考题 单选题On Friday at 11:30 am you decided to flash back the database because of a user error that occurred at 8:30am. Which option must you use to check whether a flashback operation can recover the database to the specified time?()A Check the alert log fileB Query the V$FLASHBACK_DATABASE_LOG viewC Query the V$RECOVERY_FILE_DEST_SIZE viewD Query the V$FLASHBACK_DATABASE_STAT viewE Check the value assigned for the UNDO_RETENTION parameter