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]

ideal OCA/OCP candidate 2nd 3rd 4th

IDENTIFIED BY clause (roles) IDLE_TIME resource limit IFILE initialization parameter IMP FULL DATABASE role implicit parameters

INDEX object privilege

index partitions index segments 2nd INDEX system privileges

index-organized table (IOT) index-organized tables 2ndindexes

     B-tree 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th 15th

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

     coalescing 2nd

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

     defined 2nd 3rd

     dropping 2nd     logical index classifications 2nd 3rd 4th 5th     nonpartitioned     partitioned

     physical index classifications 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th

     rebuilding 2nd 3rd 4th 5th 6th

     storage parameters 2nd 3rd

     usage statistics 2nd 3rd

     validating 2nd

indexing

     linguistic indexing support 2nd

initial extent

initialization parameter files

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

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

initialization parameters

     BACKGROUND_DUMP_DEST

     COMPATIBLE

     CONTROL FILES

     DB_BLOCK_BUFFERS     DB_BLOCK_SIZE 2nd 3rd 4th     DB_CREATE_FILE_DEST

     DB_CREATE_ONLINE_LOG_DEST

     DB_NAME     IFILE

     LOG BUFFER

     LOG_ARCHIVE_START initialization parameter 2nd 3rd 4th     MAX_DUMP_FILE_SIZE

     PROCESSES     SHARED POOL SIZE

     SQL TRACE     TIMED STATISTICS     USER DUMP DEST INITRANS block utilization parameter 2nd initSID.ora file 2nd 3rd 4th 5th 6th 7th

INSERT object privilege

inserting     columns (tables) 2ndinstalling

     CD 2nd 3rd 4th 5th 6th 7th 8th Instance Managerinstances

     connections 2nd 3rd 4th

     defined

     relationships 2nd 3rd

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 IOT (index-organized table) iSQL*Plus 2nd