MySQL MCQs (Chapterwise Multiple Choice Questions)

Which of the following account management statements was added in MySQL 5.6?

DROP USER

ALTER USER

CREATE USER

GRANT

Answer & Explanation

Correct Answer: ALTER USER

Note: This Question is unanswered, help us to find answer for this one

You need to export the entire database, including the database objects, in addition to the data. Which command-line tool do you use?

Mysqlexport

Mysqladmin

Mysqldump

Mysqld

Answer & Explanation

Correct Answer: Mysqldump

Note: This Question is unanswered, help us to find answer for this one

Which of the following is correct regarding the ALTER PROCEDURE statement?

This statement can be used to change the characteristics of a stored procedure.

This statement can be used to change the parameters of a stored procedure.

Thls statement can be used to change the body of a stored procedure.

None of the above.

Answer & Explanation

Correct Answer: This statement can be used to change the characteristics of a stored procedure.

Note: This Question is unanswered, help us to find answer for this one

Which of these queries will return the values of the "order" column in the "slides" table in descending order?

SELECT -order FROM -slides ORDER BY -order DESC

SELECT `order` FROM `slides` ORDER BY `order` DESC

SELECT order FROM `slides` ORDER BY order DESC

All of these return identical results

Answer & Explanation

Correct Answer: SELECT `order` FROM `slides` ORDER BY `order` DESC

Note: This Question is unanswered, help us to find answer for this one

Which of the following correctly calls the stored procedure "test" which has no parameters?

SELECT test;

CALL test;

SELECT test FROM procedures;

Set @variable = test;

Answer & Explanation

Correct Answer: CALL test;

Note: This Question is unanswered, help us to find answer for this one

If you want to use MyISAM instead of InnoDB, which option do you need to specify in the CREATE TABLE statement?

ENGINE

PARTITION

STORAGE

TABLESPACE

Answer & Explanation

Correct Answer: ENGINE

Note: This Question is unanswered, help us to find answer for this one

It is possible to add a constraint after a table is created

false

true

Answer & Explanation

Correct Answer: true

Note: This Question is unanswered, help us to find answer for this one

Which of the following are valid forms of the SHOW statement?

SHOW AUTHORS

SHOW TABLES

SHOW COLLATION

All of the above

Answer & Explanation

Correct Answer: All of the above

Note: This Question is unanswered, help us to find answer for this one

How can you filter duplicate data while retrieving records from a table?

DISTINCT

WHERE

LIMIT

AS

Answer & Explanation

Correct Answer: DISTINCT

Note: This Question is unanswered, help us to find answer for this one

Which statement is true about TIMESTAMP and DATETIME data types?

TIMESTAMP values require more bytes for storage than DATETIME values.

TIMESTAMP is stored without timezone, and DATETIME is stored in UTC values.

TIMESTAMP and DATETIME are both stored without time zone.

TIMESTAMP is stored in UTC values, and DATETIME is stored in without time zone.

Answer & Explanation

Correct Answer: TIMESTAMP and DATETIME are both stored without time zone.

Note: This Question is unanswered, help us to find answer for this one

MySQL Quick Quiz

Poor Results!

You need a lot of improvement.

Just don't give up!

Correct Answers: 0/10

Start Practicing with our MCQs given below.