MCAD/MCSE/MCDBA 70-229 Exam Cram 2: Designing & Implementing Databases w/SQL Server 2000 Enterprise Edition
Index[SYMBOL] [A] [B] [C] [D] [E] [F] [G] [H] [I] [J] [K] [L] [M] [N] [O] [P] [Q] [R] [S] [T] [U] [V] [W] [X] data access concurrency 2nd 3rd exam prep questions 2nd 3rd 4th 5th 6th indexes 2nd clustered 2nd covering 2nd dropping 2nd full-text 2nd Index Tuning Wizard 2nd indexed views 2nd nonclustered 2nd 3rd rebuilding 2nd 3rd strategies 2nd what not to index 2nd 3rd what to index 2nd locks 2nd 3rd contention 2nd controlling lock behavior 2nd 3rd exclusive locks granularity shared locks transaction isolation levels 2nd partitioned views 2nd indexing 2nd stored procedures 2nd 3rd 4th recompilation 2nd web applications and 2nd transactions 2nd 3rd atomicity beginning 2nd consistency durability isolation isolation levels 2nd rolling back 2nd data analysis 2nd data cache data encryption [See encryption] data files data formatting 2nd data integrity definition of data modeling [See logical data modeling] data normalization [See normalization] data replication [See replication] data retrieval conditional data filtering arithmetic operators BETWEEN keyword bitwise operators comparison operators 2nd EXISTS keyword IN keyword LIKE keyword 2nd logical operators 2nd NULL values 2nd unary operators exam prep questions 2nd 3rd 4th 5th 6th 7th 8th joining multiple sets of data 2nd cross joins 2nd inner joins 2nd outer joins 2nd 3rd unions 2nd 3rd moving data 2nd BACKUP/RESTORE operations 2nd BCP (Bulk Copy Program) 2nd 3rd 4th DTS Import/Export Wizard 2nd XML (Extensible Markup Language) 2nd 3rd SELECT statement arithmetic operators BETWEEN keyword bitwise operators column names, specifying 2nd comparison operators 2nd COMPUTE BY clause COMPUTE clause CUBE keyword 2nd DISTINCT clause EXISTS keyword EXPLICIT clause 2nd FOR XML clause 2nd FROM clause GROUP BY clause 2nd HAVING clause IN keyword INTO clause 2nd LIKE keyword 2nd logical operators 2nd NULL values 2nd OPENXML keyword 2nd 3rd ORDER BY clause 2nd ROLLUP keyword 2nd SET ROWCOUNT clause simple example 2nd 3rd TOP clause 2nd unary operators WHERE clause Data Transformation Services [See DTS] Data Type descriptor (columns) data types 2nd binary data types 2nd casting 2nd character data types 2nd converting 2nd metadata 2nd numeric data types 2nd object definitions 2nd specialty data types 2nd user data 2nd user-defined data types 2nd 3rd database concurrency 2nd 3rd owners Database Console Command [See DBCC] database diagrams 2nd definition of Database Properties dialog box 2nd Auto options 2nd Cursor options 2nd Recovery options 2nd SQL options 2nd 3rd State options 2nd 3rd databases 2nd 3rd 4th 5th 6th 7th 8th [See also logical data modeling] [See also exam prep questions] [See also security] (relational) alerts altering cascade action 2nd checks and balances CHECK constraints 2nd COLUMN CHECK constraints 2nd TABLE CHECK constraints collation sequences 2nd configuration options 2nd ANSI_NULL_DEFAULT ANSI_NULLS ANSI_PADDING ANSI_WARNINGS ARITHABORT AUTO_CLOSE 2nd AUTO_CREATE_STATISTICS AUTO_SHRINK AUTO_UPDATE_STATISTICS CONCAT_NULL_YIELDS_NULL CURSOR_CLOSE_ON_COMMIT CURSOR_DEFAULT GLOBAL CURSOR_DEFAULT LOCAL MULTI_USER NUMERIC_ROUNDABORT OFFLINE QUOTED_IDENTIFIER READ_ONLY READ_WRITE RECOVERY BULK_LOGGED RECOVERY FULL RECOVERY SIMPLE RECURSIVE_TRIGGERS RESTRICTED_USER SINGLE_USER TORN_PAGE_DETECTION WITH termination (termination in italic) 2nd constraints definition of creating 2nd 3rd 4th 5th data types user-defined data types database diagrams 2nd definition of default names defaults 2nd 3rd definition of 2nd deleting data from 2nd 3rd denormalization 2nd 3rd 4th 5th dependencies parent-child design 2nd distribution exam prep questions 2nd 3rd 4th 5th 6th fields definition of file system file placement 2nd filegroups 2nd filenames primary files secondary files Full-Text catalogs 2nd indexes 2nd 3rd 4th 5th 6th clustered 2nd clustered indexes 2nd covering 2nd creating 2nd definition of dropping 2nd fill factor 2nd full-text 2nd Full-Text indexes 2nd Index Tuning Wizard 2nd indexed views 2nd nonclustered 2nd 3rd nonclustered indexes 2nd Pad Index setting rebuilding 2nd 3rd 4th strategies 2nd unique indexes what not to index 2nd 3rd what to index 2nd inserting data into 2nd 3rd jobs joining multiple sets of data 2nd cross joins 2nd inner joins 2nd outer joins 2nd 3rd unions 2nd 3rd locks 2nd 3rd contention 2nd controlling lock behavior 2nd 3rd exclusive locks granularity shared locks transaction isolation levels 2nd Master 2nd minimum hardware requirements 2nd 3rd 4th Model 2nd moving data BACKUP/RESTORE operations 2nd BCP (Bulk Copy Program) 2nd 3rd 4th DTS Import/Export Wizard 2nd moving data 2nd moving data;XML (Extensible Markup Language) 2nd 3rd msdb 2nd normalization 2nd 3rd definition of 2nd fifth normal form first normal form 2nd fourth normal form second normal form third normal form Northwind object groupings 2nd OLE-DB 2nd operating system service properties 2nd operators packages permissions properties altering 2nd Pubs querying with SELECT arithmetic operators BETWEEN keyword bitwise operators column names, specifying 2nd comparison operators 2nd COMPUTE BY clause COMPUTE clause CUBE keyword 2nd DISTINCT clause EXISTS keyword EXPLICIT clause 2nd FOR XML clause 2nd FROM clause GROUP BY clause 2nd HAVING clause IN keyword INTO clause 2nd LIKE keyword 2nd logical operators 2nd NULL values 2nd OPENXML keyword 2nd 3rd ORDER BY clause 2nd ROLLUP keyword 2nd SET ROWCOUNT clause simple example 2nd 3rd TOP clause 2nd unary operators WHERE clause RAID (redundant array of independent/inexpensive disks) 2nd records definition of referential integrity relationships 2nd 3rd 4th cardinality identifying 2nd many-to-many 2nd 3rd 4th 5th one-to-many 2nd 3rd 4th one-to-one 2nd 3rd replication 2nd 3rd 4th advantages of 2nd articles central Publisher, multiple Subscribers 2nd data distribution 2nd Distributors latency 2nd merge replication 2nd 3rd 4th multiple Publishers, multiple Subscribers 2nd multiple Publishers, single Subscriber publications Publishers single Publisher, single Subscriber 2nd site autonomy 2nd snapshot replication 2nd 3rd 4th Subscribers transactional consistency 2nd transactional replication 2nd 3rd roles definition of rows counting rules security server configuration settings Affinity Mask Allow Updates AWE Enabled C2 Audit Mode Cost Threshold for Parallelism Cursor Threshold Default Full-Text Language Default Language Fill Factor Index Create Memory Lightweight Pooling Locks Max Degree of Parallelism Max Server Memory Max Text Repl Size Max Worker Threads Media Retention Min Memory Per Query Min Server Memory Nested Triggers Network Packet Size Open Objects Priority Boost Query Governor Cost Limit Query Wait Reconfigure 2nd Recovery Interval Remote Access Remote Login Timeout Remote Proc Trans Remote Query Timeout Scan for Startup Process Set Working Set Size Two Digit Year Cutoff User Connections User Options stored procedures 2nd definition of tables 2nd 3rd 4th columns 2nd 3rd 4th cross joins 2nd definition of 2nd FOREIGN KEY constraints 2nd inner joins 2nd outer joins 2nd 3rd PRIMARY KEY constraints 2nd 3rd syscolumns syscomments sysdatabases sysindexes syslogins sysmessages sysobjects sysprocesses sysremotelogins sysservers systypes sysusers unions 2nd 3rd tempdb 2nd triggers 2nd definition of troubleshooting failed object creation 2nd updating user-defined functions definition of users adding definition of very large database applications 2nd views 2nd 3rd 4th 5th 6th advantages of 2nd altering creating 2nd 3rd definition of dropping 2nd indexed views 2nd 3rd partitioned views 2nd 3rd schema binding 2nd 3rd 4th DATALENGTH() function date/time functions DATEADD() 2nd DATEDIFF() 2nd DATENAME() 2nd DATEPART() 2nd GETDATE() DATEADD() function DATEDIFF() function 2nd DATENAME() function 2nd DATEPART() function 2nd datetime data type DB_ID() function DB_NAME() function DBCC (Database Console Command) 2nd 3rd maintenance options 2nd miscellaneous options 2nd trace flags 2nd validation options 2nd DBCC DBREINDEX statement DEALLOCATE statement deallocating cursors DECLARE CURSOR statement 2nd declaring variables decomposing attributes 2nd 3rd Default Full-Text Language option (server properties) Default Language option (server properties) Default Value descriptor (columns) defaults 2nd 3rd 4th defining attributes 2nd 3rd DELETE statement 2nd 3rd deleting triggers deleting data DELETE statement 2nd 3rd denormalization 2nd 3rd 4th 5th dependencies parent-child Description descriptor (columns) design business systems 2nd automation 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th distributed data 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th exam prep questions 2nd 3rd 4th 5th Internet application architecture 2nd one-tier systems 2nd replication 2nd 3rd 4th 5th 6th 7th SQL Server Back Office integration 2nd third-party database interactions 2nd three- or more tier systems 2nd two-tier systems 2nd very large database applications 2nd databases 2nd deterministic functions deviation functions diagrams ERDs (Entity Relationship Diagrams) diagrams (database) 2nd definition of dialog boxes Database Properties 2nd Auto options 2nd Cursor options 2nd Recovery options 2nd SQL options 2nd 3rd State options 2nd 3rd Server Properties Affinity Mask option Allow Updates option AWE Enabled option C2 Audit Mode option Cost Threshold for Parallelism option Cursor Threshold option Default Full-Text Language option Default Language option Fill Factor option Index Create Memory option Lightweight Pooling option Locks option Max Degree of Parallelism option Max Server Memory option Max Text Repl Size option Max Worker Threads option Media Retention option Min Memory Per Query option Min Server Memory option Nested Triggers option Network Packet Size option Open Objects option Priority Boost option Query Governor Cost Limit option Query Wait option Reconfigure option 2nd Recovery Interval option Remote Access option Remote Login Timeout option Remote Proc Trans option Remote Query Timeout option Scan for Startup Process option Set Working Set Size option Two Digit Year Cutoff option User Connections option User Options option DISTINCT clause (SELECT statement) distributed data 2nd linked servers 2nd 3rd 4th OLE-DB 2nd OPENQUERY function OPENROWSET function 2nd 3rd remote servers 2nd distributed partitioned views Distributed Transaction Services (DTS) distribution database Distributors double dash (--) DROP EXISTING clause (CREATE INDEX statement) DROP INDEX statement DROP TRIGGER statement DROP VIEW statement dropping indexes 2nd triggers views 2nd DTS (Data Transformation Services) Import/Export Wizard 2nd DTS (Distributed Transaction Services) durability (transactions) DYNAMIC cursors |