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,

1156

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

HCL,

1046

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

Informatica,

1076

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

Informatica,

1063

Explain the use of Merge statement in oracle 11g

Infosys,

1029

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?

966

Explain a private synonyms?

1038

Explain an index?

1135

What do database buffers contain?

1032

Explain view?

1036

Un-Answered Questions { Oracle }

Differentiate between pre-select and pre-query?

1106

Why should I use oracle database?

991

How can I introduce multiple conditions in like operator?

990

What are the restrictions on external table columns?

1054

you are a universe designer and report developer in BO, what type of information you gather from client?Briefly explain plz

1944

Explain the use of record option in exp command.

1006

What is db_recovery_file_dest in oracle? When do you need to set this value?

1125

How would you determine what sessions are connected and what resources they are waiting for?

2127

How do I become a data manager?

527

System tablespace cant be exported from one database and imported into another why?

555

What is rac and what are the various benefits of using rac architecture?

What do you mean by hz_ in customer tables? : oracle accounts receivable

1221

How to drop an existing view in oracle?

946

What are the requirements of simple database?

570

Explain view?

1036

For More Un-Answered { Oracle } Questions Click Here