Mysql Quiz - Mysql Online Test - Best interview question

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

Ascending

Descending

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

MIN

LIKE

WHERE

3. When do we use a HAVING clause?

To limit the output of a query

To limit the output of a query using an aggregate function only

When GROUP by is used

both b and c

4. MySQL supports multiple database storage engines.

Yes

No

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

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

Wrong

Correct

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

NO DUPLICATE

DISTINCT

UNIQUE

None of the above

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

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

FETCH

LIKE

JOIN

REVOKE

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

mysqlconnect() function

mysql-connect() function

mysql_connect() function

sql_connect() function

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 datatypes are treaded as arrays?

Integer

String

Float

Booleans

13. BLOB data type can have default column value.

True

False

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

Yes

No

15. Can I call a trigger directly from an application?

Yes

No

MySQL MCQ Questions

List of Frequently asked MySQL MCQ Questions