Oracle Architecture Interview Questions
Questions Answers Views Company eMail

What is a Multi-threaded Server Configuration?

1 3336

What is Shared SQL Area?

Oracle,

1 5811

What is the function of ARCH?

3 4740

What are the functions of SMON?

7 17801

What is Dedicated Server Configuration?

IR Consulting,

2 4260

What is Server Process?

2 4778

What is Cursor?

Virtusa,

2 4619

How many Dispatcher Processes are created?

1 3518

What constitute an ORACLE Instance?

2 5315

What is the function of checkpoint(CKPT)?

4 7662

What is function of RECO?

1 3633

Name the ORACLE Background Process?

3 12955

What do Redo Log Buffers contain?

2 4275

What Does DBWR do?

Honeywell,

2 5739

When Does DBWR write to the database?

6 20370


Post New Oracle Architecture Questions

Un-Answered Questions { Oracle Architecture }

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?

2256


What is an Oracle Rollback Segment?

611


What are Oracle Schema Objects?

630


What is the use of Oracle Control File?

611


How to define Data Block size in Oracle?

632






Can a View based on another View in Oracle?

650


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

601


What is an Oracle Data Segment?

605


What is an Oracle Data Dictionary?

633


Can a Tablespace hold objects from different Schemes in Oracle?

619


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

2542


What is an Oracle Data Block?

631


What is an oracle database schema?

638


What are the uses of Oracle Rollback Segment?

641


What is an Integrity Constrains in Oracle?

718