Oracle Architecture Interview Questions
Questions Answers Views Company eMail

What is a Multi-threaded Server Configuration?

1 2461

What is Shared SQL Area?

Oracle,

1 4609

What is the function of ARCH?

3 3285




What are the functions of SMON?

7 14422

What is Dedicated Server Configuration?

IR Consulting,

2 3163

What is Server Process?

2 3553

What is Cursor?

Virtusa,

2 3213

How many Dispatcher Processes are created?

1 2642




What constitute an ORACLE Instance?

2 4014

What is the function of checkpoint(CKPT)?

4 5878

What is function of RECO?

1 2699

Name the ORACLE Background Process?

3 11379

What do Redo Log Buffers contain?

2 3133

What Does DBWR do?

Honeywell,

2 4103

When Does DBWR write to the database?

6 16671


Post New Oracle Architecture Questions






Un-Answered Questions { Oracle Architecture }

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

72


What is an oracle database schema?

67


What is an Integrity Constrains in Oracle?

71


What is an Oracle Data Segment?

75


What are Oracle Schema Objects?

57






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?

1718


What is an Oracle Data Block?

75


Can a Tablespace hold objects from different Schemes in Oracle?

75


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

1963


What is the function of Redo Log in Oracle?

76


What is an Oracle Data Dictionary?

71


What are the uses of Oracle Rollback Segment?

75


How to define Data Block size in Oracle?

76


What is an Oracle Rollback Segment?

69


Can a View based on another View in Oracle?

81