单项选择题
A. The index can be changed from NOLOGGING to LOGGING
B. The index cannot be recovered even in the ARCHIVELOG mode.
C. The index can only be created if the base table is created with the NOLOGGING option.
D. The index can be recovered if you perform a backup after the CREATE INDEX statement.
单项选择题 YourdatabasecontainstwotemporarytablespacesnamedTEMPandTEMP1.TheTEMPtablespaceisthedefaulttemporarytablespaceforthedatabase，andtheTEMP1tablespacewascreatedatdatabasecreation.YouwanttoincreasethesizeofthetempfilefortheTEMPtablespaceanddroptheTEMP1tablespacefromthedatabase.ThedatabaseisnotusingOracle-ManagedFiles（OMF）.WhichstatementmustyouusetoensurethatwhenyoudroptheTEMP1tablespacefromthedatabase，itscorrespondingoperatingsystemfileisalsodeleted？（）
单项选择题 YourdatabaseisinNOARCHIVELOGmode.Thedatabasehasthreeonlineredologgroups，andeachgroupcontainsthreeonlineredologmembers.Theonlineredologmembersarestoredacrossthreeharddisks，E，F，andG，respectively.HarddiskGcrashedwhiletheLGWRbackgroundprocesswaswritingredoinformationtotheonlineredologfiles.Whateffectwillthiscrashhaveonthedatabase？（）
单项选择题 Atdatabasestartup，youdiscoverthatoneofthediskscontaininganindextablespacehasbeenlostduetoamediafailure.Abackupofthelostindextablespaceisnotavailable.Youhaveallthenecessaryscriptstorecreatetheindexes.Youneedtore-createtheindexesinanewindextablespace.Whichactionmustyouperformbeforere-creatingtheindexes？（）