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 the difference between normal and corelated subqueries?

2 9763

What is a Database instance ? Explain?

3 8136

What is Parallel Server ?

3 5692

What is a Schema ?

6 9292

What is an Index ? How it is implemented in Oracle Database ?

4 11496

What is clusters ?

2 6517

What is a cluster Key ?

2 11029

What are the basic element of Base configuration of an oracle Database ?

2 5299

What is a deadlock ? Explain .

1 5786

What is SGA ? How it is different from Ver 6.0 and Ver 7.0 ?

TCS,

1 4985

What is a Shared SQL pool ?

2 7104

What is mean by Program Global Area (PGA) ?

Bajaj,

9 22434

What is a data segment ?

1 4791

What are the factors causing the reparsing of SQL statements in SGA?

2 5329

What is Database Buffers ?

1 4784

Un-Answered Questions { Oracle }

What is temporary Interface( Yellow Interface) ?

527

What is variable? What is Flow of variable?

576

Why do we use coalesce function in oracle?

1071

What types of joins are used in writing subqueries?

947

Explain the use of file option in exp command.

1100

What are the major difference between truncate and delete?

1001

What operating systems are supported by oracle database 10g xe?

998

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

524

WHEN CURSOR MOVES FROM ONE FORM TO ANOTHER FORM, HOW MANY TRIGGER WILL BE FIRED AND WHAT ARE THEIR SEQUENCE?

2267

How to get last row id?

951

What do you understand by a database object? Can you list a few of them?

986

Explain the use of tables option in exp command.

1071

What is bind variables in oracle reports?

what is difference between group above and group left report

3770

What are active transformation / passive transformations?

For More Un-Answered { Oracle } Questions Click Here