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?

1016

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?

1268

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

1100

Explain about integrity constraint?

1122

What is literal?

1004

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?

997

What are the attributes of the cursor?

1004

What is raw datatype in oracle?

1135

Un-Answered Questions { Oracle }

How to use "startup" command to start default instance?

1031

What is tns entry?

1151

as a technical developer in oracle applications which type errors feced in your experience sofar

2331

I creat Credit memo in AR. Now i want revers the Credit Memo.how you can revers that what out any aditional entry.

2307

Explain the use of grant option in imp command.

1030

What do you understand by lov?

1037

What suggestions do you have to reduce the network traffic?

961

What does sharding mean?

1000

Explain the difference between $ORACLE_HOME and $ORACLE_BASE.

7671

How to run the anonymous block again?

1132

When configuring sqlnet on the server what files must be set up?

636

How to execute the package in oracle?

1082

Explain the use of show option in imp command.

1098

Explain the dml?

981

Can a Tablespace hold objects from different Schemes in Oracle?

1044

For More Un-Answered { Oracle } Questions Click Here