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 are the different types of failures that occur in Oracle database?

HCL,

1067

How to Truncate Table in Oracle

HCL,

1154

What is the purpose of tables, private synonyms and public synonyms in Oracle?

HCL,

1045

Â How to use an oracle sequence generator in a mapping?

Informatica,

1075

Â What are the oracle DML commands possible through an update strategy?

Informatica,

1063

Explain the use of Merge statement in oracle 11g

Infosys,

1027

What are the tools for Oracle ?

Infosys,

1062

Name the three major set of files on disk that compose a database in Oracle?

1123

What is an Oracle Instance?

1122

What are the four Oracle system processes that must always be up and running for the database to be useable?

1017

Explain what are the different type of segments?

965

Explain a private synonyms?

1037

Explain an index?

1134

What do database buffers contain?

1030

Explain view?

1034

Un-Answered Questions { Oracle }

How does oracle handle read consistency?

1097

What is oracle analytical function?

1143

Why does for update in oracle 8 cause an ora-01002 error?

1003

Briefly explain what is literal? Give an example where it can be used?

1042

How to change system global area (sga) in oracle?

1013

Have you attend the client meetings?

617

What are types of data model?

551

What is the difference between online and offline backups?

1059

What is an Oracle Data Segment?

1044

What is tkprof and how is it used?

608

If you see statistics that deal with "undo" what are they really talking about?

653

What is truncate oracle?

971

What is oracle rowcount?

1084

What is dba training?

559

what is oracle forms?

1104

For More Un-Answered { Oracle } Questions Click Here