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

641

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

556

What do we mean by record group in oracle forms?

1073

Explain the various types of oracle report?

1070

What do you understand by oracle forms?

1039

What is a canvas in oracle forms?

1066

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

1158

What do you understand by lov?

1035

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

1030

What is the difference between flex mode and confined mode?

1049

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

1083

Is it possible to have multiple layouts in a report?

1026

What is an oracle report? List its various types.

974

What is a user exit program in oracle reports?

1027

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

1018

Un-Answered Questions { Oracle }

Explain the term 'oracle grid architecture'?

587

What is the use of Oracle Control File?

1072

How do we display rows from the table without duplicates?

972

hey friends, What are the steps I can do to transfer the database from Microsoft Access 2003 to oracle10g (or SQL) Best regards

1999

How to create a table index?

1147

What are the key characteristics of rac or why to use rac?

How to get maxsal , minsal, ename department wise in single query

1549

Guideline for sizing db_block_size and db_multi_block_read for an application that does many full table scans?

616

I creat Credit memo in AR. Now i want revers the Credit Memo.how you can revers that what out any aditional entry.

2307

Discuss row chaining, how does it happen? How can you reduce it?

542

What are triggers in oracle?

1036

What is tns name?

981

Explain self joins in oracle?

1017

What are the different types of synonyms?

1140

Is oracle a language?

944

For More Un-Answered { Oracle } Questions Click Here