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

1043

Explain the use of online redo log files in oracle.

1085

Explain the use of grant option in exp command.

1113

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

1283

Explain enable novalidate constraint.

1138

What is a synonym? What are its various types?

1179

Explain the use of owner option in exp command.

1104

Explain integrity constraints?

1161

What do you mean by a deadlock?

1116

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

1041

Explain the function of optimizer in oracle?

1204

What are the uses of synonyms?

1193

Explain the use of record option in exp command.

1069

Explain the use of analyse option in exp command.

1200

List the types of joins used in writing subqueries?

1042

Un-Answered Questions { Oracle }

How many types of cluster table in Oracle?

1084

Can we create trigger on materialized view in oracle?

1047

How do you find out from the RMAN catalog if a particular archive log has been backed-up?

2178

you are a universe designer and report developer in BO, what type of information you gather from client?Briefly explain plz

2002

What is the difference between raid 5 and raid 10? Which is better for oracle?

639

Explain constraining triggers.

1167

does the query needs a hint to access a materialized view?

1910

how to reverse engineer views(how to load the data from views)?

586

what is profile in odi?

703

What is the implicit cursor in oracle?

1175

How to see free space of each tablespace?

1084

What is the function of cache fusion in oracle rac?

What is the difference between $oracle_base and $oracle_home?

1141

What is an Oracle index?

1709

Differentiate between translate and replace?

1197

For More Un-Answered { Oracle } Questions Click Here