单项选择题

The user is trying to execute a SELECT statement. Which of the following background processes will obtain data from a disk for the user?（）

A.DISPATCHER
B.USER
C.SERVER
D.LGWR
E. DBW0

<没有了目录下一题>

热门试题

单项选择题

Youjustissuedthefollowingstatement:ALTERTABLESALESDROPCOLUMNPROFIT.WhichofthefollowingchoicesidentifieswhenthecolumnwillactuallyberemovedfromOracle?（）

A.Immediately following statement execution
B.After the ALTER TABLE DROP UNUSED COLUMNS command is issued
C.After the ALTER TABLE SET UNUSED COLUMN command is issued
D.After the ALTER TABLE MODIFY command is issued

单项选择题

TherowsinsidethreeOracletablessupportingacustomerorderentrysystemarefrequentlyaccessedtogetherbymeansofatablejoin.Becausedataisalwaysbeingaddedtothetables,youleavealotofextraspaceinsideeachblocktoaccommodategrowth.Whichofthefollowingtypesoftableswouldbeusefulforstoringthedatainthiscontext?（）

A.Temporary tables
B.Index-organized tables
C.Cluster tables
D.Standard Oracle tables