ClickATest Assessment Services

Only £52.00


Sample reports

Sample certificates

Adobe Reader is required to view these sample reports

MS SQL Server 2012 Programming Test

Our MS SQL Server 2012 Programming test measures knowledge of MS SQL Server 2012 Programming. Designed for experienced database programmers, but an average performer in this role should pass this test. This test covers the following topics: Beyond Relational, Control Flow, Data Types and NULL, Database Design, Developer Tools, Modifying Data, Running Queries, and Writing Queries.



Scope of the online MS SQL Server 2012 Programming Test

Beyond Relational
FileTable and FILESTREAM
Full-Text Search
Spatial
XML
Control Flow
Conditional Statements
Exception Handling
Loops and Cursors
Data Types and NULL
Date and Time
Hierarchies
NULL values
Numeric and Character Data
Parsing and Converting
Database Design
Constraints
Indexes
Sequences
Tables
Triggers
Views
Developer Tools
Execution Plans
Profiler / SQL Trace
SQL Server Data Tools
Modifying Data
Deleting Data
Inserting Data
Updating Data
Running Queries
Distributed Queries
EXECUTE Statement
Set Operators
Stored Procedures and Functions
Transactions
Writing Queries
Grouping and Aggregation
Joins
Ordering
Ranking and Window Functions
Subqueries and CTEs

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

programmer, developer

Keywords

MS SQL server 2012 programming test, MS SQL server 2012 programming test online, MS SQL server 2012 programming skill test, information technology, computers, IT industry