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

Oracle General (1803)
Oracle DBA (Database Administration) (261)
Oracle Call Interface (OCI) (10)
Oracle Architecture (90)

Oracle Interview Questions

Questions Answers Views Company eMail

What is Server Process?

2 6125

What is Cursor?

Virtusa,

2 6169

How many Dispatcher Processes are created?

1 4465

What constitute an ORACLE Instance?

2 6509

What is the function of checkpoint(CKPT)?

4 9532

What is function of RECO?

1 4615

Name the ORACLE Background Process?

3 14739

What do Redo Log Buffers contain?

2 5469

What Does DBWR do?

Honeywell,

2 7256

When Does DBWR write to the database?

6 22977

What is SGA?

3 6591

What is PGA?

5 8507

When does LGWR write to the database?

3 10811

What is a Parallel Server option in ORACLE?

1 4173

What is User Process?

1 4471

Un-Answered Questions { Oracle }

How to create an oracle database manually?

1136

How oracle flex asm works?

Where can you get a list of all initialization parameters for your instance? How about an indication if they are default settings or have been changed?

630

How view is different from a table?

1091

can u plz provide me oca sql dumps please i need them

1999

What is an anonymous block?

1330

What exactly do quotation marks around the table name do?

1029

What is a select query statement in oracle?

1033

What are the built-in functions used for sending Parameters to forms ?

3440

What is an explain plan and how does it help in optimizing the sql query?

How to create id with auto_increment on oracle?

1045

What is the usage of synonyms?

1221

How to determine what records to extract?

What is the difference between single instance environment and rac environment?

How many concurrent programs you have customized, can you name some of them?

For More Un-Answered { Oracle } Questions Click Here