單項選擇題

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

你可能感興趣的試題

單項選擇題

The rows inside three Oracle tables supporting a customer order entry system are frequently accessed together by means of a table join. Because data is always being added to the tables, you leave a lot of extra space inside each block to accommodate growth. Which of the following types of tables would be useful for storing the data in this context?（）

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

單項選擇題

A table was just created on your Oracle database with six extents allocated to it. Which of the following factors most likely caused the table to have so many extents allocated?（）

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

99色精品-9色在线-99色在线-99色视频 国产欧美日产一区二区三区_亚洲精品亚洲人成在线观看_四虎在线精品永久观看_免费一级a一片久久精

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 table was just created on your Oracle database with six extents allocated to it. Which of the following factors most likely caused the table to have so many extents allocated?（）

99色精品-9色在线-99色在线-99色视频国产欧美日产一区二区三区_亚洲精品亚洲人成在线观看_四虎在线精品永久观看_免费一级a一片久久精