View the Exhibit and examine the structure of the EMP table which is not partitioned and not an index-organized table. Evaluate the following SQL statement:

ALTER TABLE emp DROP COLUMN first_name; Which two statements are true regarding the above command? (Choose two.)

Question

View the Exhibit and examine the structure of the EMP table which is not partitioned and not an index-organized table. Evaluate the following SQL statement:

ALTER TABLE emp DROP COLUMN first_name; Which two statements are true regarding the above command? (Choose two.)

Accepted Answer

B. The FIRST_NAME column would be dropped provided at least one or more columns remain in D. The FIRST_NAME column can be dropped even if it is part of a composite PRIMARY KEY

Answer

A. The FIRST_NAME column would be dropped provided it does not contain any data.

Answer

C. The FIRST_NAME column can be rolled back provided the SET UNUSED option is added to the

View the Exhibit and examine the structure of the EMP table which is not partitioned and not an index-organized table. Evaluate the following SQL statement: ALTER TABLE emp DROP COLUMN first_name…

Question

Exhibit

Options

How the community answered

Community Discussion