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 4327

System.effective_date system variable is read only True/False

1 5202

What is the use of hidden column?

1 4847

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

1 5074

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

1 4776

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

1 4888

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

1 8927

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

1 4870

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

1 4138

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

1 4649

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

2 5361

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 6231

What is a library in Forms 4.0?

1 3862

explain about content canvas views?

1 4309

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

1 6025

Un-Answered Questions { Oracle }

What is a dba?

585

What is package and main advantages?

606

What is an Oracle database Full Backup?

1130

What is dynamic proxy?

1005

What are snapshots? What are materialized views & where do we use them? What is a materialized view?

If a parameter is used in a query without being previously defined, what diff. exist betw. report 2.0 and 2.5 when the query is applied ?

2292

What is the format trigger?

How to build data dictionary view an new database?

1009

A user is getting an ora-00942 error yet you know you have granted them permission on the table, what else should you check?

558

How to use in conditions in oracle?

1058

What are different types of transactions in ar? : oracle accounts receivable

1295

How to run create database statement?

1032

How to set a transaction to be read only in oracle?

1093

How do you find out from the RMAN catalog if a particular archive log has been backed-up?

2122

What is a data lock in oracle?

1118

For More Un-Answered { Oracle } Questions Click Here