MySql Quiz Test

This website uses cookies to improve your experience while you navigate through the website. Out of these cookies, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may have an effect on your browsing experience.

Results

#1. What does SQL stand for?

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

#3. When do we use a HAVING clause?

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

#5. Which SQL statement is used to extract data from a database?

#6. How much character are allowed to create database name?

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

#8. Which MYSQL statement is used to update data in a database?

#9. Enum values are stored accodring to their index numbers

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

#11. What is a candidate key?

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

#13. Can I define multiple unique constraints on a table?

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

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

#16. How much storage space does DATETIME require?

#17. Which SQL keyword is used to sort the result-set?

#18. Which MYSQL statement is used to return only different values?

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

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