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 does LGWR do?

2 5681

What is the function of Dispatcher (Dnnn)?

4 13979

What is the maximum number of Lock Processes used?

1 4242

What are functions of PMON?

5 14637

What is the function of Lock (LCKn) Process?

1 7086

What are the two types of Server Configurations?

3 6158

What is Shared Pool?

3 6208

What are the components of SGA?

5 6707

What is hit ratio ?

Indiabulls, RGPV,

13 130730

How to implement the multiple control files for an existing database ?

2 6221

How will you swap objects into a different table space for an existing database?

2 5152

How will you estimate the space required by a non-clustered tables?

2 4875

How the space utilisation takes place within rollback segments?

2 4806

What is a Control file ?

4 6916

How will you force database to use particular rollback segment?

1 4457

Un-Answered Questions { Oracle }

How to view all columns in an existing table?

986

How do you recover a lost control file?

How to change system global area (sga) in oracle?

1071

I need to run a report at scheduled timings only. I don't want to run the report on sundays. How to do this?

how to send file attachment from oracle forms

2605

What do you mean by hz_ in customer tables? : oracle accounts receivable

1310

How to define an anonymous procedure without variables?

1198

Have you attend the client meetings?

661

How many types of tables are there in oracle?

1118

How is clustered index different from non-clustered index?

Why do we need integrity constraints in a database?

1080

How to load data from multiple files to single target?

611

Can you convert a bit-mapped report to ASCII (character-mode) Report ? How ?

2337

What is PL/SQL ?

2222

What is split brain syndrome in rac?

For More Un-Answered { Oracle } Questions Click Here