单项选择题
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 15 minutes.
C.The extents containing committed data in the undo tablespace are not overwritten until the instance is shutdown.
D.The extents containing committed undo in the undo tablespace are transferred to Flash Recovery Areabefore being overwritten
单项选择题 Youwanttoenablearchivingonyourdatabase.Presently,thedatabaseisrunninginNOARCHIVELOGmode.Givenbelowarethestepstoaccomplishthetaskinrandomorder: 1.Shutdowntheinstance. 2.ExecutetheALTERDATABASEARCHIVELOGcommand. 3.Startuptheinstanceandmountthedatabase. 4.SettheDB_RECOVERY_FILE_DESTinitializationparameterto$ORACLE_HOME/dest_1. 5.Openthedatabase. Whichisthecorrectsequenceofstepsforaccomplishingthetask()
单项选择题 WhichstatementistrueabouttheUNDO_RETENTIONparameterwhenretentionguaranteeisnotenabled()
单项选择题 View the Exhibit and examine the undo tablespace attributes. Your database instance is experiencing a largevolume of transactions from non-DBA users in the last one hour. The undo tablespace UNDOTBS1 is full withtransactions and no transaction was committed more than one hour ago. The database has two more undotablespaces. What happens to the new DML operations in this scenario()