SQL (Structured Query Language) was developed in 1977 and is the standard set language. SQL is an integral part of many client/server applications including Oracle, Sybase and Informix. SQL is a very popular language used to connect database applications with other applications and is extensively used in Client/Server implementations. This test specifically assesses the SQL dialect used in Microsoft's product referred to as SQL Server and would be appropriate to be given to programmers. Tests for SQL Server 2000 for Developers, SQL Server 2000 DBA and ANSI SQL are also available. Total Questions 40 Question Types Multiple Choice Competencies Tested T-SQL ProgrammingSystem AdministrationPerformance and TuningOpen Client Programming Tasks Tested TablesSelect StatementSelect - Order - ComputeTable StructureStored ProceduresSystem variablesViewsConstraintsCursorsTriggersError MessagesExt-Stored ProceduresTemporary ObjectsSelect - GroupDefaultsIncorporating DelaysSecurityTroubleshootingSQL ExecutiveTransaction ManagementDatabase ConsistencyData TransferPermissionsDevice ManagementSQL MailDatatypesDatabase ManagementData RecoveryQuery OptimizationIndex OptimizingCode OptimizingData Access Options
