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

How do I reset a sequence in oracle?

1159

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

1072

Calculate difference between 2 date / times in oracle sql?

1102

How to create id with auto_increment on oracle?

1045

How to create a temporary table in oracle?

1337

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

1160

Explain about integrity constraint?

1182

What is literal?

1066

What are the uses of a database trigger?

1043

Name the various constraints used in oracle?

1082

Where do you use decode and case statements?

1047

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

1080

Describe the types of sub query?

1060

What are the attributes of the cursor?

1061

What is raw datatype in oracle?

1215

Un-Answered Questions { Oracle }

Give the various rollback segment states.

1092

Mention what are the benefits of oracle rac?

What is key.next.item trigger?

WHEN CURSOR MOVES FROM ONE FORM TO ANOTHER FORM, HOW MANY TRIGGER WILL BE FIRED AND WHAT ARE THEIR SEQUENCE?

2364

What exactly does a dba do?

625

What is the easiest method to create a file on unix?

613

What is current record attribute property?

What is query image?

1023

Give the advantages and disadvantages of clusters.

1103

In what script is snap$ created? In what script is the scott/tiger schema created?

2763

How can we view last record added to a table?

1110

How to drop an oracle database?

606

Why do you use stored procedures and state some of its disadvantages?

1080

What are the restrictions on external table columns?

1116

What is procedure overloading in oracle?

1118

For More Un-Answered { Oracle } Questions Click Here