SQL for Client-Server Applications Assessment

$16.00

SQL for Client-Server Applications Assessment

$16.00
description

The SQL for Client-Server Applications test examines the candidate's understanding of the key concepts needed to develop and use relational databases in a Client/Server environment. Topics covered include database design and usage. All questions are based on the ANSI standard SQL-92 syntax implemented by modern RDBMS products. Tests for SQL for Desktop Applications, SQL Developer, SQL Entry Level and SQL Server are also available.

 

Number of questions 40
Competencies tested Predicates
Unions
Key Concepts
SQL Syntax
Table Design
Syntax
Deleting Tables
Searching Tables
Query Tools
Updating Tables
Aggregates
Tasks tested Retrieving Data
Normal Forms
Cursors
Constrain Deferral
Joins
Dynamic SQL
Constraints
Transactions
Privileges
Modifying Data
Data Structure
Table Constraints
Data Structures
Tables
Deletions
Keys
Queries
Third Normal Form
Where and Having
Columns
Deleting Tables
Creating Tables
Unions
Update Privileges
Cursor-Based Operations
Match