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

Explain integrity constraint?

1164

In which language oracle has been developed?

1081

Difference between varchar and varchar2 data types?

1191

What is hash cluster in oracle?

1180

What is the parameter mode that can be passed to a procedure?

1058

How many memory layers are in the oracle shared pool?

1191

What are nested tables?

1178

How do we get field detail of a table?

1083

What are the roles of dba?

1073

Differentiate between pre-select and pre-query?

1115

What is save point in oracle database?

1305

What is hot backup and logical backup?

1057

What is the fastest query method to fetch data from the table?

1371

can you convert or reverse engineer a fmx back to a fmb file?

1167

what the 'lov of validation' property of an item? Mention what is the difference between lov and list item?

1028

Un-Answered Questions { Oracle }

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

1043

I have a database backup file in .db (ext) form how to conver it into .dmp (ext.) for oracle database

2144

Does a dba have to file taxes?

592

How to use subqueries with the exists operator in oracle?

1032

What are the ansi data types supported in oracle?

953

When do you get a .pll extension in oracle? Explain its importance

1053

How to retrieve values from data fields in record variables?

1123

How to revoke create session privilege from a user in oracle?

1024

What are the roles and responsibilities of oracle dba?

644

How to use group functions in the select clause using oracle?

1077

Can you list down the different components of physical and logical database structure?

How does oracle handle read consistency?

1102

What is ole automation?

What happens if recursive calls get out of control?

1084

What is rac and what are the various benefits of using rac architecture?

For More Un-Answered { Oracle } Questions Click Here