ClickATest Assessment Services

Only £52.00


Sample reports

Sample certificates

Adobe Reader is required to view these sample reports

MySQL 3.23 Administration Test

This test measures your knowledge of MySQL 3.23 Administration. Designed for the experienced administrators, this test covers the following topics: Administrative Program Usage, Disaster Prevention, Installation & Configuration, Interfacing with Other Products, Security, SQL Usage - Data Manipulation, SQL Usage - Other, SQL Usage - Table & Administrative, and Table & Data Types.



Scope of the Online MySQL 3.23 Administration Test

Administrative Program Usage
myisamchk
mysql_setpermission
mysqladmin
Disaster Prevention
Backup Scheduling
mysqlcheck
mysqldump
mysqlshow
Installation & Configuration
Binary Installation
Environment Variables
Log Rotation Setup
Multiple Servers
Replication
RPM Based Install
Source Compile Installation
User Accounts
Windows Installation
Interfacing with Other Products
Interfacing with Apache
Using ODBC/JDBC
Using the PHP/Perl API
Security
Privilege System-Databases
Privilege System-OS Privileges
Privilege System-Tables
SQL Usage - Data Manipulation
Delete
Insert
Select
SQL Usage - Other
Missing Functionality
mySQL Specific SQL Statements
SQL Usage - Table & Administrative
Alter
Create/Drop Database/Table
Optimization Functions
Rename
Transaction/Locking Functionality
Table & Data Types
Date Data
Heap Tables
InnoDB Tables
ISAM Tables
Merge Tables
MyISAM Table
Numeric Data
Text Data

Duration

40 minutes.

Assessment Method of Questions

Multiple choice questions

Each question has between 2 and 8 options out of which 1 or more may be correct.

More links

Related Professions

Database Administrator

Keywords

MySQL 3.23 administration assessment test, clickatest MySQL 3.23 administration assessment test, MySQL 3.23 administration test, information technology, computers, IT industry