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]

RAID (redundant array of independent/inexpensive disks) 2nd

RAND() function

Read Committed isolation level

Read Uncommitted isolation level

READ_ONLY cursors

READ_ONLY option (databases)

READ_WRITE option (databases)

READCOMMITTED hint

readiness for CISA exam 2nd

reading

     query execution plans 2nd 3rd 4th 5th

READPAST hint

READUNCOMMITTED hint

rebuilding

     indexes 2nd 3rd 4th

recompiling

     stored procedures 2nd

Reconfigure option (server properties) 2nd

records

     definition of

recovery

    database options

         RECOVERY BULK_LOGGED

         RECOVERY FULL

         RECOVERY SIMPLE

         TORN_PAGE_DETECTION

RECOVERY BULK_LOGGED option (databases)

RECOVERY FULL option (databases)

Recovery Interval option (server properties)

RECOVERY SIMPLE option (databases)

RECURSIVE_TRIGGERS option (databases)

redundant array of independent/inexpensive disks (RAID) 2nd

referential integrity

relational databases [See databases]

relationships 2nd 3rd 4th

     cardinality

     definition of

     identifying 2nd

     many-to-many 2nd 3rd 4th 5th

     one-to-many 2nd 3rd 4th

     one-to-one 2nd 3rd

Remote Access option (server properties)

Remote Login Timeout option (server properties)

Remote Proc Trans option (server properties)

Remote Query Timeout option (server properties)

remote servers 2nd 3rd

renaming

     triggers

Repeatable Read isolation level

REPEATABLEREAD hint

REPLICATE() function

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

RESTORE statement

     moving data with 2nd

RESTRICTED_USER option (databases)

resultsets

REVERSE() function

REVOKE statement 2nd

revoking

     object permissions 2nd

roles

     definition of

     server roles

roles (security)

     application roles 2nd

     creating 2nd

     definition of 2nd

     fixed roles

     viewing list of

     viewing permissions for

ROLLBACK TRANSACTION statement 2nd

rolling back transactions 2nd

ROLLUP keyword (SELECT statement) 2nd

ROUND() function

ROWLOCK hint

rows

     counting

RTRIM() function

rules