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

Oracle General Interview Questions

Questions Answers Views Company eMail

Describe an oracle table?

989

What are the differences between primary key and unique key?

949

What is the difference between substr and instr?

980

Describe varray?

1007

How can you merge two tables in oracle?

939

How to store pictures on to the database?

923

Explain temporal data types in oracle

1044

List out the difference between commit, rollback, and savepoint?

987

Does rowid change in oracle?

1 1313

Is rowid unique in oracle?

939

Is primary key indexed by default in oracle?

931

What are triggers in oracle?

978

What is max rowid in oracle?

966

What is oracle rowcount?

1037

What is oracle rownum?

889

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

What is SQL Tuning Advisor in Oracle?

1109

How to connect to the server with user account: sys?

971

Explain the use of indexes option in exp command.

1066

How to load data through external tables?

1074

What is difference between truncate and delete?

977

What is the difference between view and materialized view in Oracle?

1094

What is logical backup in oracle?

969

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

2251

How do you find current date and time in oracle?

990

22. Display the order number, number of lines in the order, total number of items and total value for all orders that have a total value greater than $100

1957

How to rename an existing table?

1052

What is oracle analytical function?

1032

What is difference between sid and service name in oracle?

905

How to run the anonymous block again?

1066

What is data file?

1046

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