QUIZ START
#1. What does SQL stand for?
#2. With SQL, how do you select all the columns from a table named “Persons”?
#3. How much character are allowed to create database name?
#4. Which of the following ways below are the correct way to get the current date?
#5. Which SQL statement is used to extract data from a database?
#6. Enum values are stored accodring to their index numbers
#7. Which MYSQL statement is used to update data in a database?
#8. Which is the default order of sort in ORDER BY clause?
#9. How much storage space does DATETIME require?
#10. –i-am-a-dummy flag is used Makes the MySQL engine refuse UPDATE and which other command?
#11. Can I define multiple unique constraints on a table?
#12. Which MYSQL statement is used to return only different values?
#13. The OR operator displays a record if ANY conditions listed are true. The AND operator displays a record if ALL of the conditions listed are true
#14. How can we get the number of records or rows in a table?
#15. Can DISTINCT command be used for more than one column?
#16. On executing DELETE command, if you get an error “foreign key constraint”- what does it imply?
#17. Primary Key does allow the Null Values. where as in Unique key doesn’t accept the Null values.
#18. An outer join requires each record in the two joined tables to have a matching record.
#19. Can I call a trigger directly called from an application?
#20. Which SQL keyword is used to sort the result-set?
Finish