单项选择题

You just issued the following statement: ALTER TABLE SALES DROP COLUMN PROFIT. Which of the following choices identifies when the column will actually be removed from Oracle?（）

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

单项选择题WhichofthefollowingoperationsdoesnotrequireOracletostoreinformationinanUNDOsegmentsaspartofthetransaction?（）

A.INSERT
B.SELECT
C.UPDATE
D.DELETE