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 are the different types of databases?

1 1218

What are ACID properties in databases?

1 2857

What is the difference between INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN?

1 1217

What is indexing, and how does it improve performance?

1 1092

What is a deadlock in SQL? How can you prevent it?

1 3145

What is the CAP theorem?

1 1112

How would you optimize a slow SQL query?

1 3140

How do you handle duplicate records in a database?

1 1059

How would you design a database for an e-commerce website?

1 1060

How do you ensure database security?

1 1205

What would you do if a database crashes in production?

1 990

What are the components of physical database structure in the Oracle database?

1 1684

Preparing for Oracle PL/SQL Interviews – Need Help with Common Questions

1 2404

Un-Answered Questions { Oracle }

What is a nested table?

1057

What is a snapshot log?

1003

A user is getting an ora-00942 error yet you know you have granted them permission on the table, what else should you check?

558

What happens if a tablespace clause is left off of a primary key constraint clause?

581

What is the difference between the Oracle ODBC driver and a Microsoft ODBC (Open Database Connectivity) Driver?

1114

Why cursor variables are easier to use than cursors?

1094

How many types of canvases are there.

Can we look-up a table from source qualifier transformation. Ie. Unconnected lookup?

Explain the use of ignore option in imp command.

1035

What are the various constraints used in oracle?

1045

Describe an oracle table?

1049

How many types of km's?

584

Explain dual table. Is any data internally stored in dual table. Lot of users is accessing select sysdate from dual and they getting some millisecond differences. If we execute select sysdate from emp; what error will we get. Why?

575

Are These Dff's Flexible?

1170

What is Virtual Private Database in Oracle?

1087

For More Un-Answered { Oracle } Questions Click Here