单项选择题

A.Acquire locks on table queried B.Generate redo for st……

A user issues a SELECT command against the Oracle database. Which of the following choices describes a step that Oracle will execute in support of this statement?（）

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

单项选择题InordertoenableremoteadministrationofusersandtablespacesonanOracledatabase,whichofthefollowingtypesoffilesmustexistinthedatabase?（）

A.Password file
B.Initialization file
C.Datafile
D.Control file
E.Nothing - SYSDBA privileges are not required for these actions