Oracle 9i Fundamentals I Exam Cram 2

Index

[A] [B] [C] [D] [E] [F] [G] [H] [I] [J] [K] [L] [M] [N] [O] [P] [Q] [R] [S] [T] [U] [V] [W]

range partitioning 2nd 3rd

read consistency (transactions) 2nd 3rd 4th 5th 6th read-only mode 2nd 3rd 4th read-only tablespaces 2nd 3rd 4th 5threbuilding     indexes 2nd 3rd 4th 5th 6th

RECO (Recoverer) processes 2nd

RECOVER_CATALOG_OWNER role Recoverer (RECO) processes 2ndrecovering

     transactions 2ndrecovery     redo log files

Recovery Manager (RMAN)

redefining

     tables 2nd 3rd 4th 5th 6th 7th

redo log buffer 2ndredo log files

     adding groups

     archiving 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th     checkpoints 2nd 3rd 4th     clearing 2nd 3rd 4th     configuration

     creating 2nd

     data dictionary 2nd 3rd

     defined 2nd 3rd 4th

     disk location 2nd

     dropping groups 2nd 3rd 4th 5th

     groups 2nd 3rd 4th

     log switches 2nd 3rd

     maintaining 2nd

     maximum number of groups

     multiplexing 2nd 3rd 4th 5th 6th

     optimum number of 2nd

     purpose of 2nd

     recovery

     relocating 2nd 3rd

     renaming 2nd 3rd

     resizing 2nd 3rd 4th     sequence numbers     sizing 2nd 3rd

Reference Guide

references [See resources] REFERENCES object privilege

REFs (relationship data types) 2nd

regular tables 2nd relational tables

relationship data types (REFs) 2ndrelocating

     redo log files 2nd 3rdremoving     roles 2ndrenaming     redo log files 2nd 3rd

reorganizing

     tablesresizing     redo log files 2nd 3rd 4th

     tablespaces 2nd 3rd resource allocation methods resource consumer groups 2nd 3rd 4th 5th 6th 7th 8th

resource limits 2nd 3rd 4th 5th 6th 7th 8th

Resource Manager 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th 15th 16th 17th 18th 19th 20th 21st 22nd

resource plan directives 2nd

resource plans 2nd 3rd 4th RESOURCE role

resources

     Administration Guide     Administrator's Guide     Enterprise Manager Administrator's Guide     Enterprise Manager Concepts Guide

     Expert Oracle 9i Database Administration 2nd

     Oracle 9i Administration Manual

     Oracle 9i Administrator's Guide

     Oracle 9i Administrator's Manual

     Oracle 9i Concepts Manual

     Oracle 9i Concepts Manuals

     Oracle 9i Database Administrator's Guide

     Oracle 9i Database Concepts Manual 2nd 3rd

     Oracle 9i Database Concepts Manuals 2nd

     Oracle 9i DBA 101, Marlene Theriault, Rachel Carmichael, and James Viscusi

     Oracle 9i Globalization Support Manual

     Oracle 9i Parallel Server Concepts

     Oracle 9i Reference

     Oracle 9i SQL Reference 2nd 3rd

     Oracle Data Dictionary Pocket Reference

     Reference Guide     SQL*Plus User's Guide and Reference response files

restricted mode 2nd 3rd 4th

restricted ROWIDs 2nd 3rd reusable sections of control files 2nd

REVOKE command 2nd

RMAN (Recovery Manager)roles

     application roles     AQ_ADMINISTRATOR_ROLE

     AQ_USER_ROLE     characteristics 2nd     CONNECT     creating 2nd 3rd 4th 5th     data dictionary 2nd 3rd

     DBA

     default roles 2nd 3rd 4th     defined     DELETE CATALOG ROLE

     disabling 2nd 3rd 4th 5th 6th 7th     dropping     enabling 2nd 3rd 4th 5th 6th 7th

     EXECUTE CATALOG ROLE

     EXP FULL DATABASE

     granting 2nd 3rd 4th

     HS_ADMIN_ROLE     identification

     IMP FULL DATABASE

     maximum number of enabled roles     naming 2nd     passwords 2nd     predefined roles 2nd 3rd 4th 5th 6th

    privileges

         associations

         column privileges

         comparison

         granting

         object privileges 2nd

         system privileges 2nd

         turning on/off

     RECOVER_CATALOG_OWNER

     removing 2nd

     RESOURCE

     SELECT_CATALOG_ROLE

     SNMPAGENT

    SYSDBA

         privileges 2nd 3rd 4th

    SYSOPER         privileges 2nd rollback segments 3rd [See manual undo management mode]

rollbacks [See undos]

ROWID data type 2nd 3rd ROWIDs 2nd 3rd 4th 5th 6th 7th

rows (tables)

     structure 2nd 3rd