ANSI SQL Assessment

$16.00

ANSI SQL Assessment

$16.00
description

This test is intended to gauge the working knowledge of the test taker in ANSI SQL. The test covers such topics as joins, constraints, data modeling, data definition, retrieving data, indexes, data modification, subqueries, and the basic rules of ANSI SQL.

Assessments for Data Communications Concepts and Data Warehousing Concepts are also available.

 

Total Questions 39
Question Types Multiple Choice
Competencies Tested ANSI SQL Clause
ANSI SQL Concept
ANSI SQL Code Execution
ANSI SQL Syntax
Tasks Tested Restrict Rows
Types of Joins
Joining Multiple Tables
Selection
Undo DML Changes
Joins
Delete Table Data
DML
Subqueries
Remove Constraints
Transaction Control
Single Row Functions
Add Column to Table
Sequence
Constraints and Foreign Keys
Constraints and Indexes
Arithmetic Operators
Indexes
Read Consistency
Drop Objects
Grouping Data
Evaluating Code
Grouping and Sorting Data
Basic SELECT Statement
Full Outer Joins
Left Outer Joins
Select Statements
Aggregate Function
Roles
Data Grouping
Subquery Error
Group Function
Operators with SELECT
Operators
Unique Key Constraint
Sorting Data
DML Statements
DDL / DML
Advanced SELECT Statement