单项选择题
A. The location used for control files.
B. The location used for redo log files.
C. The location set by using $ORACLE_BASE
D. The location set by using $ORACLE_HOME
E. The location set by using CORE_DUMP_DEST
F. The location set by using BACKGROUND_DUMP_DEST
单项选择题 Considerthefollowingcommandtocreateatablespaceinyourproductiondatabase（whichisusinganAutomaticStorageManagement[ASM]instancetomanagethedatabasefiles）：CREATETABLESPACEuser_tbspDATAFILE’+dgroup3（usder_temp）/user_files/user_tbsp’SIZE200M；Whatwouldbetheresultofthiscommand？（）
单项选择题 Amediafailurehasoccurred.Thishasresultedinallthemembersofthenexthoploggroupbeingrenderedinaccessibletothelogwriterprocess（LGWR）atalogswitch.Howdoesthisfailureaffecttheoperationaldatabase？（）
单项选择题 Inyourtestdatabase，youhavecreatedtheORDERStableasanindex-organizedtable（IOT）.Tofacilitatefasterquerying，youhavecreatedamappingtableandabitmapindexontheORDER_FILLEDcolumn.Youobservethatthequeryperformancedegreeswhenusersperformalargevolumeoftransactions.Whileinvestigatingthereason，youfindthatthemappingtablesegmentisfragmented，leadingtopoorperformance.Whichoptionwouldyouusetodefragmentthemappingtablewithoutaffectingtheoriginaltabledata？（）