YourdatabaseisinARCHIVELOGmode.Youlostanindextablespaceduetoadiskfailurewhilethedatabasewasopen.YouhaveneitherabackupofthelostindextablespacenorthescriptscontainingtheCREATEINDEXstatementstorecreatetheindexes.Currently,severalusersareexecutinglong-running

题目

YourdatabaseisinARCHIVELOGmode.Youlostanindextablespaceduetoadiskfailurewhilethedatabasewasopen.YouhaveneitherabackupofthelostindextablespacenorthescriptscontainingtheCREATEINDEXstatementstorecreatetheindexes.Currently,severalusersareexecutinglong-runningqueriesonthedatabase.Whatwillhappentotheongoingactivityinthedatabase?()

A.Thequeriesthatarecurrentlyexecutingwillabortandanerrormessagewillbereturnedtotheuser.

B.Thequeriesthatarecurrentlyexecutingwillexecutenormallybutfuturequerieswillnotexecuted.

C.DataManipulationLanguage(DML)statementscannotbeperformedonthetablesonwhichtheindexesarebased.

D.Thecurrentlyexecutingandfuturequerieswillexecutenormally,butwillbeslower


相似考题