Test Center

It is easy to see the newest titles that have been added to the test library. Go to the Test Center and click "View All Free Tests". The list will include the latest tests. Come see what is new and measure your skills!

MySQL 5.7 Administration

Description:

Our MySQL 5.7 Administration test measures your knowledge of MySQL 5.7 Administration. Designed for experienced administrators, this test covers the following topics: Data Manipulation, Data Types, Database Changes, Disaster Recovery and Backup, Installation and Configuration, Modifiers, Performance Tuning, Security, Security Administration, and Storage Engines and Tables.

FREE

Once you request a test, your Personal Identification Number (PIN) will be stored in your My Plan for easy access. You will have 90 days in which to take the test you requested.

Test Outline

Data Manipulation
Administrative Command Line Program
Delete
Insert
Select
Update
Data Types
Date Data
Numeric Data
Spatial Data
Text Data
Database Changes
Altering Tables
Creating and Dropping Tables
Optimization Functions
Rename
Transaction/Locking Functionality
Disaster Recovery and Backup
Backup Scheduling
Logical Database Dumps
Schema
Table Maintenance
Installation and Configuration
Environment Variables
Log Rotation Setup
Replication
Software and Patches
User Accounts
Modifiers
Full Text Search Modifiers
MySQL Specific SQL Statements
Stored Programs
Performance Tuning
Additional Optimizers
Index Condition Pushdown (ICP)
Optimizer_Switch
Persistent Optimizer Statistics
Query Optimization Commands
Security
Encryption
Privilege System-Databases
Privilege System-Operating System
Privilege System-Tables
Secure Sockets Layer (SSL)
Security Administration
Database Object Permissions
Database Permissions
Grant Table Permissions
Security Policy
Storage Engines and Tables
InnoDB Tables
MemoryTables
Merge or Partitioned Tables
MyISAM Table