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 7341

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

2 7928

Describe the different type of Integrity Constraints supported by ORACLE ?

2 8246

What is difference between UNIQUE constraint and PRIMARY KEY constraint ?

3 7508

Describe Referential Integrity ?

1 5417

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

1 5676

What is self-referential integrity constraint ?

SunGard,

2 14656

What are the Limitations of a CHECK Constraint ?

5 19486

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

3 9233

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

MBT,

36 61246

what are the disadvantages of hierarchial database over RDBMS?

TCS,

1 13096

Can we create more than one constraint to column ?

6 11317

what is the difference between simple view and complex view?

13 53772

what is the use of rank function?

1 6394

How many different types of indexes we have in oracle?

IBM, TCS,

24 193414

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

What is a nested table?

1111

What is a connect identifier?

1086

What are the oracle built-in data types?

1138

What is a static data dictionary in oracle?

1192

what is difference between sql plus and sql*plus? (not sql and sql plus).

3943

How to export data with a field delimiter?

1088

Write a syntax for update query in oracle?

1076

How to get a create statement for an existing table?

1016

How to get a list of all background sessions in the database?

1040

What are the different types of modules in oracle forms?

1050

Explain the blob datatype?

1125

What is set operator oracle?

1036

I creat Credit memo in AR. Now i want revers the Credit Memo.how you can revers that what out any aditional entry.

2344

Is primary key indexed by default in oracle?

1049

How to start your 10g xe server?

1089

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