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 5888

What is Cursor?

Virtusa,

2 5908

How many Dispatcher Processes are created?

1 4280

What constitute an ORACLE Instance?

2 6274

What is the function of checkpoint(CKPT)?

4 9147

What is function of RECO?

1 4451

Name the ORACLE Background Process?

3 14484

What do Redo Log Buffers contain?

2 5247

What Does DBWR do?

Honeywell,

2 6978

When Does DBWR write to the database?

6 22455

What is SGA?

3 6344

What is PGA?

5 8037

When does LGWR write to the database?

3 10497

What is a Parallel Server option in ORACLE?

1 4017

What is User Process?

1 4286

Un-Answered Questions { Oracle }

Explain the wait events in statspack report 'db scattered read', 'db sequential real', 'enqueue'?

617

How to use "out" parameter properly?

1030

Explain index?

1212

What do you mean by oracle dba?

521

What is save point in oracle database?

1251

What is control file used for?

1113

What do you understand by a database object? Can you list a few of them?

977

Explain the function of optimizer in oracle?

1070

List the various oracle database objects?

1000

if the source have total 15 records with 2 records are updated and 3 records are newly inserted at the target side we have to load the newly changed and inserted records

512

How can we find out the current date and time in oracle?

1043

How many segment are present in Oracle Manufacturing

2266

What is call form stack?

What is integrity and what is constraint??Explain with example

2223

How to create Drill down report?

2080

For More Un-Answered { Oracle } Questions Click Here