多项选择题
Your database instance is running with full workload after database creation. You have decided to useafixed-sizeundo tablespace. You want to use the Undo Advisor to estimate the capacity of the undotablespace.
Which two factors must you consider before using the Undo Advisor to estimate the capacity of the undotablespace()
A.the retention period to support flashback
B.the expected length of the longest-running query
C.the number of undo tablespaces in the database
D.the size of the Flash Recovery Area for the database instance
相关考题
-
单项选择题
WhichstatementistrueabouttheUNDO_RETENTIONparameterwhenretentionguaranteeisnotenabled()
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. -
单项选择题
InwhichsituationmaytheUNDO_RETENTIONparameterbeignored,evenifitissettoavalue()
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 -
单项选择题
YourdatabaseinstanceisconfiguredwithautomaticundomanagementandtheUNDO_RETENTIONparameterissetto900seconds.Youexecutedthefollowingcommandtoenableretentionguarantee:SQL>ALTERTABLESPACEundotbs1RETENTIONGUARANTEE;Whateffectwouldthiscommandhaveonthedatabase()
A.The extents in the undo tablespace retain data until the next full database backup.
B.The extents containing committed undo in the undo tablespace are not overwritten for at least 15minutes.
C.The extents containing committed data in the undo tablespace are not overwritten until the instance isshut down.
D.The extents containing committed undo in the undo tablespace are transferred to Flash Recovery Areabefore being overwritten.
