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 are pseudocolumns?

4 10954

what is the use of composite key constraint?

2 8550

what is a cartition product?

4 11656

what is the use of ondelete cascade?

3 8357

what is cartesian product?

2 8192

What is the difference between column level constraints and table level constraints?

IBM, TCS,

14 87500

Can we create index on views?

CTS, Syntel, TCS,

19 125912

Can we create more than one index on particular column?

1 6363

What is a cluster?

2 5702

What is the difference between implicit index and explicit index?

TCS,

2 24179

What are virtual columns?

TCS,

2 7252

What is a materialised view?

5 8666

What is the difference between normal and corelated subqueries?

2 9864

What is a Database instance ? Explain?

3 8262

What is Parallel Server ?

3 5844

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

What is data block in Oracle?

1116

Explain rename?

981

What is the difference difference between $ORACLE_HOME and $ORACLE_BASE.

1109

How to create lov dynamically at runtime & attach to text field?

1197

How to calculate date and time differences in oracle?

1042

How to update values on multiple rows in oracle?

1034

What is difference between cartesian join and cross join?

1088

How to filter out duplications in the returning rows using oracle?

1018

Is oracle a relational database?

916

How to write a left outer join with the where clause in oracle?

1084

How to shutdown your 10g xe server?

1149

interview questions with answer for cts

2583

What is an oracle cursor variable?

1075

How do you store pictures in a database?

1006

What is define in oracle?

1060

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