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.

 

Total Questions 40
Question Types Multiple Choice
Competencies Tested Predicates
Unions
Key Concepts
Table Design
Updating Tables
Syntax
SQL Syntax
Aggregates
Searching Tables
Deleting Tables
Query Tools
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