16 Part I EXAM PREPARATION TIPExam Questions about
16 Part I EXAM PREPARATION TIPExam Questions about the New Features You can expect to have one or more exam questions for each feature in the list of New Features. We have broken down the complete list of new features in SQL Server 2000 and have focused in on those you can expect on the exam. Those new features not likely to be seen on the exam have been omitted from this list. EXAM New Features in SQL Server 2000 A great deal more functionality has been added to SQL Server in this 2000 release. Many of the features are extremely useful in the stages of design and implementation of databases. The features listed and described in this section represent the highlights of the new features most commonly of interest to developers and a necessity in exam preparation. XML support Federated database servers User-defined functions Indexed views New data types INSTEAD OF and AFTER triggers Cascading referential integrity constraints Collation enhancements Multiple instances of SQL Server Updateable distributed partitioned views The relational database engine can return data as Extensible Markup Language (XML) documents. Additionally, XML can also be used to insert, update, and delete values in the database. XML is covered fully in Chapter 5, Advanced Data Retrieval and Modification. SQL Server 2000 supports distributed partitioned views that enable you to divide tables horizontally and place the data on multiple servers. A group of federated database servers can support the data storage requirements of the largest web sites and enterprise systems. Partitioned views are covered fully in Chapter 7, Working with Views. You can extend the programmability of SQL Server by creating your own Transact-SQL (T-SQL) functions. T-SQL is an extension of the language defined by SQL standards and the basis for programming in SQL Server. A user-defined function can return either a scalar value or a table. User-Defined Functions (UDFs) are covered fully in Chapter 9, Stored Procedures and User-Defined Functions. Indexed views can significantly improve the performance of an application where queries frequently perform certain joins or aggre
For high quality java hosting services please check tomcat web hosting website.