Examine the structure of the DEPARTMENTs table Name Null? Type DEPARTMENT ID DEP

Question

Examine the structure of the DEPARTMENTs table Name Null? Type DEPARTMENT ID DEPARTMENT NAME MANAGER ID LOCATION ID COUNTRY NUMBER (4) VARCHAR2 (30) NUMBER (6) NUMBER (4) VARCHAR2 (20) NOT NULL NOT NULL You execute the following command SQL> ALTER TABLE departments SET UNUSED (country); Which two statements are true? ? A) Views created on the DEPARTMENTS table that include the COUNTRY column are automatically modified and remain valid. B) Synonyms existing on the DEPARTMENTs table would have to be re-created. ? C) indexes created on the COUNTRY column exist until the DROP UNUSED COLUMNS Command is executed. O D) Unique key constraints defined on the coUNTRY column are removed E) A new column, COUNTRY, can be added to the DEPARTMENTS table after executing the command

Explanation / Answer

Answers are D and E.

All the constraints,statistics and indexes defined on the column are removed after executing the SET UNUSED command and also the column name can be reused.

Related Questions

Navigate

• Browse (All)
• Browse E
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.