Oracle 1z0-071 2019.10最新题库&解答46-50

QUESTION 46

Choose three

Which three are true about dropping columns from a table?

A) A column can be removed only if it contains no data.

B) A column drop is implicitly committed

C) A column that is referenced by another column in any
other table cannot be dropped.

D) A column must be set as unused before it is dropped
from a table.

E A primary key column cannot be dropped.

F) Multiple columns can be dropped simultaneously using
the ALTER TABLE command.

Correct Answer: BCF

解析：alter table tablename drop
(col1,col2);—>删除多列

QUESTION 47

choose three

which three statements are true about GLOBAL TEMPORARY
TABLES?

A)A DELETE comand on GLOBAL TEMPORARY TABLE cannot be
rolled back

B) GLOBAL TEMPORARY TABLE rows inserted by a session are
available to any other session whose user has been granted selected on the
table