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

What are the built-ins used for processing rows?

1 5960

What are the built-ins used for finding object ID functions?

2 4519

Use the add_group_column function to add a column to record group that was created at a design time?

2 5514

Use the Add_group_row procedure to add a row to a static record group 1. true or false?

2 8856

What are parameters?

1 4227

What are the Built-ins used for sending Parameters to forms?

2 4821

What is the maximum no of chars the parameter can store?

1 3783

How do you call other Oracle Products from Oracle Forms?

1 6061

How do you reference a Parameter?

1 4185

How do you reference a parameter indirectly?

1 4153

What are the different Parameter types?

2 4795

When do you use data parameter type?

1 3592

Can you pass data parametrs to forms?

1 4121

What are different types of images?

1 3499

What is the difference between boiler plat images and image items?

1 4294

Un-Answered Questions { Oracle }

How to commit the current transaction in oracle?

1193

What are the steps involved in instance recovery in oracle?

597

in user parameter property we have list of values.can we write select query for binding? for example:: select empno from emp where deptno=:deptnum :deptnum is first parameter it displays distinct dept nos. if i do like this it is giving error:: bind variables are not allowed in the select statement

1758

How can we identify the resources for which the sessions are waiting?

You get a call from you backup dba while you are on vacation. He has corrupted all of the control files while playing with the alter database backup controlfile command. What do you do?

643

How many types of database software are there?

629

List five most important parameter in 9i affecting performance?

610

How to convert csv to table in oracle?

1050

How will you differentiate between varchar & varchar2?

1094

How to fetch the row which has the max value for a column?

1054

What language does oracle use?

1174

What is an oracle function?

1248

Point out the difference between user tables and data dictionary?

1045

What happens to the current transaction if the session is ended?

1144

in after report trigger if you don't write Srw.user_exit(Fnd_user exit) what it will do it will stop report execution or it will just not free the memory

2976

For More Un-Answered { Oracle } Questions Click Here