MySQL Basic Quiz

1. What is the max limit of varchar?

2. Primary key and Unique key works same?

3. How much character allowed to create database name?

4. When do we use “limit” clause?

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

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

7. We can insert null values in Primary key?

8. Joined tables cannot be updated?

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

10. Primary key do auto increament to values?

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

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

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

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

15. Varchar will only accept string values?

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

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

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

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

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