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

1 1315

What are ACID properties in databases?

1 3273

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

1 1329

What is indexing, and how does it improve performance?

1 1187

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

1 3575

What is the CAP theorem?

1 1219

How would you optimize a slow SQL query?

1 3540

How do you handle duplicate records in a database?

1 1143

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

1 1151

How do you ensure database security?

1 1299

What would you do if a database crashes in production?

1 1074

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

1 1836

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

1 2909

Un-Answered Questions { Oracle }

When do you get a .pll extension in oracle? Explain its importance

1103

What is rowid and rownum in oracle?

1073

What is transaction control statement and how many types of transaction control statement in Oracle?

1242

Explain the wait events in statspack report 'db sequential real'?

693

explain what is odi?why is it different from the other etl tools.

668

Which is faster join or subquery in oracle?

1050

You attempt to add a datafile and get: ora-01118: cannot add anymore datafiles: limit of 40 exceeded. What is the problem and how can you fix it?

638

Explain how to account for bank charges deducted from amount received against an invoice. : oracle accounts receivable

1348

What is flexfileds and use of flexfileds in odi?

633

what is partitioning? Types of partitioning. explain? what is the new kind of partitioning type introduced in 9i?

2320

How do I find the database name in oracle?

1090

How do you run ms_batch file in forms?

I have a frame that contains headings. This frame is enclosed in side a repeating frame. However the headings are not displayed on all pages it is displayed only on the last page. Please let me know why is this happening. print object on = All pages base printing on = enclosing object

3099

What are internal user account in oracle?

1055

what does the no logging option do? Why would we use it?

603

For More Un-Answered { Oracle } Questions Click Here