Which of the following statements about stored procedures is TRUE?

Stored procedures can be written in SQL PL, but not in the PL/SQL dialect
The CREATE SOURCED PROCEDURE statement defines a procedure that is based on another procedure in a federated database
There are three types of stored procedures which can be deployed: SQL procedures, external procedures, and sourced procedures
Two identically-named procedures within a schema are permitted to have exactly the same number of parameters, but the parameters must have different data types assigned

Answer(s): B

Which edition of DB2 LUW has been discontinued in v11.1?

Answer(s): B

Which of the following statements about triggers are TRUE? (Choose two.)

There is a limit of 8 for the maximum number of cascading trigger activations
Triggers can be activated as a result of changes due to referential constraint enforcement
Multiple INSTEAD OF triggers are allowed for each kind of operation on a given subject view
Constraints associated with a subject table are applied between execution of BEFORE and AFTER triggers
The activation of the triggers for a particular table, event and activation time are conducted in descending order of trigger creation time

Answer(s): B,D

Which of the following is TRUE about indexes on column organized tables?

No indexes are allowed
Indexes are only allowed on numeric columns
Indexes are automatically created to enforce unique constraints
An index is only allowed on the synopsis table supporting a column organized table

Answer(s): C

Free C2090-616 Exam Braindumps (page: 3)