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

Explain can a view based on another view?

1 1519

Explain what are the advantages of views?

1069

Explain what are clusters?

1110

Explain a data segment?

1071

Explain what are the uses of rollback segment?

1016

What is sequence?

1086

Explain what are the characteristics of data files?

1086

Explain how are indexes update?

1065

Explain table?

1118

Explain what are the type of synonyms?

1120

Explain what are synonyms used for?

1035

Explain a segment?

1089

Explain database link?

1126

Explain an integrity constrains?

1150

Explain the use of control file?

1113

Un-Answered Questions { Oracle }

How does oracle handle read consistency?

1098

Can you have more than one content canvas view attached with a window ?

2333

How oracle handles dead locks?

1066

Can I create users through internet explorer in oracle 10g?

1084

What is the usage of merge statement?

1154

Can we call procedure inside function in oracle?

1097

How to pass parameters to procedures in oracle?

1042

How to add another datafile to a tablespace?

1040

What is a junior dba?

621

What kinds of responsibilities does a dba have in a database environment?

606

How to change system global area (sga) in oracle?

1013

what is normalisation?what are its uses?

2273

interview questions with answer for cts

2583

Where are the settings stored for each instance in oracle?

1105

How to sort the query output in oracle?

1028

For More Un-Answered { Oracle } Questions Click Here