QUIZ START
#1. How can we get the number of records or rows in a table?
#2. When do we use a HAVING clause?
#3. How much storage space does DATETIME require?
#4. How much character are allowed to create database name?
#5. Which is the default order of sort in ORDER BY clause?
#6. What does SQL stand for?
#7. BLOB data type can have default column value.
#8. –i-am-a-dummy flag is used Makes the MySQL engine refuse UPDATE and which other command?
#9. Which MYSQL statement is used to delete data from a database?
#10. Which SQL statement is used to extract data from a database?
#11. Primary Key does allow the Null Values. where as in Unique key doesn’t accept the Null values.
#12. Can I call a trigger directly called from an application?
#13. Which MYSQL statement is used to update data in a database?
#14. What is a candidate key?
#15. With SQL, how do you select all the columns from a table named “Persons”?
#16. Can I define multiple unique constraints on a table?
#17. Enum values are stored accodring to their index numbers
#18. Which of the following file extension is a valid MyISAM file extension?
#19. Which of the following ways below are the correct way to get the current date?
#20. Can DISTINCT command be used for more than one column?
Finish