Oracle architecture questions and answers

The Oracle database has: - Logical layer: The components of the logical layer map the data to these physical components - Physical layer: The physical layer consists of the files that reside on the disk.....
The SMON background process performs all system monitoring functions on the oracle database....
There are four types of segments used in Oracle databases: - data segments - index segments - rollback segments - temporary segments.....
SGA (System Global Area) is a dynamic memory area of an Oracle Server. In SGA,the allocation is done in granuels. The size of the SGA is dependent on SGA_MAX_SIZE parameter...
The SQL*Loader control file contains information that describes how the data will be loaded. It contains the table name, column datatypes, field delimiters, etc...
Methods provided by SQL Loader - Conventional Path Load, Direct Path Load....
Logical Database structures - Logical structures include tablespaces, schema objects, data blocks, extents and segments.....