An OLE server application creates ole Objects that are embedded or linked in OLE Containers ex. OLE servers are ms_word & ms_excel. OLE containers provide a place to store, display and manipulate objects that are created by ole server applications. Ex. oracle forms is an example of an OLE Container.

- Installing and upgrading the Oracle Server and application tools.

- Allocating system storage and planning future storage requirements for the database system.

- Managing primary database structures (tablespaces)

- Managing primary objects (table, views, indexes)

- Enrolling users and maintaining system security.

- Ensuring compliance with Oracle license agreement

- Controlling and monitoring user access to the database.

- Monitoring and optimizing the performance of the database.

- Planning for backup and recovery of database information.

- Maintain archived data on tape

- Backing up and restoring the database.

- Contacting Oracle Corporation for technical support.

SQL * DBA - This allows DBA to monitor and control an ORACLE database. SQL * Loader - It loads data from standard operating system files (Flat files) into ORACLE database tables. Export (EXP) and Import (imp) utilities allow you to move existing data in ORACLE format to and from ORACLE database.

To perform one of these function on an index, table, or cluster:

 - To collect statistics about object used by the optimizer and store them in the data dictionary. 

 - To delete statistics about the object used by object from the data dictionary.

 - To validate the structure of the object.

 - To identify migrated and chained rows off the table or cluster.

Use the buffer cache advisory over a given workload and then query the v$db_cache_advice table. If a change was necessary then I would use the alter system set db_cache_size command.

Disable the foreign key constraint to the parent, drop the table, re-create the table, enable the foreign key constraint.

UPDATE and DELETE Restrict - A referential integrity rule that disallows the update or deletion of referenced data. DELETE Cascade - When a referenced row is deleted all associated dependent rows are deleted.

Complete database recovery from disk failure is possible only in ARCHIVELOG mode. Online database backup is possible only in ARCHIVELOG mode.