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?

966

What exactly do quotation marks around the table name do?

918

How to do paging with oracle?

951

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

1103

How do I reset a sequence in oracle?

1054

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

955

Calculate difference between 2 date / times in oracle sql?

988

How to create id with auto_increment on oracle?

938

How to create a temporary table in oracle?

1197

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

1034

Explain about integrity constraint?

1082

What is literal?

960

What are the uses of a database trigger?

931

Name the various constraints used in oracle?

974

Where do you use decode and case statements?

945

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

What is oracle latest version?

1041

How to shutdown your 10g xe server from command line?

1016

What is the difference between sharding and replication?

960

Can we save images in a database and if yes, how?

1003

What are the common oracle dba tasks?

1072

Why do we need oracle client?

891

How to convert characters to numbers in oracle?

1001

how the indexes are stored in the Oracle Database?

2214

What is the difference between a primary key & a unique key?

1043

How to create tables for odbc connection testing?

1011

What privilege is needed for a user to connect to oracle server?

943

What is ordinary table in oracle?

1079

How to retrieve values from data fields in record variables?

1036

Difference between open_form and call_form in oracle.

1094

How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?

1847

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