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 53363

what is the use of rank function?

1 6303

How many different types of indexes we have in oracle?

IBM, TCS,

24 192684

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 125911

Can we create more than one index on particular column?

1 6362

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

Un-Answered Questions { Oracle }

What is a sub query and what are the different types of subqueries?

1125

What are the skills required for oracle dba?

652

Explain the different types of queries created in reports?

Where would you look to find out if a redo log was corrupted assuming you are using oracle mirrored redo logs?

526

What do you understand by oracle forms?

1041

What is an oracle cursor variable?

1075

What is a read write transaction in oracle?

1093

while creating requisitions i am unable to see the list of organisation can anyone help me out ?

2135

When do you get a .pll extension in oracle?

1146

Can objects of the same schema reside in different tablespace?

1062

How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?

1916

What is the simplest tool to run commands on oracle servers?

1009

How do you run ms_batch file in forms?

Why do we need a database?

595

Do you know table based value sets?

For More Un-Answered { Oracle } Questions Click Here