Results
%3Cspan%20style%3D%22color%3A%20%23339966%22%3E%3Cstrong%3ECongratulations.%3C%2Fstrong%3E%3C%2Fspan%3E
%3Cstrong%3E%3Cspan%20style%3D%22color%3A%20%23ff0000%22%3EFail%3C%2Fspan%3E%2C%20Try%20Again%3C%2Fstrong%3E
#1. Can DISTINCT command be used for more than one column?
#2. Enum values are stored accodring to their index numbers
#3. BLOB data type can have default column value.
#4. An outer join requires each record in the two joined tables to have a matching record.
#5. Primary Key does allow the Null Values. where as in Unique key doesn’t accept the Null values.
#6. With SQL, how do you select all the columns from a table named “Persons”?
#7. How much character are allowed to create database name?
#8. Which MYSQL statement is used to delete data from a database?
#9. 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
#10. Which MYSQL statement is used to update data in a database?
#11. Can I define multiple unique constraints on a table?
#12. How much storage space does DATETIME require?
#13. Which of the following ways below are the correct way to get the current date?
#14. What does SQL stand for?
#15. Which MYSQL statement is used to return only different values?
#16. Can I call a trigger directly called from an application?
#17. What is a candidate key?
#18. How can we get the number of records or rows in a table?
#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?