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]

scalar data 2nd 3rd 4th 5th 6th 7th 8th 9th

Schema Managerschema objects     definedschemas     defined

SCN (system change number)

scripts     catalog scripts 2nd 3rd 4th 5th Security Manager

segments     automatic segment space management (ASSM) 2nd 3rd     bootstrap 2nd 3rd

     bootstrap segments

     cache segments

     characteristics 2nd

     clusters 2nd     data segments

     defined 2nd

     extents     index partitions     index segments     index-organized table

     indexes

     Large Objects Binary (LOB) 2nd

     LOBnn segments

     manual segment space management 2nd

     nested tables 2nd

     rollback segments 2nd

     table partitions 2nd

     table segments

     tables 2nd

     temporary

     temporary segments

     undo

SELECT object privilege

SELECT_CATALOG_ROLE

self-assessment

     determining your readiness for the exam 2nd     educational background 2nd 3rd 4th 5th     expectations 2nd

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

server parameter file (SPFILE) 2nd server processes

session-specific temporary tables 2nd 3rd

sessions     defined 2nd 3rd

SESSIONS_PER_USER resource limit SET CONSTRAINTS statement 2nd

SET ROLE command 2nd 3rdsetting     constraints     environment variables 2ndSGA (System Global Area)

     database buffer cache 2nd

     defined 2nd     granules     Java pool 2nd

     large pool 2nd     redo log buffer 2nd     shared pool 2nd 3rd

Shared Global Area

shared PL/SQL area 2nd

shared pool 2nd 3rd

SHARED POOL SIZE initialization parameter shared server architecture 2nd

shared server processes

shared SQL area 2nd 3rd 4th 5th 6th 7th 8th 9th 10thshortcut     MeasureUp practice tests 2nd 3rd SHUTDOWN ABORT command 2nd

SHUTDOWN IMMEDIATE command 2nd 3rd

SHUTDOWN NORMAL command 2nd 3rd

SHUTDOWN TRANSACTIONAL command 2nd 3rd

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

single-byte character sets 2nd

sizing

     redo log files 2nd 3rd

     undo tablespaces 2nd 3rd 4th 5th

SMON (System Monitor) processes 2nd

SNMPAGENT role

sorting

     binary

     monolingual 2nd

     multilingual 2nd

     NLS_SORT environment variable

     NLSSORT function SPFILE 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th SPFILE (server parameter file) 2nd

spfileSID.ora file 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th

SQL functions     NLS parameters 2nd 3rd 4th 5th

     NLSSORT

SQL TRACE initialization parameter SQL work areas 2nd

SQL*Loader 2nd 3rd SQL*Plus User's Guide and Reference

SQL*Plus utility SQL*Plus utlity 2nd 3rd SQL*Plus Worksheetstarting     Oracle Universal Installer (OUI)

starting databases

     automation 2nd     OEM interface 2nd     STARTUP command 2nd 3rd 4th 5th

     STARTUP MOUNT command 2nd     STARTUP NOMOUNT command 2nd 3rd     STARTUP OPEN command 2nd

STARTUP command 2nd 3rd 4th 5th

STARTUP MOUNT command 2nd

STARTUP NOMOUNT command 2nd 3rd

STARTUP OPEN command 2ndstatement execution

     auditing 2nd

static parameter files 2nd 3rd 4th 5th 6th 7th statistics on index usage 2nd 3rdstatuses of tablespaces     offline 2nd 3rd 4th 5th 6th 7th

     online 2nd 3rd 4th

     read-only 2nd 3rd 4th 5th

Storage Manager

storage parameters

     indexes 2nd 3rd

stored procedures

     data dictionary

storing data

    tables

         cluster tables 2nd 3rd

         index-organized tables 2nd

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

         regular tables 2nd

switching

     undo tablespaces 2nd

synonyms     definedSYSDBA role

     privileges 2nd 3rd 4th

SYSOPER role     privileges 2nd

system change number (SCN)

System Global Area (SGA)     database buffer cache 2nd

     defined 2nd     granules

     Java pool 2nd     large pool 2nd     redo log buffer 2nd     shared pool 2nd 3rd System Monitor (SMON) processes 2nd

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

system tablespace 2ndSYSTEM tablespace     auditing 2nd 3rd

     defined SYSTEM undo segments