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

1227

List out the types of joins.

1158

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

1064

What is a nested table?

1058

How view is different from a table?

1035

What do you understand by a database object?

1062

What is meant by raw datatype?

1060

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

1035

Where do we use decode and case statements?

1012

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

1046

What is the difference between truncate & delete command?

1182

How will you identify oracle database software release?

1010

What are the attributes that are found in a cursor?

1076

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

1018

What is a nvl function?

1032

Un-Answered Questions { Oracle }

What is snapshot is too old? Give and example for better understand.

1603

What is an anonymous block?

1250

What are property classes?

How to omit columns with default values in insert statement in oracle?

1046

What is key preserved table?

1021

How is rman better than user-managed backup recovery process?

What is ODI console?

671

What are referenced objects? Explain the importance of referencing.

can anyody please send me the dump for Oracle 10g certifications for DBA path?

2122

What do you mean by redo log file mirroring?

1032

How to test null values?

1106

An automatic job running via DBMS_JOB has failedKnowing only that its failed, how do you approach troubleshooting this issue?

2051

How do I manually uninstall oracle client?

1087

What is a cursor and what are the steps need to be taken?

1202

What are summary column and placeholder column in reports?

For More Un-Answered { Oracle } Questions Click Here