Oracle General Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Oracle General Interview Questions

Questions Answers Views Company eMail

How do I spool to a csv formatted file using sqlplus?

1034

What exactly do quotation marks around the table name do?

963

How to do paging with oracle?

1000

How do I limit the number of rows returned by an oracle query after ordering?

1170

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?

1019

Calculate difference between 2 date / times in oracle sql?

1041

How to create id with auto_increment on oracle?

990

How to create a temporary table in oracle?

1270

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

1105

Explain about integrity constraint?

1124

What is literal?

1007

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

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

How to write date and time literals in oracle?

1002

What is a package ? What are the advantages of package ?

1092

What is set operator oracle?

980

What is a nvl function? How can it be used?

1032

what is the dual table in oracle?

993

What is Reduced List of Values?

2167

How do you bind variables in oracle?

980

Explain an extent?

1105

How does oracle handle read consistency?

1097

What is oracle database client?

1033

How to retrieve data from an explicit cursor?

1059

What are the ansi data types supported in oracle?

947

What would you do with an in-doubt distributed transaction?

1980

20. Using a set operator, display the client number of all clients who have never placed an order.

2187

You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?

2008

For More Un-Answered { Oracle General } Questions Click Here