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

Oracle General Interview Questions

Questions Answers Views Company eMail

What is the difference between substr & instr functions?

1123

What is meant by joins?

1015

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

1002

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

972

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

1814

What are the different editions of oracle?

1049

What is meant by an index?

1059

What is meant by a deadlock situation?

1053

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

1041

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

1037

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

988

How is it different from a normal table?

968

How does the on-delete-cascade statement work?

1061

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

959

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

1179

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

What is recycle bin in Oracle?

1086

How to create a temporary table in oracle?

1194

What is Segment Advisor in Oracle?

1051

Explain the difference between a procedure and a function? What do you understand by those terms?

1023

Explain the use of control file?

1061

Can we write dml statement in function in oracle?

1026

What are the arithmetic operations?

1026

How to get maxsal , minsal, ename department wise in single query

1501

How does the on-delete-cascade statement work?

1061

When system tablespace is created?

972

What is bulk collect in oracle?

958

What is the difference between sharding and replication?

956

How to open and close an explicit cursor in oracle?

1001

What is oracle database 10g express edition?

1075

What is object data modeling?

907

For More Un-Answered { Oracle General } Questions Click Here