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

MCN Solutions,

1136

what is the difference between restoring and recovering?

MCN Solutions,

1060

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

1196

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

Aricent,

1142

State any two functions of oracle?

Aricent,

1101

What is Virtual Private Database in Oracle?

MCN Solutions,

1152

Can we create database in oracle using command line ?

MCN Solutions,

1134

Why use resource manager in Oracle?

MCN Solutions,

1175

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

MCN Solutions,

1208

What is Undo Management Advisor in Oracle?

MCN Solutions,

1154

What is Redo Log Buffer in Oracle?

MCN Solutions,

1286

What is clustered table in Oracle?

MCN Solutions,

1264

What is data block in Oracle?

MCN Solutions,

1155

How can Oracle users be audited?

MCN Solutions,

1172

What is recovery manager(rman) backup in Oracle?

MCN Solutions,

1233

Un-Answered Questions { Oracle }

What is an external table?

1086

How do you find current date and time in oracle?

1106

What is define in oracle?

1114

What is meant by joins? List out the types of joins.

1109

What is a snapshot log?

1053

Which directory will you copy your new custom form, what would be its extension (.fmb or .fmx)?

How do we get field detail of a table?

1134

What are active transformation / passive transformations?

What is oracle rowcount?

1152

What is the meaning of database backup?

680

How to get a create statement for an existing table?

1020

How do you store pictures in a database?

1061

What does >> do?

636

What is meant by an index?

1227

Discuss row chaining, how does it happen?

621

For More Un-Answered { Oracle } Questions Click Here