Mysql Quiz - Mysql Online Test - Best interview question

1. How do I find out all databases starting with "test"?

SHOW DATABASES LIKE '%test%';

SHOW DATABASES LIKE '%test';

SHOW DATABASES LIKE 'test%';

2. Which Of The Following Is An Aggregate Function In MySQL?

MIN

LIKE

WHERE

3. MySQL supports multiple database storage engines.

Yes

No

4. Which of the following scripts will run successfully?

SELECT customer name FROM customers;

SELECT FROM `customers` 'customer name';

SELECT `customer name` FROM customers ORDER BY zone WHERE cat_id = 12;

SELECT `customer name` FROM customers WHERE cat_id = 12 ORDER BY cat_id;

5. A NULL value is treated as a blank or 0.

Wrong

Correct

6. Which commands is used to delete a table called AAA if you have appropriate authority?

DROP AAA

DELETE AAA WHERE confirm = “YES”

DROP TABLE AAA

DELETE AAA

7. The USE command

Has been deprecated and should be avoided for security reasons

Is used to load code from another file

Is a pseudonym for the SELECT command

Should be used to choose the database you want to use once you’ve connected to MySQL

8. Which of the following is NOT supported by MySQL?

Hash Table

Table Joining

Regular Expression Matching

Stored Procedures

9. If You Want To Undo A GRANT, You Should Use

UNGRANT

UNDO

DELETE

REVOKE

10. Which of these is a valid call to a function using MySQL?

CONCAT( A , B )

CONCAT ( A , B )

CONCAT( “A” , “B” )

CONCAT ( “A” , “B” )

11. Which of the following is NOT available in MySQL?

FETCH

LIKE

JOIN

REVOKE

12. Which of the following ways below are the correct way to get the current date?

SELECT CURTIME();

SLELCT CURRRENT_TIME()

SELECT CURDATE();

All the mentioned above

13. BLOB data type can have default column value.

True

False

14. How much storage space does DATETIME require?

1 bytes

2 bytes

4 bytes

8 bytes

15. A view is nothing but a ................... table or a stored query.

Real

Virtual

Static

MySQL MCQ Questions

List of Frequently asked MySQL MCQ Questions