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]

cache segments

Carmichael, Rachel, Oracle 91 DBA 101 catalog scripts 2nd 3rd 4th 5thCD     installing 2nd 3rd 4th 5th 6th 7th 8th     MeasureUp practice test engine 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th

     system requirements 2nd

     techical support 2nd     technical supportcertification

     career goals     educational background 2nd 3rd 4th 5th     expectations

     hands-on experience 2nd 3rd 4th 5th

     ideal candidate 2nd 3rd 4th

     job market 2nd

     Oracle training and certification page character set scanner 2nd 3rd

character sets

     converting 2nd 3rd     database 2nd 3rd 4th 5th 6th 7th     encoding schemes 2nd     fixed-width multibyte 2nd

     national 2nd 3rd 4th 5th

     single-byte 2nd

     Unicode 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th

     varying-width multibyte 2nd 3rd

     viewing character set information

Check constraint

checking constraints 2nd 3rd

Checkpoint (CKPT) processes 2nd 3rd 4th

checkpoints

     redo log files 2nd 3rd 4th

CKPT (Checkpoint) processes 2nd 3rd 4th

CKPT background process

clearing

     redo log files 2nd 3rd 4th

cluster segments 2nd

cluster tables 2nd 3rd coalescing indexes 2nd collection data 2nd 3rd 4th 5th

column privileges

columns (tables)     adding 2nd

     altering 2nd

     dropping 2nd 3rd 4th     inserting 2nd

     unused columns 2nd 3rdcommand

     CREATE PROFILEcommands     ALTER DATABASE 2nd 3rd 4th 5th     ALTER PROFILE 2nd     ALTER SESSION

     ALTER SYSTEM 2nd 3rd

     ALTER TABLE 2nd 3rd     ALTER TABLESPACE 2nd     ALTER USER

     AUDIT 2nd     CREATE CONTROLFILE 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th 15th 16th 17th     CREATE DATABASE 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th

     CREATE ROLE 2nd 3rd

     CREATE SPFILE 2nd

     CREATE TABLE 2nd 3rd 4th 5th 6th 7th

     CREATE TABLESPACE 2nd 3rd 4th     CREATE USER

     DROP PROFILE 2nd

     DROP ROLE     DROP TABLE 2nd 3rd     DROP TABLESPACE 2nd 3rd 4th 5th 6th     DROP USER

     NOAUDIT 2nd

     REVOKE 2nd

     SET ROLE 2nd 3rd

     SHUTDOWN ABORT 2nd

     SHUTDOWN IMMEDIATE 2nd 3rd

     SHUTDOWN NORMAL 2nd 3rd

     SHUTDOWN TRANSACTIONAL 2nd 3rd

     STARTUP 2nd 3rd 4th 5th

     STARTUP MOUNT 2nd

     STARTUP NOMOUNT 2nd 3rd

     STARTUP OPEN 2nd

     TRUNCATE

COMPATIBLE initialization parameter

complexity verification of passwords 2nd 3rd 4th

composite partitioning 2nd

COMPOSITE_LIMIT resource limit CONNECT role CONNECT_TIME resource limit

connections

     instances 2nd 3rd 4thconstraints

     advantages

     Check     checking 2nd 3rd

     data dictionary 2nd     deferred 2nd 3rd

     defined 2nd     defining 2nd 3rd     EXCEPTIONS table 2nd 3rd     Foreign key 2nd 3rd 4th 5th 6th 7th 8th 9th     guidelines for using 2nd 3rd

     nondeferred

     Not NULL     Primary key 2nd 3rd 4th     setting

     states 2nd 3rd     table 2nd 3rd 4th 5th 6th 7th 8th 9th     Unique

consumer groups 2nd 3rd 4th 5th 6th 7th 8th

control

     defined 2nd

control files     backups 2nd 3rd

     contents 2nd 3rd 4th 5th

     creating 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th 15th 16th 17th     data dictionary 2nd 3rd 4th     defined     dropping 2nd 3rd

     duplexed 2nd

     information 2nd 3rd 4th

     multiplexed 2nd 3rd 4th 5th 6th 7th 8th 9th

     nonreusable sections 2nd 3rd

     Oracle Managed Files (OMF) 2nd 3rd

     parameters 2nd

     Recovery Manager (RMAN)

     reusable sections 2nd

     size

     uses 2nd

CONTROL FILES initialization parameter

CONTROL_FILE_RECORD_KEEP_TIME parameter

converting

     character sets 2nd 3rd

CPU_PER_CALL resource limit

CPU_PER_SESSION resource limit CREATE CONTROLFILE command 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th 15th 16th 17th CREATE DATABASE command 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th

CREATE PROFILE command

CREATE ROLE command 2nd 3rd CREATE ROLE system privilege

CREATE SPFILE command 2nd

CREATE TABLE command 2nd 3rd 4th 5th 6th 7th CREATE TABLESPACE command 2nd 3rd 4th

CREATE USER commandcreating

     control files 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th 15th 16th 17th     data dictionary 2nd 3rd 4th 5th    databases         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     datafiles

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

     Oracle homes 2nd 3rd

     profiles 2nd 3rd 4th 5th 6th

     redo log files 2nd     roles 2nd 3rd 4th 5th

     SPFILE 2nd

     tables 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th     tablespaces 2nd 3rd 4th 5th 6th 7th 8th 9th 10th     undo tablespaces     users 2nd 3rd 4th 5th

custom databases