MySQL Quiz 3 Share with others Enter details and click on Next Name Email School Name Q21. Which of the following data type store only integers in MySQL? Numeric Decimal Integer All of the above None Q22. How many bytes will be consumed if we store data "RAM" in a field named "ITEM" and whose data type is char(20)? 3 4 20 21 None Q23. Which of the following is fixed length data type? Char Varchar All of the above None Q24. What is the meaning of following statement? decimal(8,2) Total 8 digits including 2 decimal places 8 digits before decimal and 2 digits after decimal Total 10 digits None Q25. Which command is used to see all the databases already created in MySQL server? Show database; Show databases; All databases; None Q26. All the statements in MySQL are terminated by. Comma(,) Colon(;) Semicolon(;) No need to terminate None Q27. MySQL statements are case sensitive.(T/F) True False None Q28. Which command is used to open already created database? open use used None of the above None Q29. What is the default format of Date in MySQL? dd/mm/yyyy yyyy/dd/mm yyyy/mm/dd None Q30. Date values to be entered needs to be enclosed in quotes(" ")[T/F] True False None Time's upTime is Up! Related Share with others
Sir/Madam shouldn’t the ans to q-30 be false. Date values need not to be enclosed in “” always. its only when we write date like this “2025-08-30” not when when we write 20250830 Reply
very helpful site
Thank you so much.
yeahhhh it is a really good and helpful site for practice
VERY USEFUL
love this site wow
Sir/Madam shouldn’t the ans to q-30 be false. Date values need not to be enclosed in “” always. its only when we write date like this “2025-08-30” not when when we write 20250830
It’s True