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 9856

What is a Database instance ? Explain?

3 8245

What is Parallel Server ?

3 5826

What is a Schema ?

6 9461

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

4 11629

What is clusters ?

2 6610

What is a cluster Key ?

2 11137

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

2 5399

What is a deadlock ? Explain .

1 5873

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

TCS,

1 5055

What is a Shared SQL pool ?

2 7184

What is mean by Program Global Area (PGA) ?

Bajaj,

9 22640

What is a data segment ?

1 4864

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

2 5415

What is Database Buffers ?

1 4866

Un-Answered Questions { Oracle }

What is oracle in java?

961

How to name query output columns in oracle?

1183

A user is getting an ora-00942 error yet you know you have granted them permission on the table, what else should you check?

556

What are the main benefits of using spfile over pfile?

635

What is the use of the drop option in the alter table command?

594

Is there any link between pr form(purchse requisition)and po form(purchase order)

2714

What is the function of grid naming service used in oracle rac

Explain the use of record option in exp command.

999

Explain the dml?

974

what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these

2096

What do you mean by a deadlock?

1057

Difference between varchar and varchar2 data types?

1180

Is java required for oracle client?

994

Why do I get unexpected characters from 8-bit character sets in weblogic jdriver for oracle?

1083

What is an Oracle SYSTEM tablespace and when is it Created?

1104

For More Un-Answered { Oracle } Questions Click Here