MySQL Assessment

$16.00

MySQL Assessment

$16.00
description

This MySQL test, based on MySQL 5.1, covers the overall knowledge of the test taker on MySQL, specifically focusing on SQL syntax, designing and querying, administration, performance optimization, security, back-up and recovery, controlling and managing MySQL servers, as well as database concepts like normalization, functions and operators, stored procedures, and triggers. This test is appropriate to administer to MySQL users with a year or more experience.

 

Total Questions 39
Question Types Multiple Choice
Competencies Tested Designing and Querying
Functions and Operators
Administration
DML
Creating and Modifying Tables
Controlling and Managing MySQL Server
Tasks Tested Commit and Rollback
Optimization
Functions
GROUP BY
Triggers
Symbols in Regular Expressions
Normalization
Returning Employee Tour Information
Vertical Output
Identifier Qualifiers
Utility Commands
String Functions
Built-in MySQL Functions
DATE/TIME
Subquery
Storage Engines
MySQL Admin
Federated Table
Safe Updates Mode
MySQL Commands
Using Different Platforms
Storage Engine
Database Administration Statements
Cursor Types
Stored Procedure
JOIN with Row Return
INSERT Statement
Load a Table from a Text File
Creating a View
Data Type
3NF
Value Range
Sequence
View and Table with Added Column
MySQL Enterprise Monitor
Partitioning
DESCRIBE Command
Managing Account Resource
Backup and Recovery