单项选择题
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()
单项选择题 View the Exhibit and examine the undo tablespace attributes. Your database instance is experiencing a large volume of transactions from non-DBA users in the last onehour. The undo tablespace UNDOTBS1 is full with transactions and no transaction was committed morethan one hour ago. The database has two more undo tablespaces. What happens to the new DML operations in this scenario()
多项选择题 Whichtwostatementsaretrueregardingundotablespaces()