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 6014

What is Cursor?

Virtusa,

2 6054

How many Dispatcher Processes are created?

1 4380

What constitute an ORACLE Instance?

2 6404

What is the function of checkpoint(CKPT)?

4 9353

What is function of RECO?

1 4544

Name the ORACLE Background Process?

3 14631

What do Redo Log Buffers contain?

2 5380

What Does DBWR do?

Honeywell,

2 7112

When Does DBWR write to the database?

6 22765

What is SGA?

3 6463

What is PGA?

5 8282

When does LGWR write to the database?

3 10658

What is a Parallel Server option in ORACLE?

1 4105

What is User Process?

1 4386

Un-Answered Questions { Oracle }

Why do we need object libraries?

Is it possible to split the print reviewer into more than one region ?

2280

How to create a stored procedure in oracle?

1103

what are the oracle forms services components include?

1024

What is bind variables in oracle reports?

How to sort output in descending order in oracle?

1045

What is an Oracle Instance?

1122

How many redo logs should you have and how should they be configured for maximum recoverability?

567

What is the recommended interval at which to run statspack snapshots, and why?

2919

What are the set operators union, union all, minus & intersect meant to do?

988

nw i'm doing MBA system and planning to do oracle,database management.tell me that whether it is useful r not?.refer any course for my carrier pls

2209

What is the difference between conversions and interfaces? : oracle accounts receivable

1231

what is the difference between substr and instr function in oracle?

1090

Why packages are used in oracle?

1066

How can be determining the size of the log files?

583

For More Un-Answered { Oracle } Questions Click Here