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. Can I call a trigger directly called from an application?

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

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

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

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

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

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

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

#9. Primary Key does allow the Null Values. where as in Unique key doesn’t accept the Null values.

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

#11. How much storage space does DATETIME require?

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

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

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

#15. What does SQL stand for?

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

#17. With SQL, how do you select all the columns from a table named “Persons”?

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

#19. Which MYSQL statement is used to delete data from a database?

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