Mysql Quiz - Mysql Online Test - Best interview question

1. Which is the default order of sort in ORDER BY clause?

Ascending

Descending

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

SHOW DATABASES LIKE '%test%';

SHOW DATABASES LIKE '%test';

SHOW DATABASES LIKE 'test%';

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

MIN

LIKE

WHERE

4. MySQL supports multiple database storage engines.

Yes

No

5. Normalizations is...

a database design technique used to minimize data redundancy and duplication

a database design technique that eliminates relationships from a database

concerned with the physical implementation of the database

a database design technique that encourages storing data in multiple databases

6. What is a composite key?

its is a key that is defined as the primary key in another table

it is a key that uniquely identifies a record in a database

its is an optional key and allows null values

it is a primary key that consists of more than one field that uniquely identifies a record

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

DROP TABLE

DELETE TABLE

REMOVE TABLE

8. Which of the following is not an SQL aggregate function?

AVG

SUM

MIN

CURRENT_DATE()

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

Wrong

Correct

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

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

UNGRANT

UNDO

DELETE

REVOKE

12. In PHP in order to access MySQL database you will use.

mysqlconnect() function

mysql-connect() function

mysql_connect() function

sql_connect() function

13. How much character are allowed to create database name?

55

72

40

64

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