SQL Entry Level Assessment

$16.00

SQL Entry Level Assessment

$16.00
description

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

 

Number of questions 36
Competencies tested SELECT statements
DDL (Data Definition Language) Commands
Functions
Subqueries
Tasks tested Where Clause Returned Values
Wildcard Characters
Invalid Comparison Operators
NULL Value Return 0
Union and Union All
WHERE Clause Usage
Set Operator for Retrieving Common Rows
NULL Values
Restrict Rows
Column Aliases
Concatenation Operator
NULL Value Evaluation
Arithmetic Operators
Sorting
If-Then-Else Function
SQL Syntax Statements
DDL Command
Row Deletion and Storage Space Deallocation
DDL Delete Commands
Orders Table Values
MIN and MAX Group Functions
Single Row Functions
Group Functions and Null Values
TRUNC Function
Group Function Correct Syntax
Group By Column
Date Manipulation Function
Numeric Position of a String
Data Type Conversion Function
Syntax Error
AVG and SUM Group Functions
No Rows Returned with Null Value
Join between Three Tables
Comparison Operators for Subquery
Clause Subquery
Left Outer Join