Oracle General Interview Questions
Questions Answers Views Company eMail

What is a Schema ?

6 7636

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

4 9997

What is clusters ?

2 5120

What is a cluster Key ?

2 10091

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

2 4304

What is a deadlock ? Explain .

1 4930

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

TCS,

1 4181

What is a Shared SQL pool ?

2 6127

What is mean by Program Global Area (PGA) ?

Bajaj,

9 19686

What is a data segment ?

1 4096

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

2 4302

What is Database Buffers ?

1 3978

What is dictionary cache ?

2 4139

What is meant by recursive hints ?

1 5490

What is meant by redo log buffer ?

2 6452


Post New Oracle General Questions

Un-Answered Questions { Oracle General }

How to start instance with a minimal initialization parameter file?

508


Explain rename?

523


is there a tool to trace queries, like profiler for sql server?

574


What is a synonym? What are its various types?

604


How to write a query with a right outer join in oracle?

589






What is the relation of a user account and a schema in oracle?

555


How oracle handles dead locks?

574


What is blob data type in oracle?

535


What is coalesce function?

545


What is oracle analytical function?

504


How to convert character types to numeric types?

553


What are set operators?

632


What is the data type of dual table?

504


Explain drop constraint oracle?

572


What is a tns service name?

513