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 an Oracle SYSTEM tablespace and when is it Created?

1116

What is the use of Oracle Control File?

1074

What are the common oracle dba tasks?

1147

What is the difference between pre-select and pre-query?

1219

What is raw datatype?

1136

What is a subquery?

1122

Explain coalesce function?

1202

What is a package ? What are the advantages of package ?

1091

Will you be able to store pictures in the database?

1121

Whether any commands are used for months calculation? If so, what are they?

1097

What is difference between truncate and delete?

1040

What are the benefits of ordbms?

1088

What is a oracle database?

1055

What are the various oracle database objects?

1144

Explain the characteristics of oracle dba?

1120

Un-Answered Questions { Oracle }

How many types of database triggers exist?

1135

Explain the use of record length option in exp command.

1067

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.

2310

What are the different windows events activated at runtime ?

2900

Difference between negative and positive adjustments : oracle accounts receivable

1104

A table t is there.If you perform insert ,update and delete then the trigger will fire.What is the minimum no of trigger required for a table.

5551

Why oracle is used?

1058

What are the different editions of oracle?

1108

What Are Cross Validation & Adi?

1157

Mention what are the key characteristics of rac or why to use rac?

What is a static data dictionary in oracle?

1112

Difference between hot backup vs. Cold backup?

991

What would you do with an in-doubt distributed transaction?

1978

What is tkprof?

What is coalesce function?

1072

For More Un-Answered { Oracle } Questions Click Here