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?

950

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

1102

How do I reset a sequence in oracle?

1053

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

953

Calculate difference between 2 date / times in oracle sql?

987

How to create id with auto_increment on oracle?

936

How to create a temporary table in oracle?

1195

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

1034

Explain about integrity constraint?

1079

What is literal?

957

What are the uses of a database trigger?

931

Name the various constraints used in oracle?

971

Where do you use decode and case statements?

945

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?

2078

What is the difference between hot backup and cold backup in oracle? Tell about their benefits also.

919

what is the scripts in data base?

2080

What are set operators?

1033

How to invoke the data pump export utility?

1117

How do I reset a sequence in oracle?

1053

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

960

What is format trigger?

2016

How do you bind variables in oracle?

931

What is the quickest way to export a table to a flat file?

920

How to display row numbers with the records?

1025

Using the relations and the rules set out in the notes under each relation, write statements to create the two sequence generators specified in the notes.

2048

What is an oracle wallet?

882

Explain temporal data types in oracle

1044

What is Library Cache in Oracle?

1077

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