单项选择题

YouworkasadatabaseadministratorforSupportcenter.cn.Yourdatabaseisconfiguredforautomaticundomanagement.UNDO_RETENTIONissetto3hours.Youwanttoflashbackatablethatwascreatedlastyear.Howfarbackcantheflashbackquerygo？（）
A.3hours
B.6months
C.untillastyear
D.untillastcommit
E.untilthepointwhentheundotablespacewasrefreshed
F.untilthedatabaseisshutdownandthememoryerased

A.cn.Yourdatabaseisconfiguredforautomaticundomanagement.UNDO_RETENTIONissetto3hours.Youwanttoflashbackatablethatwascreatedlastyear.Howfarbackcantheflashbackquerygo？（）
A.3hours
B.6months
C.untillastyear
D.untillastcommit
E.untilthepointwhentheundotablespacewasrefreshed
F.untilthedatabaseisshutdownandthememoryerased

你可能感兴趣的试题

问答题

Youneedtoensurethatthecompany’sstandardpasswordpolicyisenforcedforallloginsthatareusedtoaccessSQLServer2005.Whichtwoactionsshouldyouperform？（）

A.SettheappropriatelocalpasswordpoliciesforallcomputersonwhichSQLServerisinstalled.
B.SettheserverauthenticationmodeofallSQLServerinstancestoWindowsAuthenticationmode.
C.InstallallinstancesofSQLServer2005oncomputersthatrunWindowsServer2003orlater.
D.CreateSQLServerloginsthathaveCHECK_POLICYenabled.

单项选择题

YouaremaintaininganOLTPdatabaseinOracle10g.YousetthevalueoftheLOG_ARCHIVE_TRACEparametertozero.Whatistheimpactofthissetting？（）

A.Thetracefileswillbedisabledonlyforaspecificsession.
B.Tracingwillbedisabledforaclientidentifier.
C.TracingwillbedisabledonlyfortheARCnprocess.
D.TheSQLTracefacilitywillbedisabledfortheinstance.