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

2 9968

What is a Database instance ? Explain?

3 8407

What is Parallel Server ?

3 5973

What is a Schema ?

6 9686

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

4 11815

What is clusters ?

2 6757

What is a cluster Key ?

2 11264

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

2 5508

What is a deadlock ? Explain .

1 6007

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

TCS,

1 5158

What is a Shared SQL pool ?

2 7280

What is mean by Program Global Area (PGA) ?

Bajaj,

9 23035

What is a data segment ?

1 4983

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

2 5531

What is Database Buffers ?

1 4977

Un-Answered Questions { Oracle }

Differentiate between earned discounts and unearned discounts? : oracle accounts receivable

1226

What is enter substitution variable in oracle?

1099

What is oracle datasource?

1043

how to dynamically change the page size of d2k reports?

HI ALL, CAN ANYONE TELL ME THE DIFFERENCES BETWEEN SQL CLUSTURS,MSQL CLUSTERS,ORACLE CLUSTERS.......THANKS IN ADVANCE

2301

What is a select query statement in oracle?

1033

How is clustered database important in oracle rac architecture?

In what situation u create the BPA.

2254

What privilege is needed for a user to delete rows from tables in another schema?

1143

A tablespace has a table with 30 extents in it. Is this bad? Why or why not.

625

What is the difference between Delete, Truncate and Drop in Oracle?

1187

How to select an oracle system id (sid)?

1125

How many types of synonyms in Oracle?

1183

Is it possible to have multiple layouts in a report?

1095

What are the attributes that are found in a cursor?

1126

For More Un-Answered { Oracle } Questions Click Here