PL/SQL interview questions and answers

PL/SQL interview questions and answers

1. What is PL/SQL? PL/SQL is a procedural language that has both interactive SQL and procedural programming language constructs such as iteration, conditional branching. 2. What is the basic structure of PL/SQL? PL/SQL uses block structure as its basic structure.…

Continue Reading
SQL Interview Questions and Answers

SQL Interview Questions and Answers

1)What are the Back ground processes in Oracle and what are they? Data Base Writer (DBWR): Data Base Writer Writes Modified blocks from Database buffer cache to Data Files. This is required since the data is not written whenever a…

Continue Reading