Which one of the following is used for removing columns from a table?

D. ALTER TABLE TableName DROP COLUMN ColumnName

A. MODIFY TABLE TableName DROP ColumnName

B. MODIFY TABLE TableName DROP COLUMN ColumnName

C. ALTER TABLE TableName DROP ColumnName

Quiz

Untitled

Jerry Reeves Jr 4 questions

Take the quiz

1Which SQL command used to delete a data from a table?
1. AA.COLLAPSE
2. BB.REMOVE
3. CC.ALTER
4. DD.DELETE
2Which one of the following is used for removing columns from a table?
1. AA. MODIFY TABLE TableName DROP ColumnName
2. BB. MODIFY TABLE TableName DROP COLUMN ColumnName
3. CC. ALTER TABLE TableName DROP ColumnName
4. DD. ALTER TABLE TableName DROP COLUMN ColumnName
3Which is not a DML command?
1. AA. INSERT
2. BB. UPDATE
3. CC. DELETE
4. DD. CREATE
4The ___________ provides the ability to insert, delete, and modify tuples as well as query a data.
1. AA. TCL
2. BB. DCL
3. CC. DDL
4. DD. DML

Description: Information Technology Quiz on Untitled, created by Jerry Reeves Jr on 22/11/2022.
Author: Jerry Reeves Jr
Language: English
Views: 0
Tags: information technology
Rating: No ratings yet
Rate this quiz
Rate this quiz