Home > Web Development > Quizzes > MySQL Fundamentals Test
MySQL Fundamentals Test
Fast practice, instant feedback. Timer auto-submits when time’s up.
Avg score: 23% • Most missed: “Which is NOT an available storage engine?”
MySQL Fundamentals Test
Time left 00:00
25 Questions

1. Which of the following is used to count the number of rows with different items?
2. What is the BDB Configuration for RAM dedicated to holding rows and indexes?
3. Which is TRIGGER in Mysql ?
4. How would you write a query to select all teams that won either 2 - 4 - 6 or 8 games?
5. The correct way to average all of the values from a column 'values' from table 'foo' is
6. Which SQL statement is used to extract data from a database?
7. What privilege must you have to execute a FLUSH statement?
8. Given two tables - t1 and t2 - the join condition 't1.t2_id = t2.id' how do you get rows from t1 that have NO counterparts in t2?
9. The data type BLOB stands for:
10. How would you select all the user_name values from records whose user_phonenumber field is null?
11. Which port does MySQL Server use by default?
12. I would like to retrieve the date with this format : dd/mm/YYYY in a field called btimestamp. Choose the correct way.
13. What does the following command output: 'SELECT 1'
14. What is the maximum allowed length of a column name?
15. Which of the following statements about Views is FALSE?
16. Which of the following is the correct way to retrieve rows with no duplicates?
17. What MySQL variable is used to limit a single SQL statement's size?
18. Which is NOT an available storage engine?
19. With SQL - how can you insert a new record into the 'Persons' table?
20. The USE keyword is used to select a _____.
21. Which SQL statement is used to return only different values?
22. What function eliminates beginning and ending white space characters from a string?
23. The __________ application performs verification - repair - analysis - and optimization of MySQL databases - tables - and data.
24. With SQL - how do you select a column named 'FirstName' from a table named 'Persons'?
25. Which date calculation interval works on days - hours - and minutes?

⚡ Recently practiced quizzes in this topic
Live quiz activity
Web Technology Basics Practice Test: Handling Tables Web Technology Basics Practice Test: Web Development Frameworks - Vue JS, Bootstrap, React JS and Angular JS Web Technology Basics Practice Test: Basic HTML Concepts Web Technology Basics Practice Test: Handling Images, Audio and Video Web Technology Basics Practice Test: Basic JavaScript Concepts Web Technology Basics Practice Test: Links and Navigation Web Technology Basics Practice Test: Basic CSS Concepts Nagios Basics Practice Test Basic Full Stack Development (FSD) Knowledge Test Web Development using Java Practice Test Questions
 
❤ If you liked Fatskills, consider supporting us by checking out The Life Manuals You Never Got.

🌈  Our mission is to help improve your scores in any subject and exam withonline quizzes, practice tests, study guides, & advice for students. Since 2018.
About | Explore | User Guide | Topics | Subjects | Doubt Solver | Career Aptitude Test | Answers | Free Tools | OSHA Basics Quiz | What Should We Know?
Privacy | Terms |
Without work one finishes nothing. - Ralph Waldo Emerson
© 2026 Fatskills.com

All trademarks, logos and brand names are the property of their respective owners. All company, product and service names used in this website are for identification purposes only. Use of these names, trademarks and brands does not imply endorsement.