Home | Interview Questions | Oracle | Architecture

Architecture

What are the components of Physical

What are the components of Physical database structure of Oracle Database?
Full details

What is the use of Redo Log Information

What is the use of Redo Log Information ?...
Full details

What is a Temporary Segment

What is a Temporary Segment...
Full details

What is Shared Pool

What is Shared Pool ?...
Full details

What are the different Levels of Auditing

What are the different Levels of Auditing ?...
Full details

What is a Parallel Server option

What is a Parallel Server option in ORACLE ?...
Full details

What is difference between Procedures

What is difference between Procedures and Functions ? ...
Full details

What is Distributed database ?

What is Distributed database ?...
Full details

What are the differences between Database

What are the differences between Database Trigger ...
Full details

What is Statement Auditing ?

What is Statement Auditing ?...
Full details

What are the steps involved in Instance

What are the steps involved in Instance Recovery ?...
Full details

What is Full Backup

What is Full Backup ?...
Full details

What are the steps involved in Database

What are the steps involved in Database Startup ?...
Full details

What is Archived Redo Log

What is Archived Redo Log ?...
Full details

What do Database Buffers contain ?

What do Database Buffers contain ?...
Full details

What are the components of SGA ?

What are the components of SGA ?...
Full details

What is a Data Dictionary ?

What is a Data Dictionary ?...
Full details

What are the uses of Rollback Segment ?

What are the uses of Rollback Segment ?...
Full details

What is an Index Segment ?

What is an Index Segment ?...
Full details

What is Data Block ?

What is Data Block ?...
Full details

What is an Index ?

What is an Index ?...
Full details

What are the components of Logical database

What are the components of Logical database structure ...
Full details

What are Schema Objects ?

What are Schema Objects ?...
Full details

What are the Characteristics of Data Files

What are the Characteristics of Data Files ?...
Full details

What is the function of Dispatcher (Dnnn) ?

What is the function of Dispatcher (Dnnn) ?...
Full details

What is the function of checkpoint(CKPT)?

What is the function of checkpoint(CKPT)?...
Full details

What are the steps involved

What are the steps involved in Database Shutdown ?...
Full details

What is the mechanism provided

What is the mechanism provided by ORACLE for table replication ? ...
Full details

What is Two-Phase Commit ?

What is Two-Phase Commit ?...
Full details

What is Log Switch ?

What is Log Switch ?...
Full details

What is Partial Backup ?

What is Partial Backup ?...
Full details

What is Restricted Mode of Instance

What is Restricted Mode of Instance Startup ? ...
Full details

What is penstock ?

What is penstock ?...
Full details

What is Privilege Auditing ?

What is Privilege Auditing ?...
Full details

What is Table space Quota ?

What is Table space Quota ?...
Full details

What is COST-based approach

What is COST-based approach to optimization ?...
Full details

When does a Transaction end ?

When does a Transaction end ?...
Full details

How many Dispatcher Processes

How many Dispatcher Processes are created ? ...
Full details

What is Shared SQL Area ?

What is Shared SQL Area ?...
Full details

What do Redo Log Buffers contain ?

What do Redo Log Buffers contain ?...
Full details

What is self-referential integrity constraint ?

What is self-referential integrity constraint ?...
Full details

What is an Integrity Constrains ?

What is an Integrity Constrains ?...
Full details

What is the function of Redo Log ?

What is the function of Redo Log ?...
Full details

What are the different type of Segments ?

What are the different type of Segments ?...
Full details

How to define Data Block size ?

How to define Data Block size ?...
Full details

What is Hash Cluster ?

What is Hash Cluster ?...
Full details

What is a Sequence ?

What is a Sequence ?...
Full details

What is SYSTEM tablespace

What is SYSTEM tablespace ...
Full details

What is a SNAPSHOT LOG ?

What is a SNAPSHOT LOG ?...
Full details

What is Object Auditing ?

What is Object Auditing ?...
Full details

What is Auditing ?

What is Auditing ?...
Full details

What is default tablespace ?

What is default tablespace ?...
Full details

What is Database Trigger

What is Database Trigger ?...
Full details

What are the uses of Database Trigger ?

What are the uses of Database Trigger ?...
Full details

What is a Procedure ?

What is a Procedure ?...
Full details

What is RULE-based approach

What is RULE-based approach to optimization ?...
Full details

What is the function of Optimizer ?

What is the function of Optimizer ?...
Full details

What is the function of Lock (LCKn)

What is the function of Lock (LCKn) Process ?...
Full details

What is function of RECO ?

What is function of RECO ?...
Full details

What are the functions of SMON ?

What are the functions of SMON ?...
Full details

When Does DBWR write to the database

When Does DBWR write to the database ?...
Full details

What is the maximum number of CHECK

What is the maximum number of CHECK constraints ...
Full details

What are the Limitations of a CHECK

What are the Limitations of a CHECK Constraint ?...
Full details

What is difference between UNIQUE

What is difference between UNIQUE constraint ...
Full details

What does a Control file Contain ?

What does a Control file Contain ?...
Full details

What is a Data File ?

What is a Data File ?...
Full details