A.When the instance is started B.When the database is m……

单项选择题AuserissuesaSELECTcommandagainsttheOracledatabase.WhichofthefollowingchoicesdescribesastepthatOraclewillexecuteinsupportofthisstatement?（）

A.Acquire locks on table queried 
B.Generate redo for statement 
C.Fetch data from disk into memory 
D.Write changes to disk

单项选择题Youhavealong-runningprocessyouwanttoassigntoaspecificUNDOsegmentbroughtonlineforthatexpresspurpose.YouarenotusingautomaticUNDOmanagement.Whatstatementcanbeusedforthistask?（）

A.ALTER DATABASE 
B.SET TRANSACTION 
C.ALTER ROLLBACK SEGMENT 
D.ALTER TABLE

单项选择题Whichofthefollowingchoicescorrectlydescribesthedifferencebetweenadataloadviatheconventionalpathandthedirectpath?（）

A.One runs faster than the other
B.A conventional path data load bypasses most of the Oracle RDBMS, whereas a direct path load is a high-speed version of the SQL INSERT
C.A direct path data load bypasses most of the Oracle RDBMS, whereas a conventional path load is a high-speed version of the SQL INSERT
D.The conventional path runs when the CONVENTIONAL command-line parameter is set to TRUE

单项选择题Recordsfromthedatadictionaryinformationarestoredinwhichofthefollowingdatabasememoryareas?（）

A.Library cache 
B.Row cache 
C.Session UGA 
D.Buffer cache

单项选择题Ifyouwantedtofindthenameandlocationofyourcontrolfiles,youcouldfindthatinformationineachofthefollowinglocationsexceptone.Whichisit?（）

A.V_CONTROLFILE_RECORD_SECTION 
B.V_CONTROLFILE 
C.V$PARAMETER 
D.init.ora file