MySQL Basic Quiz

1. What is the max limit of varchar?

2. “USE” keyword is used to select the ……….? 

3. What is the query to select all data of a table? 

4. How can we get the numbers of records in a table?

5. What is the default order of sort in ORDER BY clause?

6. When do we use “limit” clause?

7. Varchar will only accept string values?

8. Primary key do auto increament to values?

9. How much character allowed to create database name?

10. Which query is correct for “Deleting” data from a table named as “students” where id is 2?

11. Primary key and Unique key works same?

12. We can join two or more than two tables together?

13. We can make more than one primary key in a table?

14. We can insert null values in Primary key?

15. Write a query to search records from “students” table who are having “2” as value in the “id” field?

16. A view is nothing but a ………….. table or stored query.

17. We can create only one table in each database?

18. We can make a string as a primary key?

19. We cannot edit the structure of table after creating once ?

20. Joined tables cannot be updated?