Index_R

R

range partitioning, 252

read consistency, 151

Recovery Manager (RMAN), 284–285, 285

redo log buffer, 163, 164

redo log files, 161, 162

referential integrity, 6

relational databases

basics of, 3–4

data modeling, 6–9

primary keys, datatypes and foreign keys, 5–6

tables, rows and columns, 4

relational tables, 202–203

relations, defined, 4

relationships, defined, 4

RENAME statement, 38–39

reporting techniques, 179–199

formatting, 184–192

basics of, 184–185

BREAK processing, 189–191

column formatting, 188–189

headers and footers, 185–188

totals, 191–192

iSQL*Plus configuration, 180–184, 180

Change Password, 184

interface options, 180–181, 181

system variables, 182–184, 182

scripts, 195–198, 196–197

substitution variables, 192–195, 193–194

resource contention, and Oracle’s Tuning Methodology, 242

resource parameters, 225

reverse key indexes, 245

review questions and answers

advanced SQL queries, 138–139, 307–308

backups, 286–287, 312–313

data, restricting, sorting and grouping, 92–93, 306

database basics, 11, 304

database creation, 177, 309

database functions, 68–69, 305–306

database objects, 220–221, 310–311

joins, 116–117

logical consistency, 155, 308

multiple tables, using, 116–117, 307

performance optimizing, 264–265, 312

reporting, 198–199, 309–310

SQL*Plus and iSQL*Plus, 42–43, 304–305

troubleshooting, 302, 313

users and security, 238–239, 311

REVOKE statement

DCL and, 41

privileges and, 230

right outer joins, 110

RMAN (Recovery Manager), 284–285, 285

roles

creating and assigning, 232–234, 232

defined, 40, 232

ROLLBACK statements, 153–154

ROLLUP operator, 134–136

ROWIDs, 244–245

rows

DELETE statement and, 33, 33

INSERT statement and, 32–33

relational databases and, 4

removing duplicate, 27–28

subqueries and

multiple-row subqueries, 121–123

single-row subqueries, 120–121

TRUNCATE statement and, 39

UPDATE statement and, 30–31, 30–31

rule-based optimizer, 258–259