ClickATest Assessment Services

Only £52.00


Sample reports

Sample certificates

Adobe Reader is required to view these sample reports

SQL (ANSI) 2011 Fundamentals Test

Our SQL (ANSI) 2011 Fundamentals test measures your knowledge of database queries using ANSI SQL. This test is based on the 2011 ANSI standard. Designed for entry-level database programmers and administrators, this test covers the following topics: Aggregates and Sets, Complex Queries, DDL and DCL, Data Modification, Multi-Table Queries, Queries, SQL/PSM, Transactional Control, and Tuning and Debugging.



Scope Of The Online SQL (ANSI) 2001 Fundamentals Test

Aggregates and Sets
ANY, ALL, IN, EXISTS, UNIONS
GROUP BY
HAVING
NULLs
Complex Queries
Dataset Windows
Pipelined DML
Scalar Functions
Temporal Features
XML Features
Data Modification
DELETE
INSERT
UPDATE
View Data Update
DDL and DCL
Access Rights
Indexes and Constraints
Tables and Table Structure
Triggers
Views
Multi-Table Queries
INNER JOIN
OUTER JOIN
Self Joins
Queries
Access to Table Data
Equality Predicates
Filtering and Sorting
Subqueries
SQL/PSM
Cursors
Exception Handling
Flow Control
Variables
Writing SQL Modules
Transaction Control
Beginning Transactions
Ending Transactions
Nested Transactions
Savepoints
Tuning and Debugging
Explain Statements and Plans
Improving Query Performance
Resolving Query Errors

Duration

40 minutes.

Assessment Method of Questions

Multiple choice questions

Each question has between 2 and 8 options out of which 1 or more may be correct.

More links

Keywords

SQL ANSI 2011 Fundamentals assessment test, SQL ANSI 2011 Fundamentals test online, SQL ANSI 2011 Fundamentals