O

Object Linking and Embedding (OLE) stored procedures and, 238

user-defined functions and, 229–230, 330–331

Object name, schemas and, 192, 193, 418

Object privileges, 114–123, 114. See also privileges

Objectives, exam, 17

ODBC. See Open Database Connectivity

OLAP Acceleration, 46

OLAP. See On-Line Transaction Processing

OLE DB, 52, 54

OLE DB external table, 229–230, 330–331

OLTP. See On-Line Transaction Processing

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

On-Line Analytical Processing (OLAP), 35, 39, 45, 46

On-Line Transaction Processing (OLTP), 35, 45, 85–87, 94, 436, 571

Online Reorganization, 38–39, 43

Online tutorials, 16

OPEN, cursors and, 322

Open Database Connectivity (ODBC), 8, 9, 47, 52, 54

Configuration Assistant in, 77–78, 78

isolation levels and, 476

OPEN statement, 317–319

Operands, 70

Operators, 70

Optimization, 51, 79

ENABLE QUERY OPTIMIZATION and, 407

informational constraints and, 374, 397–398, 398, 605

Optimizer, 569, 570, 605

Oracle, 38, 121

ORDER BY, 79, 210, 227, 268, 271, 285–287, 358, 592, 595, 596

indexes and, 210

user-defined data types and, 227

OS/2, 36

OS/390, 8

authentication and, 102

Database Connection Services (DCS) directory in, 181–182, 181

Outer joins, 298, 301–306, 354, 357, 588, 591, 592, 595

full, 301, 303, 303, 305

left, 301, 302, 302, 305

right, 301, 303, 303, 305

syntax of SELECT statement in, 304