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

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

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

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

FETCH

LIKE

JOIN

REVOKE

10. Which of the following is available in MySQL?

CREATE VIEW

CREATE DATABASE

CREATE TRIGGER

CREATE SCHEMA

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

mysqlconnect() function

mysql-connect() function

mysql_connect() function

sql_connect() function

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

55

72

40

64

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

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