Set - 1

Question 66 :

What is a Schema ?

Answer :

The set of objects owned by user account is called the schema.


Question 67 :

What is a cluster Key ?

Answer :

The related columns of the tables are called the cluster key. The cluster key is indexed using a cluster index and its value is stored only once for multiple tables in the cluster.


Question 68 :

What is Parallel Server ?

Answer :

Multiple instances accessing the same database (Only In Multi-CPU environments)


Question 69 :

What are the basic element of Base configuration of an oracle Database ?

Answer :

It consists of
one or more data files.
one or more control files.
two or more redo log files.
The Database contains
multiple users/schemas
one or more rollback segments
one or more tablespaces
Data dictionary tables
User objects (table,indexes,views etc.,)
The server that access the database consists of
SGA (Database buffer, Dictionary Cache Buffers, Redo log buffers, Shared SQL pool)
SMON (System MONito)
PMON (Process MONitor)
LGWR (LoG Write)
DBWR (Data Base Write)
ARCH (ARCHiver)
CKPT (Check Point)
RECO
Dispatcher
User Process with associated PGS


Question 70 :

What is clusters ?

Answer :

Group of tables physically stored together because they share common columns and are often used together is called Cluster.