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

单项选择题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