Oracle Interview Questions
Questions Answers Views Company eMail

What is the difference between NAME_IN and COPY ?

2 37318

Identify package function from the following ?

1 3240

How does the command POST differs from COMMIT ?

2 5496

What the PAUSE package procedure does ?

1 3185

What package procedure is used for calling another form ?

3 6000

What package procedure used for invoke sql plus from sql forms ?

1 3213

Error_Code is a package proecdure ?

1 3345

EXIT_FORM is a restricted package procedure ?

1 3870

When the form is running in DEBUG mode, If you want to examine the values of global variables and other form variables, What package procedure command you would use in your trigger text ?

1 3290

List the system variables related in Block and Field?

1 4061

What is the difference between system.current_field and system.cursor_field ?

3 12005

What is an User Exits ?

1 3158

What are the type of User Exits ?

1 3240

What do you mean by a page ?

1 3130

How many pages you can in a single form ?

1 2840


Un-Answered Questions { Oracle }

What are the different types of backup available in the oracle?

300


What is oracle host variable?

538


Is it possible to execute a dynamic sql from forms?

599


What is the load balancing advisory?

1


Is the After report trigger fired if the report execution fails ?

2406






What are the differences between char and varchar2 in oracle?

565


What is the difference between postgresql and oracle?

510


Why is oracle database so popular?

566


How to write a query with an inner join in oracle?

564


How to use like conditions in oracle?

570


IS it possible to built the oracle database without setting the kernal parameters?

1763


How do I spool to a csv formatted file using sqlplus?

550


What are the constraints in odi?

327


What happens to the data files if a tablespace is dropped?

582


Discuss row chaining, how does it happen? How do you correct it?

288