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

difference between global n context sensitive segments?

Convergys,

2667

in compatibility in report registration?

Convergys,

1 4078

what is integrity n how many integrity rules r there?

Convergys,

2 8088

Where do u define the select statement of the parameter? is it followed by the & variable ?

Zensar,

2 5428

What is user exit.?

IBM, Synergy, Zensar,

2 8432

How you define procure to pay?

PWC, Zensar,

1 9621

How do u give the list of values in bind parameter

Zensar,

1 5748

What are the types of trigger actions?

Zensar,

4 7658

Can you mention lexical parameter in select statement in the data model?

Zensar,

1 8444

What is 4-way match?

Zensar,

2 13328

What is responsibility and how u attach How to create user and how u attach with responsibility.

Zensar,

2037

In what situation u create the BPA.

Zensar,

2208

What is the difference between BPA AND Contract What are documents and test cases u followed

Zensar,

2374

Can We Restore a Table that accidantly dropped.

TCS,

8 15637

what is difference between foreign key and reference key

AZTEC, Infosys,

3 42257

Un-Answered Questions { Oracle }

In what situation u create the BPA.

2208

Explain an extent?

1094

How to rebuild an index in oracle?

1023

What is the usage of synonyms?

1137

What is clustered table in Oracle?

1186

What is the difference between $oracle_base and $oracle_home?

1080

What is oracle rowcount?

1080

How do you tell what your machine name is and what is its IP address?

2088

How to check the oracle tns settings?

1042

please explain.. DB architecture ...

2015

What is a trigger and what are its types?

1219

How to Truncate Table in Oracle

1152

What are the Types of repositories in ODI?

584

What language does oracle use?

1094

What are the main benefits of using spfile over pfile?

635

For More Un-Answered { Oracle } Questions Click Here