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.

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

A. error log
B. general query log
C. binary log
D. relay log
Answer» E.
Discussion
2.

The MySQL server is configurable.

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

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

A. fetchrow_array()
B. fetchrow_arrayref()
C. fetch()
D. fetchrow_hashref()
Answer» C. fetch()
Discussion
4.

Which grant table scope columns are case insensitive?

A. Host
B. User
C. Password
D. Db
Answer» B. User
Discussion
5.

MULTIPLE_MYSQL_SERVERS_CANNOT_BE_RUN_ON_THE_SAME_MACHINE.?$

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

The_log_in_which_data_changes_received_from_a_replication_master_server_are_written_is______________$

A. error log
B. general query log
C. binary log
D. relay log
Answer» E.
Discussion
7.

The MySQL server is configurable?

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

MySQL does provides a date type that has an optional time part.

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

The variable that checks for availability of SSL support is ____________

A. have_ssl
B. has_ssl
C. avail_ssl
D. ssl_avail
Answer» B. has_ssl
Discussion
10.

Which grant table scope columns is case insensitive?

A. Host
B. User
C. Password
D. Db
Answer» B. User
Discussion
11.

What is the TLS protocol?

A. transparent layer security
B. transport layer security
C. transparent level security
D. transport level security
Answer» C. transparent level security
Discussion
12.

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

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