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 9864

What is a Database instance ? Explain?

3 8262

What is Parallel Server ?

3 5844

What is a Schema ?

6 9475

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

4 11646

What is clusters ?

2 6618

What is a cluster Key ?

2 11143

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

2 5403

What is a deadlock ? Explain .

1 5884

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

TCS,

1 5069

What is a Shared SQL pool ?

2 7189

What is mean by Program Global Area (PGA) ?

Bajaj,

9 22684

What is a data segment ?

1 4881

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

2 5433

What is Database Buffers ?

1 4875

Un-Answered Questions { Oracle }

What are the differences between primary key and unique key?

1010

What are the daily activities of oracle dba?

602

where do u put the report file

2092

What is load plan and types of load plans in ODI?

628

How can we collect the statistics of different database objects?

How to create a new oracle data file?

1032

Can you list down the different components of physical and logical database structure?

Discuss row chaining, how does it happen? How can you reduce it?

542

How to use an explicit cursor without open statements?

1055

How to define default values for formal parameters?

1044

Can multiple columns be used in group by in oracle?

988

How to pass a parameter to a cursor in oracle?

1179

How to define an anonymous procedure with variables?

1159

Why do you use stored procedures and state some of its disadvantages?

1028

How many control files should you have? Where should they be located?

583

For More Un-Answered { Oracle } Questions Click Here