單項(xiàng)選擇題

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.

你可能感興趣的試題

單項(xiàng)選擇題

Your Certkiller .com database is in ARCHIVELOG mode. The data file that belongs to the SYSTEMtablespacehas become corrupted. Up to what point can you recover the database？（）

A.Until last commit
B.Until the time you perform recovery
C.Until the time the date file got corrupted
D.Until the point where the last transaction begun
E.You cannot recover the SYSTEMtablespaceand must re-create the database.

單項(xiàng)選擇題

You work as a database administrator for Certkiller .com. In your production
database， the size of Database Buffer Cache needs to be increased immediately for the current as well as future instances of the database. The Oracle instance has been configured to accommodate any changes in the size of the memory structures. At this is production database， you want to accomplish this task with no impact on the user’s connections.
Which activity must you have completed before accomplishing this task？（）

A.You must have started the database instance in restricted mode.
B.You must have started the database instance inNORMALmode.
C.You must have started the database instance with server parameter file.
D.You must have started the database instance but must not have mounted.
E.You must have started the database instance but must not have opened.

97免费在线观看视频,亚洲综合自拍网,黄色毛片免费观看,热久久综合网,免费看日产一区二区三区 狠狠操av,久久久涩涩涩,在线精品免费视频,人人插天天干,久久91精品国产91久久

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？（）

你可能感興趣的試題

Your Certkiller .com database is in ARCHIVELOG mode. The data file that belongs to the SYSTEMtablespacehas become corrupted. Up to what point can you recover the database？（）

97免费在线观看视频,亚洲综合自拍网,黄色毛片免费观看,热久久综合网,免费看日产一区二区三区狠狠操av,久久久涩涩涩,在线精品免费视频,人人插天天干,久久91精品国产91久久

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？（）