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 10939

what is the use of composite key constraint?

2 8547

what is a cartition product?

4 11644

what is the use of ondelete cascade?

3 8353

what is cartesian product?

2 8186

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

IBM, TCS,

14 87465

Can we create index on views?

CTS, Syntel, TCS,

19 125870

Can we create more than one index on particular column?

1 6352

What is a cluster?

2 5692

What is the difference between implicit index and explicit index?

TCS,

2 24169

What are virtual columns?

TCS,

2 7241

What is a materialised view?

5 8658

What is the difference between normal and corelated subqueries?

2 9856

What is a Database instance ? Explain?

3 8250

What is Parallel Server ?

3 5831

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

What are the differences between lov and list item?

1063

Explain the use of parfile option in exp command.

1064

How to use group functions in the select clause using oracle?

1069

Difference between oracle's plus (+) notation and ansi join notation?

1098

what is insert all statement in sql

6507

How to define an external table with a text file?

1062

What is an index associated with a constraint?

1035

What is integrity and what is constraint??Explain with example

2280

What is oracle server autotrace in oracle?

1159

What is an oracle table?

986

How to save query output to a local file?

1023

how can we store any pdf file in oracle

2162

How to specify default values in insert statement using oracle?

1102

what is the scenario where you take the database to NoArchivelog mode?

2325

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

1083

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