SQL MCQ Questions and answers

A. rows cannot be copied in mass from one table to another only.

B. rows can be modified according to criteria only.

C. rows can either be inserted into a table one at a time or in groups.

D. rows can be inserted into a table only one at a time only.

A. change the table data.

B. change the table structure.

C. delete rows from the table.

D. add rows to the table.

A. MODIFY TABLE TableName DROP ColumnName

B. MODIFY TABLE TableName DROP COLUMN ColumnName

C. ALTER TABLE TableName DROP ColumnName

D. ALTER TABLE TableName DROP COLUMN ColumnName

A. ALTER TABLE TableName ADD ColumnName

B. ALTER TABLE TableName ADD COLUMN ColumnName

C. MODIFY TABLE TableName ADD ColumnName

D. MODIFY TABLE TableName ADD COLUMN ColumnName

A. DROP FROM CUSTOMER ...

B. UPDATE FROM CUSTOMER ...

C. REMOVE FROM CUSTOMER ...

D. DELETE FROM CUSTOMER WHERE ...

A. limits the row data are returned.

B. limits the column data that are returned.

C. Both A and B are correct.

D. Neither A nor B are correct.

A. To define the data structures

B. To specify the syntax and semantics of SQL data definition language

C. To specify the syntax and semantics of SQL manipulation language

D. All of the above.

A. An exact match is necessary in a CREATE statement.

B. An exact match is necessary in a SELECT statement.

C. An exact match is not possible in a SELECT statement.

D. An exact match is not possible in a CREATE statement.

A. DROP TABLE CUSTOMER;

B. DELETE TABLE CUSTOMER;

C. REMOVE TABLE CUSTOMER;

D. UPDATE TABLE CUSTOMER;

A. NOT IN only

B. LIKE only

C. IN only

D. IN and NOT IN