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 are the main benefits of using spfile over pfile?

680

What do you understand by the term 'normalization'? Explain the various modes of normalization?

598

What do we mean by record group in oracle forms?

1135

Explain the various types of oracle report?

1138

What do you understand by oracle forms?

1116

What is a canvas in oracle forms?

1119

What is an implicit anchor and how is it a different form explicit anchor in a report builder?

1214

What do you understand by lov?

1081

What are the various configuration files that are used by oracle forms?

1076

What is the difference between flex mode and confined mode?

1114

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

1142

Is it possible to have multiple layouts in a report?

1094

What is an oracle report? List its various types.

1024

What is a user exit program in oracle reports?

1083

What do you understand by oracle forms and why are they required?

1070

Un-Answered Questions { Oracle }

What is partitioned table in Oracle?

1276

What do you understand by the term 'normalization'? Explain the various modes of normalization?

598

Users are not being allowed on the system. The following message is received: ora-00257 archiver is stuck. Connect internal only, until freed. What is the problem?

656

What are the different oracle database objects?

1151

How do we get field details of a table?

1031

What do you mean by a tablespace?

1092

What are the new features in release 11i?

How to add another datafile to a tablespace?

1095

What is the purpose of save points in oracle database?

1208

Can we create trigger on materialized view in oracle?

1047

How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?

2309

Have you created sequence? When will you use?

601

What to do if the binary spfile is wrong for the default instance?

1111

What are functions of dba?

594

What is a trace file and how is it created in oracle?

1151

For More Un-Answered { Oracle } Questions Click Here