OBJECTIVES Create and alter databases. Considerations include file
OBJECTIVES Create and alter databases. Considerations include file groups, file placement, growth strategy, and space requirements. Specify space management parameters. Parameters include autoshrink, growth increment, initial size, and maxsize. Specify file group and file placement. Considerations include logical and physical file placement. Specify transaction log placement. Considerations include bulk load operations and performance. . The placement of the files related to a SQL Server 2000 database environment helps to ensure optimum performance while minimizing administration. Recoverability can also be improved in the event of data corruption or hardware failures if appropriate measures are taken. On the exam, you must be prepared to respond to these requirements and properly configure the interactions with the file system. Create and alter database objects. Objects include constraints, indexes, stored procedures, tables, triggers, user-defined functions, and views. Specify table characteristics. Characteristics include cascading actions, CHECK constraints, clustered, defaults, FILLFACTOR, foreign keys, nonclustered, primary key, and UNIQUE constraints. Specify schema binding and encryption for stored procedures, triggers, user-defined functions, and views. Specify recompile settings for stored procedures. Specify index characteristics. Characteristics include clustered, FILLFACTOR, nonclustered, and uniqueness. CHAPTER 3 Physical Database Design and Implementation
For high quality website hosting services please check java web hosting website.