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

How do I reset a sequence in oracle?

1098

Why do I get java.lang.abstractmethoderror when trying to load a blob in the db?

1015

Calculate difference between 2 date / times in oracle sql?

1040

How to create id with auto_increment on oracle?

990

How to create a temporary table in oracle?

1267

Difference between oracle's plus (+) notation and ansi join notation?

1100

Explain about integrity constraint?

1122

What is literal?

1003

What are the uses of a database trigger?

994

Name the various constraints used in oracle?

1019

Where do you use decode and case statements?

993

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

1015

Describe the types of sub query?

993

What are the attributes of the cursor?

1003

What is raw datatype in oracle?

1134

Un-Answered Questions { Oracle }

How do I connect to oracle database?

1115

System tablespace cant be exported from one database and imported into another why?

555

What is the Difference between the Person_Type_id column in the per_all_people_f and per_person_type_usages_f

4446

1) WIll all the user get the DEFAULT profile, if their current profile got deleted at any point of time? 2) What are the Situation we need to MOVE the TABLE between T.spaces? 3) What is the use of MOVING the TABLE between SCHEMA'S? 4) What are the Table Clause, Segment Clause and the Datafile Clause which will override each other? 5) Explain SORT_AREA_SIZE of Tempfile to make UNIFORM SIZE

1970

What are the attributes of cursor?

1054

What happens internally when the user types userID/password@string in SQL PLUS Thanks-Bhaskar

4585

Explain the use of decode function

What is flexfileds and use of flexfileds in odi?

567

Design database draw er diagram for a certain scenario ?

4579

What does the no logging option do? Why would we be careful of using it?

601

I have a database backup file in .db (ext) form how to conver it into .dmp (ext.) for oracle database

2136

if i want to change the functionality of a item in report during runtime how like what do u write in when_button_pressed

1890

How can you determine if an index needs to be dropped and rebuilt?

563

What is a dead lock in oracle?

1121

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

1906

For More Un-Answered { Oracle } Questions Click Here