MYSQL Quiz Test

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

2. Can I call a trigger directly called from an application?

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

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

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

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

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

8. Enum values are stored accodring to their index numbers

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

10. On executing DELETE command, if you get an error "foreign key constraint"- what does it imply?

11. USE keyword is used to select a ___________

12. BLOB data type can have default column value.

13. What is a candidate key?

14. How much storage space does DATETIME require?

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

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

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

18. Can I define multiple unique constraints on a table?

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

20. When do we use a HAVING clause?

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

22. Can I call a trigger directly called from an application?

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

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

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

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

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

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

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

30. A table may be joined to itself.