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 5996

What is Cursor?

Virtusa,

2 6034

How many Dispatcher Processes are created?

1 4366

What constitute an ORACLE Instance?

2 6384

What is the function of checkpoint(CKPT)?

4 9318

What is function of RECO?

1 4529

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 22691

What is SGA?

3 6437

What is PGA?

5 8236

When does LGWR write to the database?

3 10627

What is a Parallel Server option in ORACLE?

1 4085

What is User Process?

1 4363

Un-Answered Questions { Oracle }

What is a named program unit?

1065

How to write a left outer join with the where clause in oracle?

1078

What are the varoius components of physical database structure of oracle database?

999

From the following identify the non schema object: packages, triggers, public synonyms, tables and indexes.

1061

What is an oracle and why it is used?

1140

What is CDC and explain complete CDC process flow?

586

How to use an explicit cursor without open statements?

1051

How to load data from multiple files to single target?

559

How to check your oracle database 10g xe installation?

983

hiding item in report how like that properly,thats manually but at runtime i want to do

3226

How to define an oracle sub procedure?

1134

What is the parameter mode that can be passed to a procedure?

1033

What happens if you use a wrong connect identifier?

1051

What are oracle functions?

1022

hi iam kavya, i completed Oracle11i(finance module), i do not know how to face the interview questions please adivese me

2226

For More Un-Answered { Oracle } Questions Click Here