MySQL MCQs with answers Page - 3

Dear candidates you will find MCQ questions of MySQL here. Learn these questions and prepare yourself for coming examinations and interviews. You can check the right answer of any question by clicking on any option or by clicking view answer button.
Share your questions by clicking Add Question

📊 MySQL
Q. 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
💬 Discuss
✅ Correct Answer: (B) relay log
📊 MySQL
Q. Multiple MySQL servers cannot be run on the same machine.
  • (A) False
  • (B) True
  • (C) NA
  • (D) NA
💬 Discuss
✅ Correct Answer: (B) True
📊 MySQL
Q. The MySQL server is configurable
  • (A) False
  • (B) True
  • (C) NA
  • (D) NA
💬 Discuss
✅ Correct Answer: (B) True
📊 MySQL
Q. The function that returns a reference to an array of row values is
  • (A) fetchrow_arrayref()
  • (B) fetch()
  • (C) fetchrow_hashref()
  • (D) fetchrow_array()
💬 Discuss
✅ Correct Answer: (A) fetchrow_arrayref()
📊 MySQL
Q. ‘fetchrow_hashref()’ returns reference to hash of row values keyed by what?
  • (A) table name
  • (B) row name
  • (C) database name
  • (D) column name
💬 Discuss
✅ Correct Answer: (D) column name
📊 MySQL
Q. MySQL does provides a date type that has an optional time part.
  • (A) False
  • (B) True
  • (C) NA
  • (D) NA
💬 Discuss
✅ Correct Answer: (B) True
📊 MySQL
Q. The variable that checks for availability of SSL support is ____________.
  • (A) ssl_avail
  • (B) avail_ssl
  • (C) has_ssl
  • (D) have_ssl
💬 Discuss
✅ Correct Answer: (D) have_ssl
📊 MySQL
Q. Which grant table scope columns is case insensitive?
  • (A) User
  • (B) Host
  • (C) Db
  • (D) Password
💬 Discuss
✅ Correct Answer: (B) Host
📊 MySQL
Q. What is the TLS protocol?
  • (A) transport level security
  • (B) transparent level security
  • (C) transparent layer security
  • (D) transport layer security
💬 Discuss
✅ Correct Answer: (C) transparent layer security
📊 MySQL
Q. 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
💬 Discuss
✅ Correct Answer: (A) 3

Programming Categories

📱 Download Our App

Learn MCQs on the go with our easy-to-use Android app

Get it on Google Play