Question: What SQL command can be used to delete columns from a table?

Options

A : MODIFY TABLE TableName DROP COLUMN ColumnName

B : MODIFY TABLE TableName DROP ColumnName

C : ALTER TABLE TableName DROP COLUMN ColumnName

D : ALTER TABLE TableName DROP ColumnName

Click to view Correct Answer

Previous || Next

Database Redesign - General Questions more questions

Which of the following is not a reason that operational....

We have Market Basket data for 1,000 rental transactions at....

One popular classification technique in Business Intelligence (BI) reporting is....

We have done an RFM analysis on our customer data.....

Which of the following SQL statements are helpful in database....

Database redesign is not terribly difficult if the:

Which SQL-92 standard SQL command can be used to change....

The process of reading a database schema and producing a....

Before any changes to database structure are attempted one should....

Which of the following modifications may not succeed?

Advanced SQL - General Questions more Online Exam Quiz

Structures - General Questions

Advanced SQL - General Questions

Data and Database Administration - General Questions

Database Design Using Normalization - General Questions

Database Processing for BIS - General Questions

Data Modeling with ER Model - General Questions

Data Warehousing - General Questions

Distributed Databases - General Questions

Introduction to Database - General Questions

Introduction to SQL - General Questions