单项选择题
You are managing the Oracle database. Which of the following choices correctly identifies when Oracle reads the contents of the init.ora file?()
A.When the instance is started
B.When the database is mounted
C.When the database is opened
D.When the database is closed
相关考题
-
单项选择题
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
