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 5959

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

2 4512

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

2 5509

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

2 8855

What are parameters?

1 4223

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

2 4820

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

1 3780

How do you call other Oracle Products from Oracle Forms?

1 6058

How do you reference a Parameter?

1 4181

How do you reference a parameter indirectly?

1 4151

What are the different Parameter types?

2 4789

When do you use data parameter type?

1 3591

Can you pass data parametrs to forms?

1 4116

What are different types of images?

1 3496

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

1 4291

Un-Answered Questions { Oracle }

Can group functions be mixed with non-group selection fields?

1075

How to assign a tablespace to a users in oracle?

1100

WHAT ALL DIFFERENT KIND OF FUNCTIONS AVAILABLE WHILE DESIGN UNIVERSES?

2165

What are the numeric comparison operations?

1171

How do I start tns listener?

1099

How to drop a stored procedure in oracle?

1113

What is main function of database administrator?

616

List five most important parameter in 9i affecting performance?

610

What are operators in oracle?

1107

Typically, where is the conventional directory structure chosen for Oracle binaries to reside?

2198

What is a nvl function?

1099

What is an artificial (derived) primary key? When should an artificial (or derived) primary key be used?

661

How to use subqueries with the in operator using oracle?

1144

How to display employee records who gets more salary than the average salary in the department?

1128

What are joins, explain all types of joins?

2368

For More Un-Answered { Oracle } Questions Click Here