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. Which MYSQL statement is used to return only different values?

#2. When do we use a HAVING clause?

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

#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 of the following file extension is a valid MyISAM file extension?

#6. BLOB data type can have default column value.

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

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

#9. What does SQL stand for?

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

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

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

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

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

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

#16. How much storage space does DATETIME require?

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

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

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

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