MySQL Basic Quiz

1. Primary key do auto increament to values?

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

3. Primary key and Unique key works same?

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

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

6. What is the max limit of varchar?

7. How much character allowed to create database name?

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

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

10. Joined tables cannot be updated?

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

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

13. When do we use “limit” clause?

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

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

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

17. We can insert null values in Primary key?

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

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

20. Varchar will only accept string values?