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 varoius components of physical database structure of oracle database?

1006

Explain the use of online redo log files in oracle.

1037

Explain the use of grant option in exp command.

1063

What is a sub query? What are its various types?

1179

Explain enable novalidate constraint.

1081

What is a synonym? What are its various types?

1110

Explain the use of owner option in exp command.

1043

Explain integrity constraints?

1104

What do you mean by a deadlock?

1065

Will you be able to store pictures in the database?explain.

992

Explain the function of optimizer in oracle?

1143

What are the uses of synonyms?

1138

Explain the use of record option in exp command.

1006

Explain the use of analyse option in exp command.

1128

List the types of joins used in writing subqueries?

997

Un-Answered Questions { Oracle }

How to use null as conditions in oracle?

1084

What are the various constraints used in oracle?

1045

What is the difference between hot backup and cold backup in oracle?

1014

What is StandAlone Agent and default port number?

699

What is File steps?

619

How to calculate date and time differences in oracle?

1042

What is an oracle cursor variable?

1075

How can we collect the statistics of different database objects?

What are the restrictions on external table columns?

1052

What is the difference between recovery and restoring of the oracle database?

1222

default triggers available for reports

2211

What are the Types of repositories in ODI?

584

What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?

2131

What is the difference between a user and a schema in oracle?

1034

Explain the use of indexes option in imp command.

1179

For More Un-Answered { Oracle } Questions Click Here