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 7211

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

2 7758

Describe the different type of Integrity Constraints supported by ORACLE ?

2 8152

What is difference between UNIQUE constraint and PRIMARY KEY constraint ?

3 7362

Describe Referential Integrity ?

1 5325

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

1 5607

What is self-referential integrity constraint ?

SunGard,

2 14531

What are the Limitations of a CHECK Constraint ?

5 19313

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

3 9099

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

MBT,

36 60157

what are the disadvantages of hierarchial database over RDBMS?

TCS,

1 12999

Can we create more than one constraint to column ?

6 11106

what is the difference between simple view and complex view?

13 53349

what is the use of rank function?

1 6303

How many different types of indexes we have in oracle?

IBM, TCS,

24 192672

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

Can we create database in oracle using command line ?

1085

What is partitioned table in Oracle?

1188

What are advantages of dateset in datastage?

2263

How to start a new transaction in oracle?

1087

What is data file?

1103

Explain an exception and its types?

1073

what's query optimization and without use of IN AND Exist can we get another way data from query

2141

How to convert times to characters in oracle?

1027

What to do if the binary spfile is wrong for the default instance?

1069

Give syntax for SQL and ORACLE joins.

1092

What is execute immediate in oracle?

1021

What is instant client oracle?

1019

Which is faster join or subquery in oracle?

995

what are the default admin accounts in Oracle 10g ?

967

How are extents allocated to a segment?

1125

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