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?

1097

What are the differences between primary key and unique key?

1057

What is the difference between substr and instr?

1088

Describe varray?

1116

How can you merge two tables in oracle?

1048

How to store pictures on to the database?

1030

Explain temporal data types in oracle

1133

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

1091

Does rowid change in oracle?

1 1483

Is rowid unique in oracle?

1043

Is primary key indexed by default in oracle?

1048

What are triggers in oracle?

1096

What is max rowid in oracle?

1081

What is oracle rowcount?

1143

What is oracle rownum?

1016

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

How to use subqueries in the from clause in oracle?

1165

List out the components of logical database structure of oracle database.

1092

What is dynamic proxy?

1049

What is recovery manager in Oracle?

1108

How to use "out" parameter properly?

1123

Difference between varchar and varchar2 data types?

1259

Is it possible to split the print reviewer into more than one region ?

2338

Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).

2365

What is the difference between $oracle_base and $oracle_home?

1136

how do u setup a replication site?

2031

How to run create database statement?

1075

please explain.. DB architecture ...

2081

What privilege is needed for a user to create indexes in oracle?

1078

What happens if the imported table already exists?

1077

What is different types of joins?

1078

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