Explore topic-wise MCQs in Introduction to SQL.

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

1.

Delete from r; r relation This command performs which of the following action ?
A. Remove relation
B. Clear relation entries
C. Delete fields
D. Delete rows
Answer» C. Delete fields
Discussion
2.

To remove a relation from an SQL database, we use the ______ command.
A. Delete
B. Purge
C. Remove
D. Drop table
Answer» E.
Discussion
3.

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» B. 20, 4
Discussion
4.

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» D. Variable, equal
Discussion
5.

Select * from employee What type of statement is this?
A. DML
B. DDL
C. View
D. Integrity constraint
Answer» B. DDL
Discussion
6.

Create table employee (name varchar ,id integer) What type of statement is this ?
A. DML
B. DDL
C. View
D. Integrity constraint
Answer» C. View
Discussion
7.

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
8.

To establish a range of values, < and> can be used.
A. True
B. False
Answer» B. False
Discussion
9.

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