06:39
plsql Interview Questions and Answers
PL/SQL is a transaction processing procedural language that has the following advantages:
a. Integration with database - PL/SQL supports SQL statements, thus enabling integration between procedural language capabilities and the database technology.
b. Better performance - SQL statements are grouped within a PL/SQL block and sent together to database for parsing;
therefore, it reduces the network traffic and increases the performance.
c. Higher productivity - PL/SQL helps the package reusable code within the well-defined modular blocks; and therefore, increases the productivity.
d. Portability - Programs packages and libraries written in PL/SQL can be reused in different environments.
a. Integration with database - PL/SQL supports SQL statements, thus enabling integration between procedural language capabilities and the database technology.
b. Better performance - SQL statements are grouped within a PL/SQL block and sent together to database for parsing;
therefore, it reduces the network traffic and increases the performance.
c. Higher productivity - PL/SQL helps the package reusable code within the well-defined modular blocks; and therefore, increases the productivity.
d. Portability - Programs packages and libraries written in PL/SQL can be reused in different environments.
0 comments:
Post a Comment