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 the difference between online and offline backups?

MCN Solutions,

1059

what is the difference between restoring and recovering?

MCN Solutions,

1011

What are the most common interview questions on ETL Testing for experience?

1143

In oracle there is column command, how will you explain that?

Aricent,

1055

State any two functions of oracle?

Aricent,

1046

What is Virtual Private Database in Oracle?

MCN Solutions,

1090

Can we create database in oracle using command line ?

MCN Solutions,

1085

Why use resource manager in Oracle?

MCN Solutions,

1105

What is the difference between view and materialized view in Oracle?

MCN Solutions,

1154

What is Undo Management Advisor in Oracle?

MCN Solutions,

1097

What is Redo Log Buffer in Oracle?

MCN Solutions,

1209

What is clustered table in Oracle?

MCN Solutions,

1196

What is data block in Oracle?

MCN Solutions,

1116

How can Oracle users be audited?

MCN Solutions,

1115

What is recovery manager(rman) backup in Oracle?

MCN Solutions,

1185

Un-Answered Questions { Oracle }

What is the quickest way to export a table to a flat file?

968

What is the difference between conversions and interfaces? : oracle accounts receivable

1231

You have just started a new instance with a large sga on a busy existing server. Performance is terrible, what should you check for?

541

how to do daily transactions with out sql* loader control file regesterd in apps?

1687

What is the purpose of a staging area?

How to execute a stored procedure in oracle?

1091

Why does Oracle not permit the use of PCTUSED with indexes?

2424

What is a nvl function? How can it be used?

1031

Can sub procedure/function be called recursively?

1003

Tell me some differences between ODI 10g and ODI 11g?

563

How do I start tns listener?

1044

What is the difference between hot backup and cold backup in oracle?

1014

What is a sub query? Describe its types?

1017

What does dba stand for database?

599

Give the different types of rollback segments.

1031

For More Un-Answered { Oracle } Questions Click Here