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 5457

What is the function of Dispatcher (Dnnn)?

4 13646

What is the maximum number of Lock Processes used?

1 4087

What are functions of PMON?

5 14198

What is the function of Lock (LCKn) Process?

1 6912

What are the two types of Server Configurations?

3 5892

What is Shared Pool?

3 5928

What are the components of SGA?

5 6332

What is hit ratio ?

Indiabulls, RGPV,

13 129697

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

2 5986

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

2 4907

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

2 4675

How the space utilisation takes place within rollback segments?

2 4593

What is a Control file ?

4 6604

How will you force database to use particular rollback segment?

1 4295

Un-Answered Questions { Oracle }

Can we create trigger on materialized view in oracle?

946

What is a trigger and what are its types?

1132

What is oracle thin client?

979

Can we insert data in view oracle?

974

Explain the different levels at which oracle form services interact.

1006

does the query needs a hint to access a materialized view?

1823

what is difference between inner join & nested query or subqueries

2980

What are the various constraints used in oracle?

999

What are the differences between char and varchar2 in oracle?

1088

What is oracle dba role?

527

How to end the current transaction in oracle?

974

What is transactional trigger property?

What is Sequences?

582

How to create an initialization parameter file?

995

If you see contention for library caches how you can fix it?

522

For More Un-Answered { Oracle } Questions Click Here