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

This section includes 13 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.

The character that the MySQL client program recognizes as a statement delimiter is ______________

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

Stored programs degrade database security.

A. True
B. False
Answer» C.
Discussion
3.

Execution on a time activated basis according to a schedule is done by _____________

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

The log enabled by –relay-log-index is _____________

A. relay log index
B. relay log
C. binary log
D. error log
Answer» B. relay log
Discussion
5.

STORED_PROGRAMS_DEGRADE_DATABASE_SECURITY.?$

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

The character that the mysql client program recognizes as a statement delimiter is ______________$

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

Execution on a time activated basis according to a schedule is done by ____________?

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

What is the synonym for REAL?

A. FLOAT
B. INT
C. DOUBLE
D. BIT
Answer» D. BIT
Discussion
9.

What is the size of the BIT type?

A. 1
B. 2
C. 3
D. variable
Answer» E.
Discussion
10.

What is the storage size in bytes required for the MEDIUMINT datatype?

A. 1
B. 2
C. 3
D. 4
Answer» D. 4
Discussion
11.

The log enabled by –relay-log-index is _____________$

A. relay log index
B. relay log
C. binary log
D. error log
Answer» B. relay log
Discussion
12.

The option that supplies the pathname to root directory of MySQL installation is _____________

A. –basedir
B. –datadir
C. –port
D. –socket
Answer» B. ‚Äö√Ñ√∂‚àö√ë‚àö¬®datadir
Discussion
13.

OS imposes per process limits on the number of open file descriptors.

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