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.

1036

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.

1080

What is a synonym? What are its various types?

1110

Explain the use of owner option in exp command.

1041

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?

996

Un-Answered Questions { Oracle }

What to do if dba lost the system password?

1172

IS IT POSSIBLE TO CREATE REPORTS FROM DIFFERENT UNIVERSES IN ONE DOCUMENT?

2258

What are the limitations of check constraint?

1033

What is the dba role in oracle?

577

normally database take to refresh time 2 hours. but client asked iwant to refresh with in 5 min that same database. do you have any option in BO and Oracle? explain me briefly...kavi

2204

Whats the benefit of dbms_stats over analyze?

2001

what the 'lov of validation' property of an item? Mention what is the difference between lov and list item?

1023

What query tells you how much space a tablespace named test is taking up, and how much space is remaining?

2275

What is oracle d2k?

How to pass a parameter to a cursor in oracle?

1178

Can multiple columns be used in group by in oracle?

988

What is MTTR advisor in Oracle?

1090

How to delete multiple rows from a table in oracle?

1060

Difference between ETL and E_LT?

593

What is a view and how is it different from a table?

1045

For More Un-Answered { Oracle } Questions Click Here