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

Oracle General (1803)
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?

1169

What is the use of Oracle Control File?

1118

What are the common oracle dba tasks?

1205

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

1307

What is raw datatype?

1193

What is a subquery?

1198

Explain coalesce function?

1255

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

1141

Will you be able to store pictures in the database?

1178

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

1144

What is difference between truncate and delete?

1100

What are the benefits of ordbms?

1141

What is a oracle database?

1111

What are the various oracle database objects?

1204

Explain the characteristics of oracle dba?

1180

Un-Answered Questions { Oracle }

What if your ocr (oracle cluster registry) is corrupted?

how do we code triggers , store procedure , Performance tuning and indexing in a Java Project? Pls kindly get me the perfect answer with the code for each....thank you in advance............pls any body kindly help me soon as possible....

2119

How to define a variable to match a table column data type?

1040

What are the various tools? - Name a few?

Is oracle a programming language?

1043

What is blob data type in oracle?

1210

What is the difference between BPA AND Contract What are documents and test cases u followed

2441

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.

2369

Which process writes data from data files to database buffer cache?

643

What is the difference between the Oracle ODBC driver and a Microsoft ODBC (Open Database Connectivity) Driver?

1170

How to create lov dynamically at runtime & attach to text field?

1241

Hi friends can u send the oracle 9i full version download link?????????????? please reply ?

1930

How to upsert (update or insert into a table)?

1044

How do you recover a lost control file?

What is data block in Oracle?

1155

For More Un-Answered { Oracle } Questions Click Here