Oracle 1z0-071 2019.10最新题库&解答11-15

QUESTION 11

Choose two.

Which two statements are true about a self
join?

A) The join key column must have an index.

B) It can be a left outer join.

C) It must be a full outer join.

D) It can be an inner join.

E) It must be an equijoin.

Correct Answer: BD

QUESTION 12

Choone two

Which three statements are true about
dropping and unused columns in an Oracle database?

A) A primary key column referenced by another
column as a foreign key can be dropped if using the CASCADE option.

B) A DROP COLUMN command can be rolled back

C) An UNUSED column’s space is reclaimed
automatically when the block containing that column is next queried

D) An UNUSED column’s space is reclaimed
automatically when the row containing that column is next queried.

E) Partition key columns cannot be dropped.

F) A column that is set to NNUSED still
counts towards the limit of 1000 columns per table.

Correct Answer: AEF

ORA-12984: 无法删除分区列，E 对;

删除主键列时可以加 cascade 选项，同时把主外键约束一起删除。

官档：SQL langauage reference

20.7.8.2 Marking Columns Unused

If you are concerned about the length of time it could
take to drop column data from all of the rows in a large table, you can use the
ALTER TABLE…SET UNUSED statement.

This statement marks one or more columns as unused, but
does not actually remove the target column data or restore the disk space
occupied by these columns. However, a column that is marked as unused is not
displayed in queries or data dictionary views, and its name is removed so that
a new column can reuse that name. In most cases, constraints, indexes, and
statistics defined on the column are also removed. The exception is that any
internal indexes for LOB columns that are marked unused are not removed.

To mark the hiredate and mgr columns as unused, execute
the following statement:

ALTER TABLE hr.admin_emp SET UNUSED (hiredate, mgr);

ALTER TABLE TESTD2 DROP UNUSED COLUMNS;

You can la