Oracle General Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Oracle General Interview Questions

Questions Answers Views Company eMail

What is a Schema ?

6 9675

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

4 11811

What is clusters ?

2 6755

What is a cluster Key ?

2 11262

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

2 5507

What is a deadlock ? Explain .

1 6006

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

TCS,

1 5155

What is a Shared SQL pool ?

2 7277

What is mean by Program Global Area (PGA) ?

Bajaj,

9 23030

What is a data segment ?

1 4983

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

2 5528

What is Database Buffers ?

1 4975

What is dictionary cache ?

2 5719

What is meant by recursive hints ?

1 6516

What is meant by redo log buffer ?

2 7815

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

What is an oracle table?

1035

Describe varray?

1118

What is pragma autonomous transaction in oracle?

1128

How a database is related to tablespaces?

1084

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

1064

How to define a variable of a specific record type?

1118

What is PL/SQL ?

2221

Explain the function of optimizer in oracle?

1203

Is it possible to set second Primary Key Constraint in a table in Oracle Database ?

1230

What is connection pooling in oracle?

1019

How to speed up webrick?

1128

How to set a transaction to be read only in oracle?

1144

How to rename an index in oracle?

1174

Who developed oracle & when?

1060

Explain compound trigger in oracle?

1091

For More Un-Answered { Oracle General } Questions Click Here