Oracle's basic mastery of content

Oracle database requires proficiency in the following

1, the writing of stored procedures and cursors, cursors written in the stored procedure, triggers

2, the function of the writing

3. Backup and Recovery

4. User and Rights Management

5. Functions and Query statements

6. Flash Back

7. Creation and management of table space and table

8. Large Objects

9, the definition and use of the package

I. Oracle Architecture

1, the physical storage structure 2, the logical storage structure 3, the Oracle process structure 4, the Oracle memory structure 5, the data dictionary

Second, table space

1, basic table Space 2, temporary table space 3, large text table space 4, Undo table space

Iii. control files, log files, archive logs

Iv. table 1, CREATE table 2, modify table 3, integrity constraints 4, Analysis table

V. SQL queries, functions, things, stored procedures, triggers

Vi. partitioned tables and partitioned indexes, sequences, synonyms, external tables, temporary tables, indexes

Vii. Flash Back

Oracle's basic mastery of content