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] C2 Administrator;s and User's Security Guide C2 Audit Mode option (server properties) C2 security audits 2nd caching data cache procedure cache query execution plans 2nd cardinality of relationships cascade action 2nd cascading referential integrity CASE statement 2nd 3rd CAST() function 2nd 3rd casting data types 2nd catalogs, Full-Text 2nd CEILING() function central Publisher, multiple Subscribers replication 2nd changing database owner char data type CHAR() function character data types 2nd character functions 2nd 3rd characteristic entities CHECK constraints 2nd checks and balances CHECK constraints 2nd COLUMN CHECK constraints 2nd TABLE CHECK constraints checksum operations 2nd CHECKSUM() function CHECKSUM_AGG() function CHECKSUM_BINARY() function Chen, Peter CISA exam self-assessment educational background exam readiness 2nd hands-on experience ideal Certified Information Systems Auditor candidate Client Network clients thick thin CLOSE statement closing cursors clustered indexes 2nd 3rd 4th COL_LENGTH() function COL_NAME() function COLLATE clause (CREATE DATABASE statement) Collation descriptor (columns) collation sequences 2nd collations COLUMN CHECK constraints 2nd Column Name descriptor (columns) columns 2nd column descriptors 2nd commands DBCC (Database Console Command) 2nd 3rd maintenance options 2nd miscellaneous options 2nd trace flags 2nd validation options 2nd comments 2nd COMMIT TRANSACTION statement COMMIT WORK statement comparison operators 2nd COMPUTE BY clause (SELECT statement) COMPUTE clause (SELECT statement) CONCAT_NULL_YIELDS_NULL option (databases) concurrency 2nd 3rd 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 conditional statements BREAK 2nd CASE 2nd 3rd IF...ELSE 2nd configuration database 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 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 consistency transactional 2nd consistency (transactions) constraints 2nd CHECK 2nd COLUMN CHECK definition of FOREIGN KEY 2nd PRIMARY KEY 2nd 3rd TABLE CHECK contention (locks) 2nd CONTINUE statement convergence CONVERT() function 2nd converting data types 2nd copying BCP (Bulk Copy Program) 2nd 3rd 4th Cost Threshold for Parallelism option (server properties) COUNT() function COUNT_BIG() function covering indexes 2nd CREATE DATABASE statement 2nd 3rd 4th COLLATE clause FILEGROWTH clause MAXSIZE clause 2nd CREATE FUNCTION statement 2nd CREATE INDEX statement 2nd 3rd CREATE PROCEDURE statement 2nd 3rd CREATE TRIGGER statement 2nd CREATE VIEW statement 2nd cross joins 2nd CUBE keyword (SELECT statement) 2nd Current Activity view 2nd 3rd 4th 5th 6th cursor data type Cursor Threshold option (server properties) CURSOR_CLOSE_ON_COMMIT option (databases) CURSOR_DEFAULT GLOBAL option (databases) CURSOR_DEFAULT LOCAL option (databases) cursors 2nd 3rd 4th 5th 6th closing creating 2nd deallocating DYNAMIC FAST_FORWARD fetching rows from FORWARD_ONLY GLOBAL KEYSET LOCAL OPTIMISTIC options CURSOR_CLOSE_ON_COMMIT CURSOR_DEFAULT GLOBAL CURSOR_DEFAULT LOCAL READ_ONLY SCROLL_LOCKS scrolling STATIC TYPE_WARNING updating 2nd |