R


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




DB2 9 Fundamentals Certification Study Guide
DB2 9 Fundamentals: Certification Study Guide
ISBN: 1583470727
EAN: 2147483647
Year: 2007
Pages: 93

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net