CompTIA
Checkpoint
ISC
HP
Dell
EC-Council
EXIN
Fortinet
ITIL®
Juniper
PMI
Microsoft
VMware
Avaya
Google
Salesforce
Amazon
Palo Alto Networks
Certiport
ISC2
All Vendors
  2. Home
  3. Exams
  4. IBM
  5. C2090-616

Free C2090-616 Exam Braindumps (page: 4)

Page 3 of 16
PDF with 63 Questions

Which of the following statements about stored procedures is TRUE?

  1. Stored procedures can be written in SQL PL, but not in the PL/SQL dialect
  2. The CREATE SOURCED PROCEDURE statement defines a procedure that is based on another procedure in a federated database
  3. There are three types of stored procedures which can be deployed: SQL procedures, external procedures, and sourced procedures
  4. 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?

  1. DB2 Developer Edition
  2. DB2 Express Server Edition
  3. DB2 Enterprise Server Edition
  4. DB2 Connect Enterprise Server Edition

Answer(s): B



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

  1. There is a limit of 8 for the maximum number of cascading trigger activations
  2. Triggers can be activated as a result of changes due to referential constraint enforcement
  3. Multiple INSTEAD OF triggers are allowed for each kind of operation on a given subject view
  4. Constraints associated with a subject table are applied between execution of BEFORE and AFTER triggers
  5. 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?

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

Answer(s): C






Post your Comments and Discuss IBM C2090-616 exam with other Community members:

C2090-616 Discussions & Posts