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 meant by joins?

1023

Can we save images in a database and if yes, how?

1006

What is a view and how is it different from a table?

986

How will you write a query to get a 5th rank student from a table student_report?

1821

What are the different editions of oracle?

1060

What is meant by an index?

1070

What is meant by a deadlock situation?

1063

What is the difference between a primary key & a unique key?

1047

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

1046

What is a nested table and how is it different from a normal table?

997

How is it different from a normal table?

979

How does the on-delete-cascade statement work?

1064

What is meant by joins? List out the types of joins.

969

What do you understand by database schema and what does it hold?

1189

What do you mean by merge in oracle and how can we merge two tables?

1010

Un-Answered Questions { Oracle }

What to do if dba lost the system password?

1104

How to create id with auto_increment on oracle?

946

How to check the server version in oracle?

1050

What is oracle datasource?

932

How do we get field detail of a table?

1031

Why do we use bulk collect in oracle?

1021

What is tns service name?

1088

What is concurrency in oracle?

959

HI ALL, CAN ANYONE TELL ME THE DIFFERENCES BETWEEN SQL CLUSTURS,MSQL CLUSTERS,ORACLE CLUSTERS.......THANKS IN ADVANCE

2197

What database block size should I use?

676

List out the types of joins.

1094

What is oracle in java?

921

What do you mean by redo log file mirroring?

983

What is the difference between translate and replace in oracle?

1124

What are the restrictions on external table columns?

1002

For More Un-Answered { Oracle } Questions Click Here