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]

D (Dispatcher) processes 2nd

data block size     default 2nddata blocks     block header     characteristics 2nd 3rd

     data space

     DB_BLOCK_SIZE initialization parameter 2nd 3rd     defined     disk blocks

     extents 2nd 3rd 4th     free space 2nd     header 2nd

     layout 2nd 3rd 4th 5th

     row data

    segments

         bootstrap segments         cache segments

         data segments

         defined         index segments         LOBnn segments         rollback segments 2nd

         table segments

         temporary segments

     size 2nd 3rd 4th 5th 6th 7th 8th 9th 10th

     space usage 2nd

data dictionary

     accessing 2nd 3rd 4th 5th 6th 7th 8th

     auditing 2nd 3rd

     catalog scripts 2nd 3rd 4th 5th

     constraints 2nd

     contents 2nd

     control files 2nd 3rd 4th

     creating 2nd 3rd 4th 5th

     globalization support 2nd

     indexes 2nd

     profiles 2nd

     program units     public synonyms 2nd     redo log files 2nd 3rd

     roles 2nd 3rd

     stored procedures     tables 2nd 3rd 4th

     tablespaces 2nd 3rd

     undo segments 2nd 3rd 4th     user information 2nd

     uses 2nd 3rd 4th     views 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th 15th 16th 17th 18th 19th 20th

data dictionary cache 2nddata files     adding 2nd 3rd     AUTOEXTEND 2nd 3rd     characteristics 2nd

     moving 2nd 3rd 4th 5th 6th

data integrity     constraints 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 35th 36th 37th 38th 39th 40th 41st 42nd 43rd     defined 2nd

     triggers 2nd data segmentsdata storage

    tables

         cluster tables 2nd 3rd

         index-organized tables 2nd

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

data types

     collection data 2nd 3rd 4th 5th     relationship data types 2nd     scalar data 2nd 3rd 4th 5th 6th 7th 8th 9th     user-defined

database authentication 2nd 3rd 4th 5th

database buffer cache 2nd

database character sets 2nd 3rd 4th 5th 6th 7th

Database Configuration Assistant (DBCA) 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th 15th 16th 17th 18th

database startup

     automation 2nd

     OEM interface 2nd

     STARTUP command 2nd 3rd 4th 5th

     STARTUP MOUNT command 2nd

     STARTUP NOMOUNT command 2nd 3rd

     STARTUP OPEN command 2nd

Database Writer (DBW) processes 2nd 3rd

databases

     backups

     control files 2nd

    creating         custom databases         Database Configuration Assistant (DBCA) 2nd 3rd 4th 5th 6th 7th 8th 9th 10th

         disk space

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

         operating system environment configuration 2nd 3rd 4th

         requirements 2nd         typical databases

     defined     deleting

     down    extents         segments         used extents     file locations 2nd 3rd

    instances

         connections 2nd 3rd 4th         defined    parameters

         archive         required     read-only mode 2nd 3rd 4th

     redo log files 2nd 3rd

     relationship between structures

     relationships 2nd 3rd

     restricted mode 2nd 3rd 4th     shutting down 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th 15th

     states 2nd

    tablespaces         defined         system 2nd         temporary

         undo 2nd

     up

datafiles

     creating

     defined

DB_BLOCK_BUFFERS initialization parameter

DB_BLOCK_SIZE initialization parameter 2nd 3rd 4th

DB_CREATE_FILE_DEST initialization parameter

DB_CREATE_ONLINE_LOG_DEST initialization parameter

DB_NAME initialization parameter

DBA role

DBA_AUDIT_EXISTS view

DBA_AUDIT_OBJECTS view

DBA_CONSTRAINTS view

DBA_DATA FILES view 2nd

DBA_DATA_FILES view DBA_EXTENTS view 2nd 3rd 4th DBA_FREE SPACE view 2nd 3rd 4th

DBA_FREE_SPACE view

DBA_INDEXES view DBA_LOBS view

DBA_OBJECTS view

DBA_ROLES view DBA_ROLLBACK_SEGS view

DBA_SEGMENTS view 2nd 3rd 4th DBA_SYS_PRIVS view

DBA_TABLES view DBA_TABLESPACE view DBA_TABLESPACES view DBA_USERS view DBCA (Database Configuration Assistant) 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th 15th 16th 17th 18th

DBCA (Oracle Database Configuration Assistant)

DBW (Database Writer) processes 2nd 3rd dedicated server architecture 2nd dedicated server processes

default passwords 2nd 3rd 4th 5th DEFAULT profile 2nd default roles 2nd 3rd 4th

default temporary tablespaces 2nd 3rd 4th 5th

defaults

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

deferred constraints 2nd 3rd deferred undo segments 2nd

defining

     constraints 2nd 3rd DELETE CATALOG ROLE DELETE object privilegedeleting

     databases

diagnostic files

     alert log 2nd 3rd

     background trace files 2nd

     user trace files 2nd 3rd

DICT_COLUMNS view

dictionary managed tablespaces 2nd 3rd

DICTIONARY view

directory structures

     Optimal Flexible Architecture (OFA) 2nd 3rd

disabled constraints 2nd 3rd

disabling

     auditing 2nd

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

disk blocks

Dispatcher (D) processes 2nd DROP PROFILE command 2nd DROP ROLE command

DROP TABLE command 2nd 3rd

DROP TABLESPACE command 2nd 3rd 4th 5th 6th DROP USER command

dropping

     columns (tables) 2nd 3rd 4th     control files 2nd 3rd

     indexes 2nd     profiles 2nd

     redo log groups 2nd 3rd 4th 5th     roles     tables 2nd 3rd     tablespaces 2nd 3rd 4th 5th 6th 7th     undo tablespaces 2nd 3rd

     users