SQL Server 2014 for Developers Assessment

$16.00

SQL Server 2014 for Developers Assessment

$16.00
description

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.

 

Number of questions 48
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
SET NOCOUNT ON
SQL Server Profiler
Recreating Objects
Import/Export Data
Tracking Changes to Data
New User Database Creation
Database Schemas
CTE Usage
RDL File Format
Rowversion
Query to View Records
Tasks in Integration Services Package
ISNULL and COALESCE
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
Hekaton
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
XMLSC
Name Column Values
INFORMATION_SCHEMA
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