MySQL MCQs with answers Page - 1

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 • 799.53K Points
Coach

Q. A stored procedure is invoked using the statement __________.

  • (A) CALL
  • (B) RETURN
  • (C) SEE
  • (D) INVOKE

A

Admin • 799.53K Points
Coach

Q. Triggers and events are not invoked automatically by the server.

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

A

Admin • 799.53K Points
Coach

Q. The security context when a user creates a stored program that accesses sensitive data but forgets that other people who can invoke the object have the same access is __________

  • (A) illegal
  • (B) fare
  • (C) bad
  • (D) good

A

Admin • 799.53K Points
Coach

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

  • (A) VARCHAR
  • (B) TEXT
  • (C) CHAR
  • (D) TINYTEXT

A

Admin • 799.53K Points
Coach

Q. What is the best datatype for a column that is expected to store values up to 2 million?

  • (A) BIGINT
  • (B) SMALLINT
  • (C) TINYINT
  • (D) MEDIUMINT

A

Admin • 799.53K Points
Coach

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

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

A

Admin • 799.53K Points
Coach

Q. Which variable checks for availability of SSL support?

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

A

Admin • 799.53K Points
Coach

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

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

A

Admin • 799.53K Points
Coach

Q. The TLS protocol is _____________.

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

A

Admin • 799.53K Points
Coach

Q. How many files does each end of a client/server connection including SSL support use to set up secure communications?

  • (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.