Mysql Quiz - Mysql Online Test - Best interview question

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

MIN

WHERE

2. MySQL supports multiple database storage engines.

Yes

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

4. Which of the following SQL statements will generate an error when executed?

CREATE DATABASE students

CREATE DATABASE students;

create database if not exists students

IF NOT EXISTS CREATE DATABASE `STUDENTS`;

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

Using COUNT

Using NUM

Using NUMBER

Both a and c above

6. 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;

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

getTime()

Time()

NOW()

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. Which of the following is NOT available in MySQL?

FETCH

JOIN

REVOKE

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

mysql_drop_database

mysql_drop_entiredb

mysql_drop_db

mysql_drop_dbase

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

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

SORT BY

ORDER BY

ARRENGE BY

None of the above

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

Yes

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