-
What is a cluster Key ?
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.
-
What are the basic element of Base configuration of an oracle Database ?
It consists ofone or more data files.one or more control files.two or more redo log files.The Database containsmultiple users/schemasone or more rollback segmentsone or more tablespacesData dictionary tablesUser objects (table,indexes,views etc.,)The server that access the database consists ofSGA (Database buffer, Dictionary Cache Buffers, Redo log buffers, Shared...
-
How Materialized Views Work with Object Types and Collections
This is extract from Oracle10g Advanced Replication Book. How Materialized Views Work with Object Types and CollectionsOracle object types are user-defined datatypes that make it possible to model complex real-world entities such as customers and orders as single entities, called objects, in the database. You create object types using the CREATE TYPE ... AS OBJECT statement. You can replicate object...
-
-
-
-
Is it possible to configure primary server and stand by server on different OS?
Answer for this questions is NO. Standby database must be on same version of database and same version of Operating system.
-
-
-
-
-
-
-
-
-
-
-
-
-
Oracle DBA Interview Questions
Ans