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,

1031

How to Truncate Table in Oracle

HCL,

1115

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

HCL,

1001

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

Informatica,

1033

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

Informatica,

1021

Explain the use of Merge statement in oracle 11g

Infosys,

989

What are the tools for Oracle ?

Infosys,

1027

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

1083

What is an Oracle Instance?

1090

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

970

Explain what are the different type of segments?

923

Explain a private synonyms?

998

Explain an index?

1105

What do database buffers contain?

979

Explain view?

991

Un-Answered Questions { Oracle }

What happens if variable names collide with table/column names?

1127

How many anonymous blocks can be defined?

1128

what are bind variables?

1033

What is transaction control statement and how many types of transaction control statement in Oracle?

1101

What is the difference between single instance environment and rac environment?

What are snapshots? What are materialized views & where do we use them? What is a materialized view?

How do I limit the number of rows returned by an oracle query after ordering?

1118

What is flexfileds and use of flexfileds in odi?

537

Is java required for oracle client?

941

What is oracle open database communication (odbc)?

982

How to invoke the data pump import utility?

1104

Can we use oracle pl/sql block in core java? if so how? pls get back to me .....

2920

Explain the oracle real application clusters architecture?

What is memo?

605

What is the sql query to concatenate column values from multiple rows in oracle?

1015

For More Un-Answered { Oracle } Questions Click Here