SQL Server 2014 for Developers Assessment


SQL Server 2014 for Developers Assessment

Skills Assessment

This SQL Server 2014 for Developers test has been designed to verify the ability of a developer to effectively work in a SQL 2014 environment. Topics covered by this test include data types, SQL programming, transaction management, tools and utilities, system stored procedures, and understanding code. This assessment is appropriate for developers that have at least a year or more of SQL Server 2014 experience.


What Am I Buying?
When you purchase an assessment with Talevation, you will receive a credit for our online assessment portal. To access your purchase, you must head to our Login page found in the top right corner. There, you may redeem your credit and generate a link which will be sent to the candidate of your choosing.

How does it work?
Total Questions 48
Question Types Multiple Choice
Competencies Tested System Stored Procedures
Tools and Utilities
Transaction Management
SQL Programming
Understanding Code
Tasks Tested System Stored Procedure
Access Database Objects
Database Object Details
OLE Automation Objects
SQL Server Profiler
Recreating Objects
Import/Export Data
Tracking Changes to Data
New User Database Creation
Database Schemas
CTE Usage
RDL File Format
Query to View Records
Tasks in Integration Services Package
Service Broker Queue
Predicate for Full-Text Search
Performing Mass Updates
Prefix N for String Constants
Index on Date Columns
Object in FROM Clause
Truncate Table
Delayed Transaction Durability
In-Memory OLTP Implementation
Table-Valued Function Usage
Valid Data Types
Data Types for Full-Text Search
Tinyint Data Type
Service Broker Enablement
Memory-Optimized Tables
Modifying XML Data
Name Column Values
Querying XML Data
Evaluate Statements
Structured Error-Handling
Dynamic SQL in Procedures
Transaction Management
APPLY Operator Usage
Implementing Database Mail
Query Return
Poor Query Performance
Query Review