MySQL MCQs with answers Page - 3

Here, you will find a collection of MCQ questions on MySQL. Go through these questions to enhance your preparation for upcoming examinations and interviews.

To check the correct answer, simply click the View Answer button provided for each question.

Have your own questions to contribute? Click the button below to share your MCQs with others!

+ Add Question

A

Admin • 828.03K Points
Coach

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

A

Admin • 828.03K Points
Coach

Q. Multiple MySQL servers cannot be run on the same machine.

  • (A) False
  • (B) True
  • (C) NA
  • (D) NA

A

Admin • 828.03K Points
Coach

Q. The MySQL server is configurable

  • (A) False
  • (B) True
  • (C) NA
  • (D) NA

A

Admin • 828.03K Points
Coach

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()

A

Admin • 828.03K Points
Coach

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

A

Admin • 828.03K Points
Coach

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

  • (A) False
  • (B) True
  • (C) NA
  • (D) NA

A

Admin • 828.03K Points
Coach

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

  • (A) ssl_avail
  • (B) avail_ssl
  • (C) has_ssl
  • (D) have_ssl

A

Admin • 828.03K Points
Coach

Q. Which grant table scope columns is case insensitive?

  • (A) User
  • (B) Host
  • (C) Db
  • (D) Password

A

Admin • 828.03K Points
Coach

Q. What is the TLS protocol?

  • (A) transport level security
  • (B) transparent level security
  • (C) transparent layer security
  • (D) transport layer security

A

Admin • 828.03K Points
Coach

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

Add MCQ in this Category

If you want to share an MCQ question in this category, it's a great idea! It will be helpful for many other students using this website.

Share Your MCQ

Browse Categories

Click on category to learn MCQs of that category.