> > >

Oracle 9i Administration MCQs

You need to drop two columns from a table. Which of the following sequence of SQL statements is used to drop the columns and limit the number of times the rows are updated?

ALTER TABLE emp DROP COLUMN comments DROP COLUMN email;

ALTER TABLE emp DROP COLUMN comments; ALTER TABLE emp DROP COLUMN email;

ALTER TABLE emp SET UNUSED COLUMN comments; ALTER TABLE emp DROP UNUSED COLUMNS; ALTER TABLE emp SET UNUSED COLUMN email; ALTER TABLE emp DROP UNUSED COLUMNS;

ALTER TABLE emp SET UNUSED COLUMN comments; ALTER TABLE emp SET UNUSED COLUMN email; ALTER TABLE emp DROP UNUSED COLUMNS;

Answer

Correct Answer: ALTER TABLE emp SET UNUSED COLUMN comments; ALTER TABLE emp SET UNUSED COLUMN email; ALTER TABLE emp DROP UNUSED COLUMNS; 

Explanation:

Note: This Question is unanswered, help us to find answer for this one

Oracle 9i Administration Skill Assessment

Your Skill Level: Poor

Retake Quizzes to improve it

More Oracle 9i Administration MCQ Questions

Oracle 9i Administration Skill Assessment

Your Skill Level: Poor

Retake Quizzes to improve it