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?

1223

What is meant by joins?

1058

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

1061

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

1042

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

1859

What are the different editions of oracle?

1105

What is meant by an index?

1135

What is meant by a deadlock situation?

1107

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

1088

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

1088

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

1044

How is it different from a normal table?

1028

How does the on-delete-cascade statement work?

1100

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

1023

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

1230

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

Explain implicit cursor.

1022

what are the default admin accounts in Oracle 10g ?

964

If a parameter is used in a query without being previously defined, what diff. exist betw. report 2.0 and 2.5 when the query is applied ?

2290

What is java oracle used for?

1019

What is a sub query? Describe its types?

1015

How to store only time; not date and time?

1017

What is MTTR advisor in Oracle?

1090

How to view the tablespaces in the current database?

973

What do you mean by a deadlock?

1059

What is a user role in oracle?

1121

How to enter a new row into a table interactively?

1008

Oracle

2373

defination of bitmap index

2117

What's dateware house and what's clustor with practicle example

2171

what is the use of triggers in Java program? I mean where do we use triggers in Java programming?

2181

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