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?

1115

What is the use of Oracle Control File?

1073

What are the common oracle dba tasks?

1145

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

1216

What is raw datatype?

1136

What is a subquery?

1121

Explain coalesce function?

1201

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 }

Tell me some differences between ODI 10g and ODI 11g?

563

What is a named program unit?

1075

How to write a query with a left outer join in oracle?

1062

What is table partitioning and why is it required?

what is the use of triggers in Java program? I mean where do we use triggers in Java programming?

2183

Explain the blob datatype?

1071

List out the difference between commit, rollback, and savepoint?

1031

What is a Garbage Collection? and what is full recursive Garbage collection?

2901

How to move objects from DEV to QA and QA to PROD Environments?

710

What are named parameters?

1089

How do I escape a reserved word in oracle?

1197

If you see a pin hit ratio of less than 0.8 in the estat library cache report is this a problem? If so, how do you fix it?

1193

How to create a table index in oracle?

1133

How to fetch the row which has the max value for a column?

1000

What is the mandatory setup in cyclecount ?

2749

For More Un-Answered { Oracle } Questions Click Here