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 can you pass values to-and-fro from foreign function?

Difference between vat and property class.

What is call form stack?

Explain each trigger related to mouse.

Explain the method to debug errors in an oracle application.

how to dynamically change the page size of d2k reports?

what are savepoint mode and cursor mode properties ?

What is key.next.item trigger?

What is oracle forms system.currentblock?

Explain how to convert a report into excel sheet.

Explain the use of dde package in d2k.

Why do we need object libraries?

What is ole activation style property?

What are referenced objects? Explain the importance of referencing.

Explain the purpose of forms_ddl.

Un-Answered Questions { Oracle }

What is coalesce function?

1031

key flexfield structure

2125

Explain an exception?

948

How to connect to oracle using service name instead of sid?

972

What is meant by recursive hints in oracle?

1050

How to open a cursor variable?

989

Explain overloading. Can functions be overloaded?

946

ABOUT IDENTITY?

2017

Why do we need oracle client?

901

How to define a data field as not null?

1077

You are getting busy buffer waits. Is this bad? How can you find what is causing it?

508

Can any one explain me when i execute below query.. select months_between('07-JUL-12','10-FEB-12') from dual; Out put:- 4.90322581 How oracle calculate?

1349

what is the scripts in data base?

2099

Explain a private synonyms?

998

How do I limit the number of rows returned by an oracle query after ordering?

1117

For More Un-Answered { Oracle } Questions Click Here