MySQL Basic Quiz

1. Varchar will only accept string values?

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

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

4. Joined tables cannot be updated?

5. Primary key do auto increament to values?

6. How much character allowed to create database name?

7. Primary key and Unique key works same?

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

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

10. What is the max limit of varchar?

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

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

13. When do we use “limit” clause?

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

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

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

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

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

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

20. We can insert null values in Primary key?