Oracle Architecture Interview Questions
Questions Answers Views Company eMail

What is a Multi-threaded Server Configuration?

1 3386

What is Shared SQL Area?

Oracle,

1 5864

What is the function of ARCH?

3 4822

What are the functions of SMON?

7 17970

What is Dedicated Server Configuration?

IR Consulting,

2 4321

What is Server Process?

2 4835

What is Cursor?

Virtusa,

2 4692

How many Dispatcher Processes are created?

1 3569

What constitute an ORACLE Instance?

2 5375

What is the function of checkpoint(CKPT)?

4 7759

What is function of RECO?

1 3672

Name the ORACLE Background Process?

3 13042

What do Redo Log Buffers contain?

2 4339

What Does DBWR do?

Honeywell,

2 5813

When Does DBWR write to the database?

6 20541


Post New Oracle Architecture Questions

Un-Answered Questions { Oracle Architecture }

What is an Oracle Data Dictionary?

667


What is an Oracle Data Block?

659


Teradata: How can we know the indexed column in a table?

1402


What is an Oracle Data Segment?

639


What are the consideration at tehe migration of Oracle 9i to 10G.

2569






What are Oracle Schema Objects?

666


What is the use of Oracle Control File?

638


What is an Oracle SYSTEM tablespace and when is it Created?

638


What is the function of Redo Log in Oracle?

684


What is an Oracle Rollback Segment?

640


How to define Data Block size in Oracle?

668


What are the uses of Oracle Rollback Segment?

673


How to calculate the approximate size of the SGA based on the size of the block,shared_pool,redo_buffer_cache and db_buffer_cache?

2290


What is an oracle database schema?

664


Can a View based on another View in Oracle?

679