Oracle General Interview Questions
Questions Answers Views Company eMail

what are pseudocolumns?

4 9189

what is the use of composite key constraint?

2 7516

what is a cartition product?

4 10062

what is the use of ondelete cascade?

3 7223

what is cartesian product?

2 7344

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

IBM, TCS,

14 82778

Can we create index on views?

CTS, Syntel, TCS,

19 119965

Can we create more than one index on particular column?

1 5605

What is a cluster?

2 4816

What is the difference between implicit index and explicit index?

TCS,

2 22704

What are virtual columns?

TCS,

2 5580

What is a materialised view?

5 7084

What is the difference between normal and corelated subqueries?

2 8700

What is a Database instance ? Explain?

3 6936

What is Parallel Server ?

3 4526


Post New Oracle General Questions

Un-Answered Questions { Oracle General }

Explain the use of inctype option in exp command.

578


How can I combine multiple rows into a comma-delimited list in oracle?

567


Explain oracle insert into command?

614


Is truncate autocommit in oracle?

616


Explain oracle data types with examples?

566






How to end the current transaction in oracle?

541


What is a database table in oracle?

556


How to shutdown your 10g xe server from command line?

543


Difference between inner join vs where ?

596


What is blob datatype?

554


What is an Oracle index?

1163


Can we write insert statement in function in oracle?

520


How to estimate disk space needed for an export job?

550


Please explain me all types of Data models. Also give me the details if each model can have other name.for example:schematic data model is also known as conceptual data model and entity relation data model.

1857


What the is the diff between local index and global index. give some example.

1119