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 is dictionary cache ?

2 5589

What is meant by recursive hints ?

1 6390

What is meant by redo log buffer ?

2 7689

What are the factors causing the reparsing of SQL statements in SGA?

1 4417

Can you truncate a table in a procedure in Oracle Forms?

2 8404

What is AppCore and AppCore2 ?

1 6301

Can a sigle canvas be used by different blocks ?

2 5603

What is the order of the triggers fired once the form is opened?

3 6162

What are the built-in routines is available in forms 4.0 to create and manipulate a parameter list?

1 3536

Is it possible to attach same library to more than one form?

1 4552

What is a predefined exception available in forms 4.0?

2 4244

What are the built_in used to trapping errors in forms 4?

1 3690

What is a library in Forms 4.0?

1 4211

What built-in is used for showing the alert during run-time?

1 4208

What is user Account in Oracle database ?

2 4837

Un-Answered Questions { Oracle }

What should a dba know?

528

What is key.next.item trigger?

How many memory layers are in the oracle shared pool?

1181

What happens if the update subquery returns multiple rows?

1116

Difference between open_form and call_form in oracle.

1161

What is da in database?

543

What is call form stack?

What is a named program unit?

1083

How to create a stored function in oracle?

1105

Hi friends can u send the oracle 9i full version download link?????????????? please reply ?

1865

What are the different tools that are provided by oracle to assist performance monitoring?

How do I find the database name in oracle?

1038

Difference between ETL and E_LT?

593

What is an oracle data file?

1103

Is there any way to find out when one specific table/view/M-view is used last time. i.e. when one specific object is used in any SELECT statement.

1349

For More Un-Answered { Oracle } Questions Click Here