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?

1060

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

1065

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

1045

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?

1088

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

1050

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

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

1049

Un-Answered Questions { Oracle }

What are the file storage options provided by oracle database for oracle rac?

What is the function of Redo Log in Oracle?

1219

Can a Tablespace hold objects from different Schemes in Oracle?

1044

How do we display rows from the table without duplicates?

972

What is the sequence of firing in report trigger?

What are the types of data contol?

614

What are transaction isolation levels supported by oracle?

1072

Is insert autocommit in oracle?

1068

Which is better Oracle or MS SQL? Why?

6386

What is oracle log switch?

619

What is a dba certification?

594

What is Reduced List of Values?

2164

How do you set up tablespaces during an oracle installation?

606

How can I convert single byte kana characters into multi byte kana characters and vice-versa.

2397

What would you do with an in-doubt distributed transaction?

1978

For More Un-Answered { Oracle } Questions Click Here