The Transact SQL assessment measures the understanding of TSQL. Questions are based on both syntax and theory and are asked about various TSQL components, including DDL, DML, performance tuning, and administration. This test is reflective of the skill set typically required by Database Programmers, Database Programmer/Analysts, Data Warehouse Specialists, and TSQL programmers. Assessments for ANSI/SQL and SQL Server are also available. Total Questions 36 Question Types Multiple Choice Competencies Tested Basic Query ComponentsAdvanced Query ConceptsDMLDDLGranularity Tasks Tested Using Relational OperatorsTSQL SyntaxWhere ClauseBasic Query SyntaxManipulating ResultsGroup by ClauseIdentifying StructuresFiltering ResultsUnderstanding the * Symbol in a Select ClauseRelational OperatorsQuery ComponentsCase StatementsUpdatesIndexesNull FunctionsBreak and ContinueIdentifying StatementsConcatenationCursorsProcedure LogicOuter JoinsCorrelated Sub QueriesSub QueriesRestricting Result SetsEvaluating a QueryTSQL ObjectsTriggersAdvantages in IndexingVariable CreationProceduresAltering a ColumnDDL ImplicationsInsertsFinding Errors and WhyTransversing Your Data
