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]

T-SQL [See Transact SQL]

T-SQL (Transact-SQL)

     functions

TABLE CHECK constraints

table data type

table hints 2nd 3rd

tables 2nd 3rd 4th

     columns 2nd

         column descriptors 2nd

     cross joins 2nd

     definition of 2nd

     FOREIGN KEY constraints 2nd

     inner joins 2nd

     outer joins 2nd 3rd

     PRIMARY KEY constraints 2nd 3rd

    rows

         counting

     syscolumns

     syscomments

     sysdatabases

     sysindexes

     syslogins

     sysmessages

     sysobjects

     sysprocesses

     sysremotelogins 2nd

     systypes

     sysusers

     unions 2nd 3rd

TABLOCK hint

TABLOCKX hint

tempdb database 2nd

templates

     SQL Profiler

tests [See 70-229 exam]

text

     spaces, trimming

     string functions 2nd 3rd

text data type

thick clients

thin clients

third normal form

third-party database interactions 2nd

three- or more tier systems 2nd

time/date functions

     DATEADD() 2nd

     DATEDIFF() 2nd

     DATENAME() 2nd

     DATEPART() 2nd

     GETDATE()

timestamp data type

tinyint data type

tools 2nd 3rd 4th

     Analysis Services

     BCP (Bulk Copy Program)

     Books Online 2nd

     Client Network

     English Query

     OSQL (ODBC Structured Query Language)

     Profiler

     Query Analyzer 2nd 3rd

     Server Network

     Service Manager 2nd

TOP clause (SELECT statement) 2nd

top rows, returning 2nd

TORN_PAGE_DETECTION option (databases)

traces

     defining 2nd

     diagnosing locking with 2nd 3rd

     playback and diagnosis 2nd

Transact SQL 2nd [See also functions] [See also stored procedures]

     ALTER DATABASE statement 2nd

     ALTER TRIGGER statement 2nd

     ALTER VIEW statement

    BACKUP statement

         moving data with 2nd

     BEGIN TRANSACTION statement 2nd 3rd

     BEGIN...END statement 2nd

     BREAK statement

     BULK INSERT statement

     CASE statement 2nd 3rd

     CLOSE statement

     comments 2nd

     COMMIT TRANSACTION statement

     COMMIT WORK statement

     CONTINUE statement

     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

     cursors 2nd 3rd 4th 5th 6th

         closing

         creating 2nd

         deallocating

         DYNAMIC

         FAST_FORWARD

         fetching rows from

         FORWARD_ONLY

         GLOBAL

         KEYSET

         LOCAL

         OPTIMISTIC

         READ_ONLY

         SCROLL_LOCKS

         scrolling

         STATIC

         TYPE_WARNING

         updating 2nd

    data types

         casting

         converting

     DBCC DBREINDEX statement

     DEALLOCATE statement

     DECLARE CURSOR statement 2nd

     DELETE statement 2nd 3rd

     DROP INDEX statement

     DROP TRIGGER statement

     DROP VIEW statement

     EXECUTE statement

     FETCH NEXT statement

     GRANT statement 2nd 3rd

     IF...ELSE statement 2nd

     INNER JOIN statement 2nd

     INSERT statement 2nd 3rd

     loops 2nd 3rd

     OPEN statement

     OUTER JOIN statement 2nd 3rd

    RESTORE statement

         moving data with 2nd

     REVOKE statement 2nd

     ROLLBACK TRANSACTION statement 2nd

    scripts

         batches 2nd 3rd 4th 5th

         definition of

     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

     SET IMPLICIT_TRANSACTIONS statement

     triggers 2nd 3rd 4th

         AFTER 2nd

         altering

         creating 2nd

         dropping

         firing order 2nd 3rd

         guidelines for use 2nd

         INSTEAD OF 2nd 3rd 4th

         renaming

     TRUNCATE TABLE statement

     UNION statement 2nd 3rd

     UPDATE statement

    variables

         assigning values to 2nd

         declaring

         definition of

         global variables 2nd

         scope

    VIEW statement

         WITH ENCRYPTION clause

Transact-SQL) [See T-SQL]

transactional replication 2nd 3rd

transactions 2nd 3rd

     atomicity

     beginning 2nd

     consistency 2nd 3rd

     durability

     isolation

     isolation levels 2nd

     rolling back 2nd

triggers 2nd 3rd 4th 5th 6th 7th 8th

     AFTER 2nd 3rd

     altering

     creating 2nd

     definition of

     dropping

     firing order 2nd 3rd

     guidelines for use 2nd

     INSTEAD OF 2nd 3rd 4th 5th

     renaming

troubleshooting

     failed object creation 2nd

    security issues

         broken ownership chains 2nd 3rd

         SQL Profiler 2nd

TRUNCATE TABLE statement

tuning [See performance tuning]

Two Digit Year Cutoff option (server properties)

two-tier systems 2nd

TYPE_WARNING cursors

types [See data types]