Technology Questions

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.

IOS - 6.1.3 (updated on 5/15/13 3:15 AM Pacific Daylight Time)

Redo logs are logical and physical structures that are designed to hold all the changes made to a database and are intended to aid in the recovery of a database.

ALTER TABLESPACE ADD DATAFILE <datafile_name> SIZE <size>

ALTER SYSTEM SWITCH LOGFILE;

ALTER INDEX <index_name> REBUILD;

IOS 4 and above supports multi-tasking and allows apps to remain in the background until they are launched again or until they are terminated.  

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.