Which of the following is TRUE about PL/SQL support in DB2?
Posted: Fri Aug 26, 2022 10:00 am
Which of the following is TRUE about PL/SQL support in DB2?
A. The DB2 compiler can process PL/SQL statements and create the required objects in the database. The PL/SQL support is enabled by setting the DB2_COMPATIBILITY_VECTOR registry variable.
B. DB2 requires third party software to execute PL/SQL statements.
C. You can only execute PL/SQL statements using the CLPPIus interface.
D. PL/SQL support is only enabled when using federation to access other vendor databases.
A. The DB2 compiler can process PL/SQL statements and create the required objects in the database. The PL/SQL support is enabled by setting the DB2_COMPATIBILITY_VECTOR registry variable.
B. DB2 requires third party software to execute PL/SQL statements.
C. You can only execute PL/SQL statements using the CLPPIus interface.
D. PL/SQL support is only enabled when using federation to access other vendor databases.