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

Oracle General Interview Questions

Questions Answers Views Company eMail

What is an Integrity Constrains ?

3 7352

Can an Integrity Constraint be enforced on a table if some existing table data does not satisfy the constraint ?

2 7934

Describe the different type of Integrity Constraints supported by ORACLE ?

2 8249

What is difference between UNIQUE constraint and PRIMARY KEY constraint ?

3 7512

Describe Referential Integrity ?

1 5423

What are the Referential actions supported by FOREIGN KEY integrity constraint ?

1 5676

What is self-referential integrity constraint ?

SunGard,

2 14658

What are the Limitations of a CHECK Constraint ?

5 19497

What is the maximum number of CHECK constraints that can be defined on a column ?

3 9236

In Oracle 9i what does "i" Stands for?

MBT,

36 61280

what are the disadvantages of hierarchial database over RDBMS?

TCS,

1 13101

Can we create more than one constraint to column ?

6 11321

what is the difference between simple view and complex view?

13 53778

what is the use of rank function?

1 6396

How many different types of indexes we have in oracle?

IBM, TCS,

24 193484

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

What is enter substitution variable in oracle?

1099

What is difference between cartesian join and cross join?

1161

What is the use of file param in imp command?

1221

What is the difference between pre-select and pre-query?

1307

What do you understand by a database object? Can you list a few of them?

1068

What is the usage of analyze command in oracle?

1146

Explain a data segment?

1112

What are operators in oracle?

1105

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

2675

What are the attributes of cursor?

1111

How many types of cluster table in Oracle?

1084

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

1136

How to unlock the sample user account in oracle?

1079

Is primary key indexed by default in oracle?

1055

What is raw datatype in oracle?

1214

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