Home > Databases > Quizzes > MySQL Basics Practice Test: MySQL Administration
MySQL Basics Practice Test: MySQL Administration
Fast practice, instant feedback. Timer auto-submits when time’s up.
Avg score: 82% • Most missed: “Which of these exports table definitions and contents?”

Quiz on MySQL components and administration, access control and security, database maintenance, backups and replication.
 

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

1. How many of these are for use with only MyISAM tables?
mysql, mysqladmin, mysqldump, mysqlisamchk
2. The hub of a MySQL installation is ______________
3. SBR replication is ______________
4. The number of languages that have interfaces to bind to the C API of MySQL among these is ______________
Perl, PHP, Python
5. What is the general statement-issuing routine?
6. The most restrictive among the following is ______________
mysql_query(), mysql_real_query()
7. The tool for copying databases is ______________
8. Which statement is used to check how MySQL would execute a SELECT query?
9. The option necessary to compile a C program havin math functions is ______________
10. Which of these exports table definitions and contents?
11. The default scheduling property of MySQL is implemented by how many of these?
MyISAM, MERGE, MEMORY
12. For InnoDB tables in mysqldump an online backup that takes no locks on tables can be performed by ______________
13. The language that is the core for APIs and communication in MySQL is ______________
14. The max_binlog_cache_size system variable has default size ______________
15. The function used to convert an int to string is ______________
16. What has a higher priority?
writes, reads
17. The log in which data changes received from a replication master server are written are ______________
18. To reload a delimited text data file use ______________
19. Replication enables data from one MySQL database server to be copied to one or more MySQL database servers.
20. Which of the following use ‘NULL’ to indicate failure?
mysql_init(), mysql_real_connect()
21. A password applies globally to an account.
22. What is the option for specifying the executable name while compiling with gcc?
23. The context in which the privilege ‘CREATE TABLESPACE’ applies is ______________
24. The system variable controls the size of the table cache _________________
25. The library file that contains various portability macros and definitions is ______________

⚡ 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.