Oracle Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Oracle General (1809)
Oracle DBA (Database Administration) (261)
Oracle Call Interface (OCI) (10)
Oracle Architecture (90)

Oracle Interview Questions

Questions Answers Views Company eMail

what is the difference between simple view and complex view?

13 53381

what is the use of rank function?

1 6303

How many different types of indexes we have in oracle?

IBM, TCS,

24 192698

what are pseudocolumns?

4 10957

what is the use of composite key constraint?

2 8551

what is a cartition product?

4 11659

what is the use of ondelete cascade?

3 8358

what is cartesian product?

2 8194

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

IBM, TCS,

14 87510

Can we create index on views?

CTS, Syntel, TCS,

19 125923

Can we create more than one index on particular column?

1 6368

What is a cluster?

2 5705

What is the difference between implicit index and explicit index?

TCS,

2 24181

What are virtual columns?

TCS,

2 7255

What is a materialised view?

5 8668

Un-Answered Questions { Oracle }

What is the best way to do multi-row insert in oracle?

1067

How to enter a new row into a table interactively?

1014

How to create a table in a specific tablespace?

976

What is the difference between PFILE and SPFILE in Oracle?

1061

I have a parent program and a child program. I want to write a statement in Exception Block of the parent program so that when the statement in the exception block is executed, the control goes to the next statement in the parent block bypassing the child block.How do i do that?

2461

What is your favorite tool for day-to-day oracle operation?

548

You are getting busy buffer waits. Is this bad? How can you find what is causing it?

537

What is system global area (sga) in oracle?

992

How to resolve the ORA-39133 error in Oracle?

1122

What are the differences between char and varchar2 in oracle?

1172

Can group functions be used in the order by clause in oracle?

999

how to replace not in with not exist?

3739

What do you understand by the term 'normalization'?

673

a text item is there what r the different types of triggers associated with it

2016

Please explain oracle data types with examples?

1074

For More Un-Answered { Oracle } Questions Click Here