SQL Queries

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

• DDL

• DML

• Query Language

• All of the mentioned

Match SQL language with SQL commands

1)DDL i)Revok, Grant

2)DML ii)rename a table

3)TCL iii)insert, update

4)DCL iv)rollback , commit

• 1-iii,2-i,3-ii,4-iv

• 1-iii,2-ii,3-iv,4-i

• 1-ii,2-iii,3-iv,4-i

• 1-i,2-iii,3-ii,4-iv

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.

SQL has how many main commands for DDL:

• 1

• 2

• 3

• 4

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

DDL Stands for ___________.

• Data Management Language

• Data Manupulation Language

• Data Development Language

• Data Definition Language