DBMS Quiz-1XII

_________ statement is used to delete a table

• DELETE TABLE

• REMOVE TABLE

• DROP TABLE

• MODIFY TABLE

What does DML stand for?

• Data Migration Language

• Data Markup Language

• Data Modelling Language

• Data Manipulation Language

Which SQL statement is used to delete an existing row ?

• DROP

• REMOVE

• DELETE

• UPDATE

Which SQL statement is used to modify data in a database table?

• MODIFY

• CHANGE

• ALTER

• UPDATE

The total number of rows in a table is called as

• integer

• degree

• cardinality

• tuples

INSERT INTO EMP VALUES(1221, 'ABC', 'MANAGER',12323); What kind of statement is this ?

• DDL

• DML

• DCL

• TCL

A relational database may have

• Primary Key

• Candidate Key

• Foreign Key

• All of these

SELECT is a DDL / DML statement ?

• DDL

• DML

• Both

• None

_________ is used to select a database

(Type in upper case)

All the _______________ in a table are called fields.

• rows

• columns

• cells