单项选择题

Which of the following choices correctly describes the difference between a data load via the conventional path and the direct path?（）

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

单项选择题Youaretryingtoaltertheinitialsegmentsizegiventoatableinadictionary-managedtablespace.Whichofthefollowingkeywordswouldbeusedaspartofthisprocess?（）

A.DROP TABLE
B.ALTER TABLE
C.RESIZE
D.COALESCE

单项选择题Yourapplicationregularlyissuesthefollowingstatement:SELECT*FROMBANK_ACCTWHEREACCT_BALANCEBETWEEN1000and10000;Whichofthefollowingdatabaseobjectswouldbeinappropriateforusewiththisstatement?（）

A.Materialized views
B.Indexes
C.Index-organized tables
D.Hash clusters