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 5567

What is the function of Dispatcher (Dnnn)?

4 13819

What is the maximum number of Lock Processes used?

1 4175

What are functions of PMON?

5 14434

What is the function of Lock (LCKn) Process?

1 7007

What are the two types of Server Configurations?

3 6018

What is Shared Pool?

3 6071

What are the components of SGA?

5 6519

What is hit ratio ?

Indiabulls, RGPV,

13 130206

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

2 6088

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

2 5011

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

2 4771

How the space utilisation takes place within rollback segments?

2 4704

What is a Control file ?

4 6746

How will you force database to use particular rollback segment?

1 4364

Un-Answered Questions { Oracle }

How to make the project as .exe file in oracle forms & reports(d2k)?

What degree do database administrators need?

544

How to start your 10g xe server?

1041

What is format trigger?

2070

Does my odi infrastructure require an oracle database?

557

What is a initialization parameter file in oracle?

1035

What are the various oracle database objects?

1144

What happens if a primary key constraint is disabled and then enabled without fully specifying the index clause?

637

How to build data dictionary view an new database?

1009

How to declare a local variable?

1112

How do I reset a sequence in oracle?

1098

Explain how can you use the same lov for 2 columns?

1128

What is oracle analytical function?

1141

Can we use oracle pl/sql block in core java? if so how? pls get back to me .....

2969

What is a server parameter file in oracle?

1056

For More Un-Answered { Oracle } Questions Click Here