N


Named Pipes, 52, 181

Nested SELECT, 266

.Net, 9, 40, 48, 54

Net Search Extender, 55, 57

NetBios support, 40

Next key share (NS), 480t, 486t, 488t

Next key weak exclusive (NW), 481t, 486t, 488t

NEXT VALUE, 119, 159, 217, 219, 580

Nicknames, 122, 214

aliases vs., 122, 214

authorities and privileges using, GRANT and, 134–135

authorities and privileges using, REVOKE and, 144

privileges available with, 122–123, 122

Node directory, 181

Nodes, 70

cataloging and uncataloging, 186–188

Nonaggregate columns and GROUP BY, 281

Nonrepeatable reads, 468–477, 469t. See also isolation levels

Normalization. See data normalization

NOT DETERMINISTIC, 236

NOT ENFORCED, 407

NOT ENFORCED ENABLE QUERY OPTIMIZATION, 397–398

Not equal to, 272–274. See also comparison operators; relational predicates

NOT FENCED, 237

NOT NULL constraint, 365, 374–375, 375, 384, 407, 419, 420, 423, 425, 426, 457, 601, 604

Notification logs, Journal, 4, 75–76, 76

Novell Enterprise Server, 41, 42

NULL/null values, 260, 263, 264, 279–280, 447, 587, 588, 595–596, 605

DELETE and, 264

INSERT and, 260

UPDATE and, 263

SELECT and, 279–280

NUM, NUMERIC, 198

Numeric data types, 366–368




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