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. BLOB data type can have default column value.

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

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

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

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

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

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

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

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

#10. How much storage space does DATETIME require?

#11. What does SQL stand for?

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

#13. When do we use a HAVING clause?

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

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

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

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

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

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

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