SQL Server 7.0 is Microsoft's enterprise scale relational database management system (RDBMS). Its features compete with other top of the line RDBMS from Oracle, Informix, Sybase and IBM. This test measures the skill of developers responsible for designing, programming and implementing a database using SQL Server 7.0. Tests for SQL Server 7.0 DBA, SQL Entry Level and SQL for Client-Server Applications are also available. Total Questions 43 Question Types Multiple Choice Competencies Tested Data ModelingSystem Databases and TablesData DefinitionData RetrievalModifying DataIndexesViews, Defaults and RulesProgrammabilityTriggersReplicationApplication Development and Open Data Services Tasks Tested ModelingSystem Databases and TablesData DefinitionData RetrievalHaving ClauseSub-queriesData ManipulationBCPIndexQuery OptimizerClustered IndexViewsRulesFETCHCursorsMAPITriggersReplicationNative synchronizationReplication Tablesextended stored procedureOLE AutomationODBC
