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 a trigger and what are its types?

1332

List out the types of joins.

1243

What are the parameters that we can pass through a stored procedure?

1121

What is a nested table?

1113

How view is different from a table?

1092

What do you understand by a database object?

1109

What is meant by raw datatype?

1121

When do we use group by clause in a sql query?

1101

Where do we use decode and case statements?

1063

How can we find out the duplicate values in an oracle table?

1126

What is the difference between truncate & delete command?

1238

How will you identify oracle database software release?

1060

What are the attributes that are found in a cursor?

1125

What do you understand by a database object? Can you list a few of them?

1068

What is a nvl function?

1097

Un-Answered Questions { Oracle }

What is private procedure oracle?

1052

Explain the various types of oracle report?

1138

What is table partitioning and why is it required?

What is SQL access advisor in Oracle?

1232

Explain the wait events in statspack report 'enqueue'?

622

What is memo?

681

How to write an inner join with the where clause in oracle?

1095

hello friends Im doing my final year engineering in B.Tech.. one of uncle said he can provide job in his company if im good in database management. but i have only basic knowledge about database, so like to join database management course in good intuition. so friends kindly help me to get good intuition because its my future.

2322

How will you run ms_batch file in forms?

How do you install statspack?

725

How can we find out the current date and time in oracle?

1134

Explain how to close periods in ar. : oracle accounts receivable

1381

Her departmandaki isçilerden empno' su ikinci sirada olan isçilerin empno, deptno, hiredate, sira_no bigilerini döndüren sorguyu yaziniz?

2048

What is secure property?

What is the difference between substr & instr functions?

1297

For More Un-Answered { Oracle } Questions Click Here