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]

ACCESS system privileges

accessing     data dictionary 2nd 3rd 4th 5th 6th 7th 8th account locking 2ndaccounts     expired 2nd

     locked 2nd

    user accounts         defaults 2nd 3rd 4th 5th 6th 7thadding

     columns (tables) 2nd     data files 2nd 3rd     redo log groups

Administration Functions system privileges

Administration Guide

Administrator's Guide

aging of passwords 2nd 3rd Alapati, Sam R., Expert Oracle 9i Database Administration 2nd

alert log 2nd 3rd

alertSID.log file 2nd 3rdallocating     extents 2nd 3rd ALTER DATABASE command 2nd 3rd 4th 5th

ALTER object privilege

ALTER PROFILE command 2nd

ALTER SESSION command

ALTER SESSION SET CONSTRAINTS command

ALTER SYSTEM command 2nd 3rd

ALTER TABLE commmand 2nd 3rd

ALTER TABLESPACE command 2nd

ALTER USER command

altering

     columns (tables) 2nd

     database state 2nd

     profiles 2nd

     tables 2nd 3rd

     tablespaces 2nd

     undo tablespaces 2nd

altering users 2nd 3rdanswers     practice exam 1 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th 15th

     practice exam 2 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th

application roles AQ_ADMINISTRATOR_ROLE

AQ_USER_ROLE

ARC (Archiver) processes 2ndarchitecture

     Optimal Flexible Architecture (OFA) 2nd 3rd 4th 5th 6th ARCHIVELOG mode 2nd

Archiver (ARC) processes 2ndarchiving     redo log files 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th ARCn (Archiver) background processarrays

     varying arrays 2nd

assessing your readiness for the exam 2ndassigning     profiles 2nd

     users to consumer groups 2nd ASSM (automatic segment space management) 2nd 3rd AUDIT command 2nd

AUDIT_TRAIL initialization parameter

auditing

    audit trail

         errors 2nd         locations 2nd

     categories of 2nd

     data dictionary 2nd 3rd     data generation     disabling 2nd 3rd     enabling 2nd 3rd

     fine-grained auditing 2nd

     guidelines 2nd 3rd 4th

     options 2nd 3rd 4th 5th

     privileges

     reviewing audit information 2nd

     statement execution 2nd

     SYSTEM tablespace 2nd 3rd

     uses 2nd

authentication

     database authentication 2nd 3rd 4th 5th

     external authentication 2nd 3rd 4th 5th 6th 7th

AUTOEXTEND 2nd 3rd

automatic consumer group switching 2nd

automatic segment space management (ASSM) 2nd 3rd

automatic undo management

automation     database startup 2nd