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,

1074

Â 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?

1121

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?

1036

Explain an index?

1134

What do database buffers contain?

1029

Explain view?

1031

Un-Answered Questions { Oracle }

List the parts of a database trigger.

1049

What is an oracle transaction?

1145

What is the difference between a database and instance? What is the relation between them?

585

What privilege is needed for a user to insert rows to tables in another schema?

1014

What types of joins are used in writing subqueries?

982

How to do clean up if create database failed?

1027

What is set operator oracle?

978

all steps of bitmap report?

2353

How to call a sub procedure?

1093

What is the difference between sharding and replication?

1047

What is the difference between raid 5 and raid 10? Which is better for oracle?

589

What is Journalization and why we are using in ODI?

571

if you ctreate table identity

2372

Why we use oracle d2k?

Give the different types of rollback segments.

1031

For More Un-Answered { Oracle } Questions Click Here