For part 1 of Oracle Interview Questions please click Oracle Interview Questions Part 1 42. What is syntax of MERGE command? What is faster, writing an insert and update statement separately or writing an MERGE command? Can records be deleted using MERGE command? 43. Is it possible to delete records from parent table without effecting [...]
Tags: Oracle Interview Questions, Oracle SQL, SQL Interview Questions

1. What is SDLC cycle? Please explain. 2. What are Codd’s rules? Please explain. 3. What is normalization and explain about types of normalization? 4. What is the difference between SQL/PL-SQL/embedded SQL? 5. Explain INTEGER, POSITIVE, NATURAL, SIGNTYPE, PLS_INTEGER and BINARY_INTEGER? What is the difference between BINARY_INTEGER and PLS_INTEGER? 6. How to store large objects [...]
Tags: Oracle Interview Questions, Oracle SQL, SQL Interview Questions

Some of the frequently asked Interview Questions in Oracle PL/SQL 1. What is Function, Procedure & Package? Difference? 2. Will function return more than one value? If yes then how? 3. What is Overloading of procedures? 4. Where are the Variables declared in Packages? 5. What is mean by forward declaration? Please explain with examples. [...]
Tags: Oracle PL/SQL, Oracle Interview Questions, PL SQL Interview Questions