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?

1064

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

968

Calculate difference between 2 date / times in oracle sql?

998

How to create id with auto_increment on oracle?

949

How to create a temporary table in oracle?

1210

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

1046

Explain about integrity constraint?

1089

What is literal?

960

What are the uses of a database trigger?

942

Name the various constraints used in oracle?

982

Where do you use decode and case statements?

953

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

970

Describe the types of sub query?

950

What are the attributes of the cursor?

948

What is raw datatype in oracle?

1068

Un-Answered Questions { Oracle }

Can multiple columns be used in group by in oracle?

942

How can you find dead processes?

511

How to initialize variables with default values?

1179

How should a many-to-many relationship be handled?

511

How a database is related to tablespaces?

995

does odi support web services?

533

What is the difference between $oracle_base and $oracle_home?

1047

Can a parameter be passed to a cursor?

1062

Hi this srilatha. I comlpeted my Oracle-hrms. can u provide me interview questions on Core hr, payroll,sshr,OLM etc..

2074

What are data pump export and import modes?

1025

How many databases should a dba manage?

610

What are the differences between interval year to month and interval day to second?

971

What is the usage of synonyms?

1075

If you see contention for library caches how you can fix it?

522

What is a database table in oracle?

973

For More Un-Answered { Oracle } Questions Click Here