Oracle Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Oracle General (1803)
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,

1124

How to Truncate Table in Oracle

HCL,

1219

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

HCL,

1096

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

Informatica,

1136

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

Informatica,

1107

Explain the use of Merge statement in oracle 11g

Infosys,

1083

What are the tools for Oracle ?

Infosys,

1114

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

1175

What is an Oracle Instance?

1164

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

1056

Explain what are the different type of segments?

1007

Explain a private synonyms?

1100

Explain an index?

1182

What do database buffers contain?

1083

Explain view?

1094

Un-Answered Questions { Oracle }

What is a directory object?

1142

Explain how to account for bank charges deducted from amount received against an invoice. : oracle accounts receivable

1348

How do you analyze table partition using oracle provided package?

559

How to use "in out" parameter properly?

1108

What is Sequences?

683

What are the standard concurent programs for auto invoice interface and customer interfaces? : oracle accounts receivable

1092

what is the odi console?

689

Have you come across the error ?Failed while printing ?. Why it is happened and How to solve that?

2035

How many types of tables supported by oracle?

1126

How do u print the data horizantally by using XML report? EX:Suppose there is one table names as SAMPLE in that we have only two columns say empno,ename.I want the output like this,At run time user may enter 3 colums(i.e to data print horizantally). empno ename empno ename empno ename 100 aaa 101 bbb 102 ccc 103 ddd 104 eee 105 fff

2301

You are getting busy buffer waits. Is this bad? How can you find what is causing it?

582

What is recovery manager(rman) backup in Oracle?

1233

How to create id with auto_increment on oracle?

1045

Discuss row chaining, how does it happen? How can you reduce it? How do you correct it?

590

What is merge in oracle?

1101

For More Un-Answered { Oracle } Questions Click Here