P

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 11th
parameters
     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 parameter
passwords
     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 2nd
processes
    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