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

2 5571

What is the function of Dispatcher (Dnnn)?

4 13820

What is the maximum number of Lock Processes used?

1 4176

What are functions of PMON?

5 14438

What is the function of Lock (LCKn) Process?

1 7008

What are the two types of Server Configurations?

3 6021

What is Shared Pool?

3 6076

What are the components of SGA?

5 6523

What is hit ratio ?

Indiabulls, RGPV,

13 130215

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

2 6090

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

2 5012

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

2 4772

How the space utilisation takes place within rollback segments?

2 4705

What is a Control file ?

4 6751

How will you force database to use particular rollback segment?

1 4364

Un-Answered Questions { Oracle }

What is recycle bin in Oracle?

1150

what is the need of indexing topic in oracle? where do we use in a Java project? any other option other than using this to get the same result where we use indexing ?

2467

How do you analyze table partition using oracle provided package?

520

How to omit columns with default values in insert statement in oracle?

1046

What happens internally when the user types userID/password@string in SQL PLUS Thanks-Bhaskar

4594

What is the exact use of Collections?

2143

Give the different types of rollback segments.

1031

Can a View based on another View in Oracle?

1029

What is a subquery in oracle?

1109

What is oracle log switch?

619

How to create a new table in oracle?

1156

In XIR2 if we lost the administration password .How can we regain the password?thanks in advance.

1933

What happens if you keep split brain syndrome in rac unresolved? How it can be resolved?

What is a table index?

1098

How many data types are supported?

1079

For More Un-Answered { Oracle } Questions Click Here