MySQL Assessment

$16.00

MySQL Assessment

$16.00
description

This MySQL test is designed to assess the knowledge of test takers concerning the basics of the MySQL database management system. The topics covered include commands, queries, statements, data types, errors and various other features. It is appropriate to administer this assessment to test takers with beginner and intermediate level knowledge of MySQL 5.7.

 

Number of questions 38
Competencies tested SQL Statements
Data Types
MySQL Feature
MySQL Query
Tasks tested Cursors
REPLACE
Local Variables in Stored Procedures
Current Date
Renaming Tables
ANALYZE TABLE Statement
Matching Value in Tables Join
Tables and Views
Prepared Statements
Range Queries
Temporary Tables and Committing Transactions
Autocommit
System Privileges
DELETE Trigger
Table Operations
CHAR and VARCHAR
ZEROFILL
Control Flow Operators
JSON Columns
Primary and Unique Key
System Variables
RedHat Linux MySQL Service
MySQL Comments
Not Found Error Code
Sys Schema
MEMORY Storage Engine
MySQL Storage Engine
Storage Engines
Native MySQL Functions
Concatenate Values
LEFT JOIN
SQL Query Code
Table Index
Eliminate Duplicate Rows
Correlated Subquery
UNION Query
Embedded SQL Query
Logging Information