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 11133

what is the use of composite key constraint?

2 8634

what is a cartition product?

4 11818

what is the use of ondelete cascade?

3 8467

what is cartesian product?

2 8286

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

IBM, TCS,

14 88045

Can we create index on views?

CTS, Syntel, TCS,

19 126539

Can we create more than one index on particular column?

1 6446

What is a cluster?

2 5811

What is the difference between implicit index and explicit index?

TCS,

2 24307

What are virtual columns?

TCS,

2 7412

What is a materialised view?

5 8850

What is the difference between normal and corelated subqueries?

2 9965

What is a Database instance ? Explain?

3 8405

What is Parallel Server ?

3 5970

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

How to drop an existing view in oracle?

995

What is clustered table in Oracle?

1263

can u send the sql dumps to sivakumarr1987@gmail.com plz help me

3103

What are a collation and state the different types of collation sensitivity?

1251

Calculate difference between 2 date / times in oracle sql?

1100

What are the differences between lov and list item?

1148

What are the differences between interval year to month and interval day to second?

1070

How to increment dates by 1 in oracle?

1139

22. Display the order number, number of lines in the order, total number of items and total value for all orders that have a total value greater than $100

2082

How to save query output to a local file?

1089

State and explain the different types of data models?

999

What are the advantages of oracle?

1076

What is the usage of merge statement?

1210

Explain about integrity constraint?

1182

There are n numbers of flatfile of exactly same format are placed in a folder.Can we load these flatfile's data one by one to a single relational table by a single session??

2085

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