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

Oracle General (1803)
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?

1112

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

1116

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

1137

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

1926

What are the different editions of oracle?

1183

What is meant by an index?

1227

What is meant by a deadlock situation?

1156

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

1141

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

1134

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

1115

How is it different from a normal table?

1084

How does the on-delete-cascade statement work?

1165

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

1109

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

1310

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

1098

Un-Answered Questions { Oracle }

What are the different editions of oracle?

1183

How can you tell how much space is left on a given file system and how much space each of the file systems subdirectories take-up?

2877

What do you understand by anchoring in reports?

How can I combine multiple rows into a comma-delimited list in oracle?

1124

What do you mean by a tablespace?

1092

How do you store pictures in a database?

1061

What is the oracle implicit cursor?

1115

What are the differences between char and varchar2 in oracle?

1249

What do you mean by database normalization and why is it important?

What is redo log?

1117

What are the differences between date and timestamp in oracle?

1099

How to get a create statement for an existing table?

1020

How many types of knowledge Modules? Where are used in km?

662

In what situation u create the BPA.

2254

Tell me about standby database? What should we watch out for?

591

For More Un-Answered { Oracle } Questions Click Here