MySQL- Quiz1

Can DISTINCT command be used for more than one column?

No
Yes

Can I call a trigger directly called from an application?

Yes
No

A view is nothing but a ________ table or a stored query

Dynamic
Real
Virtual
Static

User() fucntion returns the current users user name and ___________

password
host name
both a and b above
database name associated with the user

If an ENUM column is declared NOT NULL, its default value is the first element of the list of allowed values.

True
False, ENUM column cannot be null
False, its default value is the last element of the list of allowed values

Which of the following ways below are the correct way to get the current date?

SELECT CURTIME();
SELECT CURDATE();
SELECT CURRENT_TIME();
All of above

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

Ascending
Descending

Enum values are stored accodring to their index numbers

True
False

An outer join requires each record in the two joined tables to have a matching record.

True
False

On executing DELETE command, if you get an error “foreign key constraint”- what does it imply?

Foreign key not defined
Table is empty
Connectivity issue
Data is present in the other table

USE keyword is used to select a ___________

Table
Column
Database
All of above

BLOB data type can have default column value.

True
False

What is a candidate key?

Used to uniquely identify a row
Alias for primary key
Used to identify a column

How much storage space does DATETIME require?

4 bytes
2 bytes
8 bytes
1 BYTE

–i-am-a-dummy flag is used Makes the MySQL engine refuse UPDATE and which other command?

WHERE
INSERT
DELETE
TRUNCATE

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

Using COUNT
Using NUM
Using NUMBER
Both a and c above

Which of the following file extension is a valid MyISAM file extension?

.ism
.myd
.my
.mys

Can I define multiple unique constraints on a table?

Yes
No

If an ENUM column is declared NOT NULL, its default value is the first element of the list of allowed values.

True
False, its default value is the last element of the list of allowed values
False, ENUM column cannot be null

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 above

User() fucntion returns the current users user name and ___________

password
host name
both a and b above
database name associated with the user

Can I call a trigger directly called from an application?

Yes
No

Write a query to delete a row from a table “academy” in database “wscube” whose “id” field have the value ‘2’ assuming that you are in the same database?

DELETE FROM wscube.academy where academy.id=2;
DELETE FROM `wscube`.`academy` where `academy`.`id`=2;
DELETE FROM 'wscube'.'academy' where 'academy'.'id'=2;
DELETE FROM “wscube”.”academy” where “academy”.”id”=2;
Both (a) and (b)

Write a query to search records who are having ‘3’ as value in it’s “id” field in a table “academy” in database “wscube”?

SELECT * FROM ‘academy’ WHERE ‘id’ =3;
SELECT * FROM academy WHERE id 3;
SELECT * FROM `academy` WHERE `id` =3;
SELECT * FROM `academy` WHERE `id` 3;

Write a select query to retrieve the records from the table “students”?

SELECT * FROM students
SELECT * FROM ` students `;
SELECT * FROM " students ";
SELECT * FROM ' students ';
Both (a) and (b)

How much character are allowed to create database name?

64
55
72
40

Primary Key does allow the Null Values. where as in Unique key doesn’t accept the Null values.

True
False

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

mysql_drop_database
mysql_drop_entiredb
mysql_drop_db
mysql_drop_dbase

What SQL clause is used to restrict the rows returned by a query?

AND
WHERE
HAVING
FROM

A table may be joined to itself.

True
False
None of the above

Quiz Summary

Information

Results

Results

Categories

1. Question

2. Question

3. Question

4. Question

5. Question

6. Question

7. Question

8. Question

9. Question

10. Question

11. Question

12. Question

13. Question

14. Question

15. Question

16. Question

17. Question

18. Question

19. Question

20. Question

21. Question

22. Question

23. Question

24. Question

25. Question

26. Question

27. Question

28. Question

29. Question

30. Question