Programming

MySQL MCQs MCQs: 3300+ Questions & Answers in Programming

3300+ MySQL MCQs MCQs in Programming with answers & explanations. Page 7. Practice objective questions for competitive exams, interviews & self-assessment —… Use the answer toggle below to show or hide all solutions, tap an option to check one question, or open a question for its own page.

Page 7 of 166

Show answers

Answers hidden — tap an option or use “View Answer” on each question.

121

MySQL MCQs MCQs: 3300+ Questions & Answers in Programming

The USE command

The privilege that must be given to the database to create a stored function or procedure is

In a LIKE clause, you can ask for any 6 letter value by writing

MySQL runs on which operating systems?

MySQL Access security is controlled through

Which of the following is NOT supported by MySQL

How would a stored function named PI() written in the database ‘sampdb’ be called?

One of the early proponents of relational database who laid down many of the principles we use to this day was

The number of values returned from a stored procedure can be

The mode used to turn on strict mode and all of the additional restrictions is

What is the SQL mode to check for divide by zero error?

You are required to buy a license for MySQL if

Which of these is a valid call to a function (watch the spaces carefully!)

If you want to undo a GRANT, you should use

How many distinct, different values can you hold in an enum field?

Which of the following is NOT available in MySQL

The program called mysql is

Which of these field types would be best to hold a film title?

Which of the following is available in MySQL

Which of these field types would be best to hold a .jpg image?

Study tips for MySQL MCQs