SQL Entry Level Assessment

  • $10.00

This SQL Entry Level assessment is designed to assess a assessment taker's understanding of basic SQL concepts. The assessment is a mixture of syntax rules as well as practical code examples. Topics covered by this assessment include select statements, basic DDL (Data Definition Language) statements, functions (single-row and group), joins and subqueries. This assessment is appropriate for assessment takers that are beginners with less than a year of experience with SQL.

Number of questions 36
Test format Multiple-Choice
Time to complete Varies by skill
Topics covered DDL (Data Definition Language) Commands
SELECT statements
Tasks tested Arithmetic Operators
AVG and SUM Group Functions
Clause Subquery
Column Aliases
Comparison Operators for Subquery
Concatenation Operator
Data Type Conversion Function
Date Manipulation Function
DDL Command
DDL Delete Commands
Group By Column
Group Function Correct Syntax
Group Functions and Null Values
If-Then-Else Function
Invalid Comparison Operators
Join between Three Tables
Left Outer Join
MIN and MAX Group Functions
No Rows Returned with Null Value
NULL Value Evaluation
NULL Value Return 0
NULL Values
Numeric Position of a String
Orders Table Values
Restrict Rows
Row Deletion and Storage Space Deallocation
Set Operator for Retrieving Common Rows
Single Row Functions
SQL Syntax Statements
Syntax Error
TRUNC Function
Union and Union All
Where Clause Returned Values
WHERE Clause Usage
Wildcard Characters
Supported languages ๐Ÿ‡บ๐Ÿ‡ธ English (en_US)