Oracle Architecture Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Oracle Architecture Interview Questions

Questions Answers Views Company eMail

What is a Multi-threaded Server Configuration?

1 4362

What is Shared SQL Area?

Oracle,

1 7157

What is the function of ARCH?

3 5979

What are the functions of SMON?

7 19954

What is Dedicated Server Configuration?

IR Consulting,

2 5305

What is Server Process?

2 5896

What is Cursor?

Virtusa,

2 5915

How many Dispatcher Processes are created?

1 4283

What constitute an ORACLE Instance?

2 6282

What is the function of checkpoint(CKPT)?

4 9154

What is function of RECO?

1 4456

Name the ORACLE Background Process?

3 14496

What do Redo Log Buffers contain?

2 5253

What Does DBWR do?

Honeywell,

2 6983

When Does DBWR write to the database?

6 22466

Post New Oracle Architecture Questions

Un-Answered Questions { Oracle Architecture }

What is an Oracle Data Block?

1014

What is an Integrity Constrains in Oracle?

1145

What are Oracle Schema Objects?

1060

How to define Data Block size in Oracle?

1078

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

3018

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

1076

What is the use of Oracle Control File?

1025

Can a View based on another View in Oracle?

993

What is the function of Redo Log in Oracle?

1148

What is an Oracle Data Segment?

998

What is an Oracle Rollback Segment?

1072

What is an oracle database schema?

1084

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?

2655

Can a Tablespace hold objects from different Schemes in Oracle?

992

What are the uses of Oracle Rollback Segment?

1086

For More Un-Answered { Oracle Architecture } Questions Click Here