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 are the built-ins used for processing rows?

1 5893

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

2 4428

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

2 5432

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

2 8763

What are parameters?

1 4126

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

2 4739

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

1 3715

How do you call other Oracle Products from Oracle Forms?

1 5990

How do you reference a Parameter?

1 4088

How do you reference a parameter indirectly?

1 4092

What are the different Parameter types?

2 4719

When do you use data parameter type?

1 3524

Can you pass data parametrs to forms?

1 4043

What are different types of images?

1 3424

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

1 4218

Un-Answered Questions { Oracle }

Why do we use materialized view instead of table or views?

How to use "if" statements on multiple conditions?

1178

How does oracle handle read consistency?

1102

various types of hints and their usage

2704

What is an oracle transaction?

1155

Explain alias?

1154

explain what is odi?why is it different from the other etl tools.

622

How can you determine if the sqlnet process is running for sqlnet v1? How about v2?

590

How to end the current transaction in oracle?

1038

How can you find out how many users are currently logged into the database? How can you find their operating system id?

548

How to add a new column to an existing table with a default value?

1019

What is the data quality in odi?

650

What is Segment Advisor in Oracle?

1109

Why is cluster verification utility so important in oracle rac?

What are the constraints are used in Ur project?

554

For More Un-Answered { Oracle } Questions Click Here