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?

1228

What is meant by joins?

1062

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

1065

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

1046

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

1866

What are the different editions of oracle?

1108

What is meant by an index?

1145

What is meant by a deadlock situation?

1109

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

1090

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

1090

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

1052

How is it different from a normal table?

1032

How does the on-delete-cascade statement work?

1104

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

1031

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

1230

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

How to use select statement to count the number of rows in oracle?

1046

How to define a specific record type?

1084

How to pass parameters to procedures?

1034

What is the difference between PFILE and SPFILE in Oracle?

1060

Compare and contrast between sql and sql server and explain its various functions?

964

How to use subqueries in the from clause in oracle?

1113

20. Using a set operator, display the client number of all clients who have never placed an order.

2187

How to convert csv to table in oracle?

991

Explain an exception?

999

What are a collation and state the different types of collation sensitivity?

1170

What is format trigger?

2073

How do we get field detail of a table?

1081

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

1046

How to define a sub function?

1133

How to install oracle database 10g xe?

1020

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