Oracle Interview Questions
Questions Answers Views Company eMail

What are the built-ins used for processing rows?

1 5137

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

2 3437

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

2 4433

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

2 7743

What are parameters?

1 3279

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

2 3710

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

1 3062

How do you call other Oracle Products from Oracle Forms?

1 5265

How do you reference a Parameter?

1 3212

How do you reference a parameter indirectly?

1 3345

What are the different Parameter types?

2 3650

When do you use data parameter type?

1 2744

Can you pass data parametrs to forms?

1 3180

What are different types of images?

1 2658

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

1 3385


Un-Answered Questions { Oracle }

Name the three major set of files on disk that compose a database in Oracle?

626


What are a collation and state the different types of collation sensitivity?

545


What is the difference between translate and replace in oracle?

639


Explain the various modes of normalization?

273


What is materialized view in Oracle?

626






How to define an anonymous procedure without variables?

542


Why cursor variables are easier to use than cursors?

562


State all possible different index configurations a table can possibly have?

558


How to create a single index for multiple columns?

553


Explain the use of analyse option in exp command.

584


How many categories of data types?

568


What is a private synonym?

1074


Discuss row chaining, how does it happen? How can you reduce it?

288


Can a View based on another View in Oracle?

644


How many types of auditing in Oracle?

559