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

Oracle General (1809)
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 5997

What is Cursor?

Virtusa,

2 6034

How many Dispatcher Processes are created?

1 4366

What constitute an ORACLE Instance?

2 6385

What is the function of checkpoint(CKPT)?

4 9318

What is function of RECO?

1 4531

Name the ORACLE Background Process?

3 14608

What do Redo Log Buffers contain?

2 5353

What Does DBWR do?

Honeywell,

2 7081

When Does DBWR write to the database?

6 22692

What is SGA?

3 6439

What is PGA?

5 8237

When does LGWR write to the database?

3 10627

What is a Parallel Server option in ORACLE?

1 4086

What is User Process?

1 4364

Un-Answered Questions { Oracle }

Explain drop constraint oracle?

1051

What is the difference between oracle media recovery and crash recovery?

1169

What is oracle update statement with inner join ?

1049

What is the use of aggregate functions in oracle?

1022

definition of cluster and non-clustered index?

3024

What are the logical operations?

1118

What are the IKM types?

667

What is procedure overloading in oracle?

1049

How to load data from file to file and what are the KM's required for this requirement?

600

What is the difference between hot backup and cold backup in oracle?

1008

Can migrate the one ORACLE DATA INTEGATOR studio to another ORACLE DATA INTEGATOR studio?

622

What is enter substitution variable in oracle?

1042

Is there a function to split a string in plsql?

1047

Can we insert data in view oracle?

1013

How to get maxsal , minsal, ename department wise in single query

1544

For More Un-Answered { Oracle } Questions Click Here