Explore topic-wise MCQs in Mysql.

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

1.

The variable that checks for availability of SSL support is ____________.

A. ssl_avail
B. avail_ssl
C. has_ssl
D. have_ssl
E. None of these
Answer» E. None of these
Discussion
2.

The log in which data changes received from a replication master server are written is _____________.

A. binary log
B. relay log
C. error log
D. general query log
E. None of these
Answer» C. error log
Discussion
3.

The function that returns a reference to an array of row values is ______________.

A. fetchrow_arrayref()
B. fetch()
C. fetchrow_hashref()
D. fetchrow_array()
E. None of these
Answer» B. fetch()
Discussion
4.

mysql_init() returns a _____________.

A. float
B. structure
C. pointer to a structure
D. integer
E. None of these
Answer» D. integer
Discussion
5.

The SOCKET protocol is permitted on which operating systems?

A. windows only
B. all
C. unix only
D. All of above
E. None of these
Answer» D. All of above
Discussion
6.

The TLS protocol is _____________.

A. transparent level security
B. transparent layer security
C. transport level security
D. transport layer security
E. None of these
Answer» E. None of these
Discussion
7.

The grant table scope columns that is case insensitive is _____________.

A. Password
B. Db
C. Host
D. User
E. None of these
Answer» D. User
Discussion
8.

The number of files that each end of a client/server connection including SSL support use to set up secure communications is __________.

A. 3
B. 2
C. 1
D. 0
E. None of these
Answer» B. 2
Discussion
9.

The datatype that stores the longest length of strings is ______________.

A. VARCHAR
B. TEXT
C. CHAR
D. TINYTEXT
E. None of these
Answer» C. CHAR
Discussion