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

Is oracle a programming language?

1043

Is truncate autocommit in oracle?

1155

Why we use bulk collect in oracle?

1121

What is procedure overloading in oracle?

1118

Is oracle a language?

994

How do you bind variables in oracle?

1024

Is insert autocommit in oracle?

1134

What is data type in oracle?

1189

Why packages are used in oracle?

1124

Can we commit inside a function in oracle?

1016

What is a schema in oracle?

1067

What is bulk load in oracle?

1133

What happens in oracle commit?

1082

What are operators in oracle?

1105

What is bind variable in oracle 11g?

1097

Un-Answered Questions { Oracle }

What do you understand by lov and how can it be used?

1155

What privilege is needed for a user to insert rows to tables in another schema?

1064

What do you understand by the term 'normalization'? Explain the various modes of normalization?

598

What are the different tools available for hot backups in Oracle? Is it preferable to take it manually all the time or it depends on the size of the database?

1437

Discuss row chaining, how does it happen?

621

What privilege is needed for a user to create views in oracle?

1098

What is a proxy class?

1109

Give the different types of rollback segments.

1084

What is the load plans in odi?

690

What is the purpose of the import option ignore? What is its default setting?

642

Where do we use connected and un connected lookups?

In workflow how can we send a notification to the Supplier giving the Corresponding report Details.

1965

What do we mean by record group in oracle forms?

1135

What is the page protect in reports?

Explain about functional dependency and its relation with table design?

1063

For More Un-Answered { Oracle } Questions Click Here