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

How do you display console on a window ?

1 4399

System.effective_date system variable is read only True/False

1 5284

What is the use of hidden column?

1 4938

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

1 5178

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

1 4854

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

1 4981

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

1 9006

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

1 4951

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

1 4229

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

1 4731

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

2 5461

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 6347

What is a library in Forms 4.0?

1 3947

explain about content canvas views?

1 4392

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

1 6097

Un-Answered Questions { Oracle }

What is the difference between the Oracle ODBC driver and a Microsoft ODBC (Open Database Connectivity) Driver?

1170

Difference between hot backup vs. Cold backup?

1041

Give two methods you could use to determine what DDL changes have been made.

6857

How to loop through a cursor variable?

1128

IS IT POSSIBLE TO CREATE REPORTS FROM DIFFERENT UNIVERSES IN ONE DOCUMENT?

2316

How to run create database statement again?

1221

What are four common errors found in an alert .log?

600

Explain the use of full option in exp command.

1179

Can a Tablespace hold objects from different Schemes in Oracle?

1088

Have you created sequence? When will you use?

601

What do database buffers contain?

1083

What does the no logging option do? Why would we be careful of using it?

661

When do I need to use a semicolon vs a slash in oracle sql?

1148

Is there any link between pr form(purchse requisition)and po form(purchase order)

2794

What is supporting issues GL AP and AR?

2620

For More Un-Answered { Oracle } Questions Click Here