ClickATest Assessment Services

Only £52.00


Sample reports

Sample certificates

Adobe Reader is required to view these sample reports

SQL (ANSI) Test

Our SQL (ANSI) test measures your knowledge of SQL (ANSI). Designed for experienced users, this test covers the following topics: Aggregates and Sets, Complex Queries, DDL and DCL, Data Modification, Multi-Table Queries, SQL/PSM, Subqueries, Transaction Control, and Tuning and Debugging.



Scope of the Online SQL (ANSI) 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
DDL and DCL
Access Rights
Indexes and Constraints
Tables and Table Structure
Triggers
Views
Data Modification
DELETE
INSERT
UPDATE
View Data Update
Multi-Table Queries
FULL OUTER JOIN
INNER JOIN
LEFT/RIGHT OUTER JOIN
Self Joins
Queries
Access to Table Data
Constants and Comments
DISTINCT
Equality Predicates
Filtering and Sorting
SQL/PSM
Cursors
Exception Handling
Flow Control
Variables
Writing SQL Modules
Subqueries
Correlated
Row Deletion
Single Value
Subquery Based Updates
Transaction Control
Beginning Transactions
COMMIT
Nested Transactions
ROLLBACK
Savepoints
Tuning and Debugging
Explain Statements and Plans
Improving Query Performance
Recognizing Full Table Scans
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

Related Professions

Web Developer (BCIP), Database Administrator, Mainframe Programmer, Computer Programmer, Software Quality Analyst

Keywords

ansi sql practice test, ansi sql assessment test, online ansi sql assessment test