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 2866

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 1094

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

1 3157

What is the CAP theorem?

1 1112

How would you optimize a slow SQL query?

1 3153

How do you handle duplicate records in a database?

1 1059

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

1 1062

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 1687

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

1 2426

Un-Answered Questions { Oracle }

Explain the use of constraints option in exp command.

1048

What are the attributes of cursor?

1054

What are the five functions of a database?

608

What do you understand by a database object?

1062

You are getting busy buffer waits. Is this bad? How can you find what is causing it?

537

What is the best way to do multi-row insert in oracle?

1067

What are the Types of repositories in ODI?

584

Can we convert a date to char in oracle and if so, what would be the syntax?

1015

Briefly explain what is literal? Give an example where it can be used?

1042

Give the constructs of a package, function or a procedure.

1041

What is pga_aggregate_target?

571

What is a system tablespace?

1072

types of indexes and the rationale behind choosing a particular index for a situation.

2510

Which dictionary tables and/or views would you look at to diagnose a locking issue?

1911

Which rman command is used to create an exact replica of a database innew host?

593

For More Un-Answered { Oracle } Questions Click Here