|
Aaron West
|
| Test: |
MS SQL Server 2008 Programming |
| Date: |
06-Mar-2012 |
| Score: |
4.67 |
| Correct/Total: |
(36/40)
|
|
|
SQL Queries
|
(6/6)
|
|
Subqueries and CTEs
|
(1/1)
|
|
Joins and Unions
|
(1/1)
|
|
Single-Table Queries
|
(3/3)
|
|
Windowing and Ranking
|
(1/1)
|
|
Transact-SQL
|
(5/7)
|
|
Batches, Scope, Variables, and Procs
|
(2/3)
|
|
Views
|
(2/2)
|
|
Cursors
|
(1/1)
|
|
Error-handling
|
(0/1)
|
|
User-Defined Functions
|
(3/5)
|
|
Scalar UDFs
|
(1/2)
|
|
Multi-Statement Table-Valued UDFs
|
(2/2)
|
|
Single-Statement Table-Valued UDFs
|
(0/1)
|
|
Database Design
|
(5/5)
|
|
Table Design
|
(1/1)
|
|
Keys
|
(1/1)
|
|
Normalization
|
(2/2)
|
|
Data Types
|
(1/1)
|
|
Data Modification
|
(5/5)
|
|
Insert
|
(2/2)
|
|
Update
|
(1/1)
|
|
Delete
|
(2/2)
|
|
Performance and Optimization
|
(4/4)
|
|
Execution Plans
|
(1/1)
|
|
Indexing Design
|
(3/3)
|
|
Beyond Relational
|
(3/3)
|
|
XML
|
(2/2)
|
|
Full-Text Search
|
(1/1)
|
|
Triggers
|
(1/1)
|
|
DDL Triggers
|
(1/1)
|
|
Architecture
|
(2/2)
|
|
Transactions
|
(2/2)
|
|
Tools
|
(2/2)
|
|
Profiler / SQL Trace
|
(2/2)
|
|
