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

WHERE

3. MySQL supports multiple database storage engines.

Yes

4. How can we get the number of records or rows in a table?

Using COUNT

Using NUM

Using NUMBER

Both a and c above

5. The ............. statement is used to delete a table using MySQL.

DROP TABLE

DELETE TABLE

REMOVE TABLE

6. Which method is used to get the current time in MySQL?

getTime()

Time()

NOW()

7. To remove duplicate rows from the result of a SELECT use the following keyword:.

NO DUPLICATE

DISTINCT

UNIQUE

None of the above

8. 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

9. 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

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

FETCH

JOIN

REVOKE

11. Which of the following is used to delete an entire MYSQL database?

mysql_drop_database

mysql_drop_entiredb

mysql_drop_db

mysql_drop_dbase

12. Which clause is used to sort the result of SELECT statement?

SORT BY

ORDER BY

ARRENGE BY

None of the above

13. BLOB data type can have default column value.

True

False

14. Can DISTINCT command be used for more than one column?

Yes

15. How much storage space does DATETIME require?

1 bytes

2 bytes

4 bytes

8 bytes

MySQL MCQ Questions

List of Frequently asked MySQL MCQ Questions