Quiz on SQL

The language used application programs to request data from the DBMS is referred to as __________

• DDL

• DML

• Query Language

• All of the mentioned

Which of the following is not a type of SQL statement?

• Data Manipulation Language (DML)

• Data Definition Language (DDL)

• Data Control Language (DCL)

• Data Communication Language (DCL)

In existing table, ALTER TABLE statement is used to

• Add columns

• Add constraints

• Delete columns

• Delete constrains

• All the above

SQL Query to delete all rows in a table without deleting the table (structure, attributes, and indexes)

• DELETE FROM table_name;

• DELETE TABLE table_name;

• DROP TABLE table_name;

• None

Correct syntax query syntax to drop a column from a table is

• DELETE COLUMN column_name;

• DROP COLUMN column_name;

• ALTER TABLE table_name DROP COLUMN column_name;

• None is correct.

Which command is used for removing a table and all its data from the database:

• Create command

• Drop table command

• Alter table command

• All of the mentioned

Which of the following language is used to specify database Schema ?

• DDL

• DML

• DCL

• None

Which SQL statement is used to delete data from a database?

• DELETE

• COLLAPSE

• DROP

• REMOVE

With SQL, how do you select a column named "FirstName" from a table named "Persons"?

• SELECT FirstName FROM Persons

• SELECT Persons.FirstName

• SELECT Persons Where FirstName

• SELECT Persons From FirstName

Which SQL statement is used to insert new data in a database?

• ADD RECORD

• INSERT INTO

• ADD NEW

• INSERT NEW