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

How do you display console on a window ?

1 4339

System.effective_date system variable is read only True/False

1 5211

What is the use of hidden column?

1 4856

What is the built-in used for showing lov at runtime?

1 5081

What are the two types views available in the object navigator?

1 4785

What are the two repeating frame always associated with matrix object?

1 4903

If two groups are not linked in the data model editor, What is the hierarchy between them?

1 8938

Why is a Where clause faster than a group filter or a format trigger?

1 4876

What does the term panel refer to with regard to pages?

1 4149

What is the difference when confine mode is on and when it is off?

1 4652

Does a Before form trigger fire when the parameter form is suppressed.

2 5372

To display the page no. for each page on a report what would be the source & logical page no. or & of physical page no.?

2 6240

What is a library in Forms 4.0?

1 3877

explain about content canvas views?

1 4321

What is the difference when Flex mode is mode on and when it is off?

1 6031

Un-Answered Questions { Oracle }

Is primary key indexed by default in oracle?

993

suppose I having 6 interfaces and running the interface 3 rd one failed how to run remaining interfaces?

801

Differences between package and loadplans?

598

Which environment variables are absolutely critical in order to run the OUI?

2122

what is difference between inner join & nested query or subqueries

3046

What does an oracle dba do?

608

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

544

Please explain oracle data types with examples?

1075

How can we collect the statistics of different database objects?

Mention what are the file storage options provided by oracle database for oracle rac?

What is the data quality in odi?

648

What is varray?

1146

What are the IKM types?

682

Explain the function of optimizer in oracle?

1149

If you have an example table, what is the best way to get sizing data for the production table implementation?

560

For More Un-Answered { Oracle } Questions Click Here