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 is a trigger and what are its types?

1227

List out the types of joins.

1158

What are the parameters that we can pass through a stored procedure?

1064

What is a nested table?

1057

How view is different from a table?

1035

What do you understand by a database object?

1061

What is meant by raw datatype?

1060

When do we use group by clause in a sql query?

1035

Where do we use decode and case statements?

1012

How can we find out the duplicate values in an oracle table?

1046

What is the difference between truncate & delete command?

1182

How will you identify oracle database software release?

1010

What are the attributes that are found in a cursor?

1075

What do you understand by a database object? Can you list a few of them?

1018

What is a nvl function?

1031

Un-Answered Questions { Oracle }

if the source have total 15 records with 2 records are updated and 3 records are newly inserted at the target side we have to load the newly changed and inserted records

550

Explain compound trigger in oracle?

1039

How to increment dates by 1 in oracle?

1083

what is insert all statement in sql

6513

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

2216

What is the data quality in odi?

645

What is a user role in oracle?

1129

What is the difference between restoring a database and recovering a database?

What are record groups ? Explain the types of record group.

WHAT IS ecc 6.0

2147

How to rename an index in oracle?

1113

If you are not sure what command does a particular unix function what is the best way to determine the command?

565

What is the technical flow associated with P2P or Procure to Pay cycle like the tables, APIs, concurrent programs involved in this cycle. Only technical please.

3935

What are the key components of oracle’s maximum availability architecture?

Name the different triggers supported by oracle reports and their firing order.

1086

For More Un-Answered { Oracle } Questions Click Here