单项选择题

TheuseristryingtoexecuteaSELECTstatement.Whichofthefoll……

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

单项选择题AtablewasjustcreatedonyourOracledatabasewithsixextentsallocatedtoit.Whichofthefollowingfactorsmostlikelycausedthetabletohavesomanyextentsallocated?（）

A.The value for MINEXTENTS setting
B.The value for PCTINCREASE setting
C.The value for MAXEXTENTS setting
D.By default, Oracle allocates six extents to all database objects

单项选择题YouarecreatingtablespacesinOracle.Whichofthefollowingkeywordsorclausespermitsthedatafilesofadatabasetogrowautomaticallyinordertoaccommodatedatagrowth?（）

A.DEFAULT STORAGE
B.EXTENT MANAGEMENT
C.AUTOEXTEND
D.DATAFILE

单项选择题YouhaveimplementedOMFforredologmanagement.WhichofthefollowingchoicesreflectsalogfilenamethatmightbeemployedwhenOMFisenabled?（）

A.log01.log
B.logORCL01.log
C.1_2.logALTER ROLLBACK SEGMENT
D.ora_1_asdf1234.log