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?

1049

What are the differences between primary key and unique key?

1010

What is the difference between substr and instr?

1037

Describe varray?

1057

How can you merge two tables in oracle?

1001

How to store pictures on to the database?

974

Explain temporal data types in oracle

1095

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

1031

Does rowid change in oracle?

1 1392

Is rowid unique in oracle?

998

Is primary key indexed by default in oracle?

987

What are triggers in oracle?

1036

What is max rowid in oracle?

1025

What is oracle rowcount?

1084

What is oracle rownum?

951

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

What is bulk collect in oracle?

996

How to use "in out" parameter properly?

1046

Why do we use bulk collect in oracle?

1058

What is where clause in oracle?

1026

In Oracle Clinical 4.5.0, can the VIEW_TEMPLATE_ID column in DATA_EXTRACT_VIEWS table contain NULL value?

2341

What is Java Pool in Oracle?

1168

How to insert multiple rows with one insert statement in oracle?

1085

How to unlock the sample user account in oracle?

1016

How to load data through external tables?

1135

How many data types are supported?

1079

Explain what are the uses of rollback segment?

1013

What suggestions do you have to reduce the network traffic?

961

What is a partition in oracle?

1121

how can db_files > maxdatafiles since db_files is for instance and the later is for database

2622

Explain the use of ignore option in imp command.

1035

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