Explore topic-wise MCQs in Structured Query Language (SQL).

This section includes 12 Mcqs, each offering curated multiple-choice questions to sharpen your Structured Query Language (SQL) knowledge and support exam preparation. Choose a topic below to get started.

1.

Which of the following statements does not modify the table?

A. INSERT
B. UPDATE
C. DELETE
D. SELECT
Answer» E.
Discussion
2.

Stored programs refer to stored objects of how many of the following types?

A. 0
B. 1
C. 3
D. 4View Answer
Answer» E.
Discussion
3.

Stored routines refers to stored functions and procedures.

A. True
B. False
Answer» B. False
Discussion
4.

Which_of_the_following_statements_does_not_modify_the_table?$

A. INSERT
B. UPDATE
C. DELETE
D. SELECT
Answer» E.
Discussion
5.

Stored routines refers to stored functions and procedures?

A. True
B. False
Answer» B. False
Discussion
6.

Which of the following characters cannot be used as a delimiter?

A. ,
B. .
C. ;
D. \
Answer» E.
Discussion
7.

Which command is used to redefined the mysql delimiter?

A. redefine_delim
B. delim_redefine
C. delimiter
D. redefine
Answer» D. redefine
Discussion
8.

Which character does the mysql client program recognize as a statement delimiter?

A. :
B. .
C. ;
D. ,
Answer» D. ,
Discussion
9.

Stored programs improve database security.

A. True
B. False
Answer» B. False
Discussion
10.

What executes on a time activated basis according to a schedule?

A. Stored program
B. Events
C. Triggers
D. Stored procedures
Answer» C. Triggers
Discussion
11.

Which of these is defined to execute when the table is modified only?

A. Stored functions
B. Stored procedures
C. Triggers
D. Events
Answer» D. Events
Discussion
12.

Which of these return a result to the client?

A. Stored functions
B. Stored procedures
C. Triggers
D. Events
Answer» B. Stored procedures
Discussion