Explore topic-wise MCQs in Database.

This section includes 5 Mcqs, each offering curated multiple-choice questions to sharpen your Database knowledge and support exam preparation. Choose a topic below to get started.

1.

TO_REMOVE_A_RELATION_FROM_AN_SQL_DATABASE,_WE_USE_THE________COMMAND.?$

A. Delete
B. Purge
C. Remove
D. Drop table
Answer» C. Remove
Discussion
2.

An attribute A of datatype varchar(20) has the value “Avi”. The attribute B of datatype char(20) has value ”Reed”. Here attribute A has ____ spaces and attribute B has ____ spaces?#

A. 3, 20
B. 20, 4
C. 20, 20
D. 3, 4
Answer» C. 20, 20
Discussion
3.

The basic data type char(n) is a _____ length character string and varchar(n) is _____ length character.

A. Fixed, equal
B. Equal, variable
C. Fixed, variable
D. Variable, equal
Answer» E.
Discussion
4.

Which one of the following provides the ability to query information from the database and to insert tuples into, delete tuples from, and modify tuples in the database?

A. DML(Data Manipulation Langauge)
B. DDL(Data Definition Langauge)
C. Query
D. Relational Schema
Answer» B. DDL(Data Definition Langauge)
Discussion
5.

Which one of the following is used to define the structure of the relation, deleting relations and relating schemas?

A. DML(Data Manipulation Langauge)
B. DDL(Data Definition Langauge)
C. Query
D. Relational Schema
Answer» C. Query
Discussion