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]

table constraints 2nd 3rd

table partition segments 2nd table segments 2nd 3rd TABLE system privilegestables     allocating extents 2nd 3rd

     altering 2nd 3rd

     cluster tables 2nd 3rd    columns         adding 2nd

         altering 2nd         dropping 2nd 3rd 4th         inserting 2nd

         unused columns 2nd 3rd

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

     data dictionary 2nd 3rd 4th

    data types         collection data 2nd 3rd 4th 5th

         relationship data types (REFs) 2nd

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

     extents 2nd 3rd

     external tables 2nd 3rd 4th 5th

     index-organized tables 2nd

     moving 2nd

     nested tables 2nd

     object tables

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

     privileges 2nd

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

     regular tables 2nd

     relational tables

     reorganizing

    rows

         structure 2nd 3rd

     temporary tables 2nd 3rd 4th 5th

     truncating 2nd 3rd TABLESPACE system privilegestablespaces

     altering 2nd

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

     data dictionary 2nd 3rd

    data files         adding 2nd 3rd

         AUTOEXTEND 2nd 3rd         moving 2nd 3rd 4th 5th 6th

     default temporary tablespaces 2nd 3rd 4th 5th     defined     dictionary managed 2nd 3rd     dropping 2nd 3rd 4th 5th 6th 7th     locally managed 2nd 3rd 4th

     Oracle Managed Files (OMF) 2nd 3rd 4th 5th

     resizing 2nd 3rd    statuses         offline 2nd 3rd 4th 5th 6th 7th

         online 2nd 3rd 4th         read-only 2nd 3rd 4th 5th     storage settings 2nd

     system 2nd

    SYSTEM tablespace

         auditing 2nd 3rd

         defined     temporary

     temporary tablespaces 2nd 3rd 4th 5th 6th 7th

     undo 2nd     undo tablespaces 2nd         altering 2nd         creating

         dropping 2nd 3rd

         ORA-1555 snapshot too old error message

         sizing 2nd 3rd 4th 5th

         switching 2nd

technical support for CD 2nd 3rd

templates

     managing 2nd

temporary segments 2nd

temporary tables 2nd 3rd 4th 5th

temporary tablespace

temporary tablespaces 2nd 3rd 4th 5th 6th 7th

test preparation [See exam preparation]

Theriault, Marlene, Oracle 91 DBA 101

tiiksLOracle Database Configuration Assistant (DBCA)

TIMED STATISTICS initialization parameter

TIMESTAMP data type 2ndtools     character set scanner 2nd 3rd

     Oracle Database Configuration Assistant

     Oracle Enterprise Manager (OEM) 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th 15th 16th 17th 18th 19th 20th     Oracle Locale Builder 2nd

     Oracle Universal Installer (OUI) 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th 15th 16th 17th 18th 19th 20th 21st

     orapwd 2nd 3rd 4th     Password File Utility

     SQL*Plus utility     SQL*Plus utlity 2nd 3rd

transaction-specific temporary tablestransactions    manual undo management mode         defined         support

    undo segments

         data dictionary 2nd 3rd 4th         deferred 2nd         defined 2nd

         headers         internal transaction table         non-SYSTEM 2nd 3rd

         quota 2nd 3rd

         read consistency 2nd 3rd 4th 5th 6th

         SYSTEM

         transaction recovery 2nd         transaction rollback

triggers

     defined 2nd TRUNCATE commandtruncating     tables 2nd 3rd

turning on/off

     privileges

types of data [See data types]

typical databases