DBMS Multiple Choice Questions with Answers for GATE Pdf - 1

Question: 1

TCL stands for ______

Answer:

Transaction Control Structure

Question: 2

_____ is the most popular web administration tool.

Answer:

Phpmyadmin

Question: 3

_____ lists all the databases available in the databases.

Answer:

Show databases

Question: 4

The vertical entity of a table is known as _____ or ______

Answer:

Attribute, Column

Question: 5

M : N relationship is said to be ______ relationship.

Answer:

Many to many

Question: 6

______ clause is used in select and update query statement for the condition.

Answer:

Where

Question: 7

______ is used to delete all table records.

Answer:

Truncate

Question: 8

Two types of transaction operations are _____ and ______

Answer:

Commits and aborts

Question: 9

The databases are broadly classified into _____ and ______ databases.

Answer:

Heavy, light

Question: 10

_______ is used to take out permission from the specific users.

Answer:

Revoke