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]

parameter files

     PFILE 2nd 3rd 4th 5th 6th 7th     SPFILE 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11thparameters     archive     BACKGROUND_DUMP_DEST

     COMPATIBLE

     CONTROL FILES     control files 2nd     CONTROL_FILE_RECORD_KEEP_TIME

     DB CREATE FILE DEST     DB_BLOCK_BUFFERS     DB_BLOCK_SIZE

     DB_CREATE_ONLINE_LOG_DEST

     DB_NAME

     explicit

     FAILED_LOGIN_ATTEMPTS     IFILE

     implicit

     INITRANS 2nd     LOG BUFFER     MAX_DUMP_FILE_SIZE     MAXTRANS 2nd

     NLS_COMP

     NLS_LANGUAGE 2nd

     NLS_TERRITORY 2nd 3rd 4th

     PASSWORD_GRACE_TIME

     PASSWORD_LIFE_TIME

     PASSWORD_REUSE_MAX

     PASSWORD_REUSE_TIME 2nd

     PASSWORD_VERIFY_FUNCTION

     PCTFREE 2nd

     PCTUSED 2nd 3rd

     PROCESSES

     required

     SHARED POOL SIZE

     SQL TRACE

     TIMED STATISTICS

     UNDO MANAGEMENT 2nd 3rd     UNDO TABLESPACE 2nd 3rd 4th 5th     UNDO_RETENTION 2nd 3rd

     USER DUMP DEST

partitioned indexes partitioned tables 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th

Password File Utility

password files 2nd 3rd 4th 5th PASSWORD_GRACE_TIME parameter

PASSWORD_LIFE_TIME parameter PASSWORD_LOCK_TIME parameter

PASSWORD_REUSE_MAX parameter PASSWORD_REUSE_TIME parameter 2nd PASSWORD_VERIFY_FUNCTION parameterpasswords     account locking 2nd

     aging 2nd 3rd

     complexity verification 2nd 3rd 4th     default passwords 2nd 3rd 4th 5th     encoding

     expiration 2nd 3rd     history 2nd     orapwd utility 2nd 3rd 4th

     PASSWORD_LOCK_TIME

     roles 2nd

     setting password limits 2nd 3rd 4th 5th

PCTFREE block utilization parameter 2nd PCTUSED block utilization parameter 2nd 3rd

pending areas 2nd

performance     Unicode character set 2nd 3rd persistent parameter files 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th PFILE 2nd 3rd 4th 5th 6th 7th 8th 9th 10th

PGA (Program Global Area)

     defined 2nd

     private SQL area 2nd

     SQL work areas 2nd

physical classification indexes 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th

PMON (Process Monitor) processes 2nd

practice exam 1

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

     questions 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th 15th 16th 17th 18th 19th 20th 21st 22nd 23rd 24th 25th 26th 27th 28th 29th 30th 31st 32nd 33rd 34th

practice exam 2

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

     questions 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th 15th 16th 17th 18th 19th 20th 21st 22nd 23rd 24th 25th 26th

predefined roles 2nd 3rd 4th 5th 6th

preparing for the exam

     MeasureUp practice test engine 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th

Primary key constraint Primary key constraints 2nd 3rd private SQL area 2nd

PRIVATE_SGA resource limit

privileges     associating with roles

     auditing

     column privileges     comparison with roles

     CREATE TABLE privileges 2nd     defined

     granting     object privileges 2nd 3rd 4th 5th 6th 7th 8th 9th 10th     SYSDBA role 2nd 3rd 4th     SYSOPER role 2nd     system privileges 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th 15th 16th 17th

     turning on/off

Process Monitor (PMON) processes 2ndprocesses    background processes

         Archiver 2nd         Checkpoint 2nd 3rd 4th         Database Writer 2nd 3rd

         defined

         Dispatcher 2nd

         Job Queue 2nd 3rd

         Lock Manager Server         Log Writer 2nd

         Process Monitor 2nd

         Queue Monitor         Recoverer 2nd         System Monitor 2nd     dedicated server

     defined

     Oracle

     server

     shared server

     user

PROCESSES initialization parameter

profiles

     altering 2nd

     assigning 2nd

     characteristics 2nd

     creating 2nd 3rd 4th 5th 6th

     data dictionary 2nd

     DEFAULT profile 2nd

     defined

     dropping 2nd

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

Program Global Area (PGA)

     defined 2nd     private SQL area 2nd

     SQL work areas 2nd

program units     data dictionary

public synonyms 2nd