Home > Databases > Quizzes > MySQL Basics Practice Test: General MySQL Administration
MySQL Basics Practice Test: General MySQL Administration
Fast practice, instant feedback. Timer auto-submits when time’s up.
Avg score: 56% • Most missed: “What is the clause that filters JOIN results called?”

Quiz on MySQL installation and server startup, managing MySQL user accounts, maintaining logs, server tuning, storage engine configuration, running multiple servers, internationalization and localization issues.

Tip: mysqladmin is a client for performing administrative operations. You can use it to check the server's configuration and current status, to create and drop databases, and more.

Invoke mysqladmin like this: mysqladmin [options] command [command-arg] [command [command-arg]] ...

Related Test: MySQL Basics Practice Test: MySQL Administration

MySQL Basics Practice Test: General MySQL Administration
Time left 00:00
25 Questions

1. Stored programs degrade database security.
2. The statement used to find out which character sets are available is ______________
3. What is the SQL mode to check for divide by zero error?
4. Increasing the value of which system variable enables mysqld to keep more tables open simultaneously?
5. The ALL subquery performs the operation _____________
6. What is the storage size in bytes required for the MEDIUMINT datatype?
7. The storage engine in MySQL that provides foreign key support is ___________
8. The log that identifies statements that may be in need of being rewritten for better performance is ______________
9. What is the default storage engine?
10. The keyword used with UNION that retains duplicate rows is ______________
11. What is x’ffff’ in decimal?
12. The clause that can be used to sort string values according to a specific collation is ______________
13. Execution on a time activated basis according to a schedule is done by _____________
14. The keyword used to create a database is __________
15. What is the precision of BIGINT?
16. Which upgrade involves exporting existing data using mysqldump?
17. Which system variable enables mysqld to keep more tables open simultaneously?
18. What is the join where all possible row combinations are produced?
19. For which of these storage engines are configuration options always built?
20. The mode used to turn on strict mode and all of the additional restrictions is _____________
21. The keyword used with UNION that retains duplicate rows is ___________
22. The most important configurable resource for MyISAM is ______________
23. The operators that are used when a subquery returns multiple rows to be evaluated in comparison to the outer query are _____________
24. The system variable ‘system_time_zone’ can be reset at runtime.
25. What is the synonym for REAL?

⚡ Recently practiced quizzes in this topic
Live quiz activity
DBMS Basics Practice Test: SQL - Queries, Constraints and Triggers Database Fundamentals Transact-SQL (T-SQL) Practice Test PostgreSQL Fundamentals Test SQL Server Vocab Redis Practice Test (NoSQL) DBMS Basics Practice Test: Indexing and Hashing Database Management System (DBMS) Practice Test: All Topics SQL Fundamentals Test SQL MCQs
 
❤ 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.