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?

1126

In which language oracle has been developed?

1031

Difference between varchar and varchar2 data types?

1138

What is hash cluster in oracle?

1112

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

1000

How many memory layers are in the oracle shared pool?

1127

What are nested tables?

1125

How do we get field detail of a table?

1038

What are the roles of dba?

1034

Differentiate between pre-select and pre-query?

1064

What is save point in oracle database?

1259

What is hot backup and logical backup?

1014

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

1318

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

1106

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

981

Un-Answered Questions { Oracle }

What are the various oracle database objects?

1106

What are the uses of synonyms?

1101

How to use subqueries with the exists operator in oracle?

984

How to filter out duplications in the returning rows using oracle?

991

What is rich query?

939

What are database skills?

549

What is oracle analytical function?

1057

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

What are the extensions used by oracle reports?

1006

Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.

1920

How to use in conditions in oracle?

1013

What are named parameters?

1049

I have a table called 'test' on source and target with same name, structure and data type but in a different column order. How can you setup replication for this table?

1062

How to define an oracle cursor variable?

988

Mention what are the main components of an oracle rac system?

For More Un-Answered { Oracle } Questions Click Here