Range partitioning, 413. See also tables, partitioned
Rational Data Architect (RDA), 45
RDO, 54
Read Stability isolation level, 468, 469t, 471, 472, 476, 497, 501, 610, 611, 613
Read-only cursors, 314–315
REAL, 199, 367–368
Real-Time Insight feature, 45
REBIND utility, 4
Records, 248, 253
tables and, 196
RECOVER, 7
Recovery, 4, 11, 50, 107, 108, 109
RECP, 6
Recursion, SELECT and, 289
Red Hat Enterprise Linux (RHEL), 41, 42
RedBooks, IBM, 16
REFERENCES, 116–117, 123, 129, 134, 139, 144, 156, 158, 574, 575, 576, 577, 578
Referential cycle, 385t
Referential integrity constraints, 365, 374, 381–397, 381, 405–408, 409–410, 449, 456, 459, 602, 606
CHECK constraints vs., 384
cycle of, 385t
data normalization and, 381
DELETE and, 385, 392–397, 393, 394, 395, 396, 458
Delete Rule for, 392–397, 393, 394, 395, 396, 458
dependents or children in, 384t
descendents in, 385t
foreign key and, 381, 382, 459
foreign key constraints and, 381
INSERT and, 385, 386–389, 387, 388, 456
Insert Rule for, 386–389, 387, 388, 456
keys used with, 384–385t
NOT NULL constraints vs., 384
ON DELETE CASCADE, 392–397, 458, 603, 604, 607
ON DELETE NO ACTION, 392–397, 396, 604, 607
ON DELETE RESTRICT, 392–397, 395, 458, 603, 604
ON DELETE SET NULL, 392–397, 394, 458, 604
ON UPDATE NO ACTION, 389–391, 391
ON UPDATE RESTRICT, 389–391, 390
parent and child tables in, 382, 384t, 459
parent key and, 382, 384t
primary key and, 384t
self-referencing tables, rows and, 385t
terminology of, 384–385t
UNIQUE constraints vs., 384
unique key and, 384t, 384
UPDATE and, 385, 389–391, 390, 391
Update Rule for, 389–391, 390, 391
uses for, 385
Relational database, 13
Relational predicates, SELECT and, 272–274, 272
RELEASE SAVEPOINT, 327–328, 329
REORG table reorganization, 4, 7, 438, 570
REORGCHK utility, 4
REPAIR utility, 7
Repeatable Read isolation level, 468, 469t, 469–470, 470, 476, 495, 501, 610, 613
Replication, 11
Replication Center, 64, 65, 568
Replication Data Capture, 40
Restore, 4, 11
RESTP, 6
RESTRICT clause, 142
Result set, 265. See also SELECT
Result tables, 197
Results, 587
Retesting for certification, 34
RETURN, 70
Reverse engineering, 13, 45–46
Reviewing items, in IBM Certification exam, 27–30, 28, 30
REVOKE, 137–146, 154, 159, 257, 578, 579
ALL PRIVILEGES clause and, 139, 144
BY ALL clause in, 138
database-level authorities and privileges using, 137
examples of, 145–146
EXECUTE and, 160
index, authorities and privileges using, 140–141
nickname, authorities and privileges using, 144
package, authorities and privileges using, 143
PUBLIC and, 145
requirements for use of, 146, 147t
RESTRICT clause and, 142
routine, authorities and privileges using, 131–133
schema, authorities and privileges using, 138–139
SELECT and, 145
sequence, authorities and privileges using, 141
table, authorities and privileges using, 139
table space, authorities and privileges using, 138
view, authorities and privileges using, 140
Right outer joins, 301, 303, 303, 305, 595
Roll-forward, 4, 11, 107, 108
Roll-in/roll-out, partitioned tables, 416
ROLLBACK, 361, 362, 597
savepoints and, 236, 326–329, 362, 597
transactions and, 322–326, 324, 325
ROLLBACK TO SAVEPOINT, 329
Routines, 251, 586
authorities and privileges using, GRANT and, 131–133
authorities and privileges using, REVOKE and, 131–133
privileges available with, 119–120, 120
Rows, 203. See also tables
locks and, 483
tables and, 196
triggers and, 439
RUNSTATS, 4, 7, 107, 109, 112
Runtime Client, 51–53, 52