IBM C2090-616 Exam Dumps

Question 6 of 49

Which constraint can be used to ensure that identical values are never stored in a set of columns in a table?

NOT NULL

Foreign key

Primary key

Informational constraint

Correct Answer: C

A primary key constraint ensures that each value in the column or set of columns is unique and that no null values are allowed. This constraint is designed specifically to prevent duplicate values, making it the appropriate answer for ensuring that identical values are never stored in a set of columns in a table.

Question 7 of 49

Which of the following is TRUE about a COMMIT statement executed at the end of the T1 unit of work?

A ROLLBACK command executed just after the COMMIT command cancels that COMMIT

Save points defined during transaction T1 are released only if there is a RELEASE SAVEPOINT command executed after the COMMIT command

It finishes the current T1 unit of work and a new one is initiated, however it is possible to ROLLBACK to the latest SAVEPOINT before COMMIT

It finishes the current T1 unit of work and a new one is initiated. All changes made by UPDATE and DELETE commands during unit of work T1 are committed

Correct Answer: D

A COMMIT statement concludes the current transaction, making all changes made by UPDATE and DELETE commands permanent. Once the COMMIT is complete, a new unit of work is initiated, and it is not possible to undo the committed changes with a ROLLBACK command. Thus, the correct choice is that it finishes the current T1 unit of work and a new one is initiated, committing all changes made during T1.

Question 8 of 49

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

Correct Answer: C

There are three main types of stored procedures which can be deployed: SQL procedures, external procedures, and sourced procedures. SQL procedures are written using SQL and run within the database server. External procedures are written in an external programming language and linked to the database. Sourced procedures are based on an existing procedure. These distinctions cover the general categories of stored procedures in many relational database management systems.

Question 9 of 49

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

DB2 Developer Edition

DB2 Express Server Edition

DB2 Enterprise Server Edition

DB2 Connect Enterprise Server Edition

Correct Answer: B

DB2 Express Server Edition has been discontinued in version 11.1 of DB2 LUW. This information can be verified through IBM's official documentation, which explicitly states the discontinuation of the DB2 Express Server Edition in this version.

Question 10 of 49

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

Correct Answer: B, D

Triggers can be activated as a result of changes due to referential constraint enforcement. This means that the enforcement of referential constraints can cause triggers to be fired. Additionally, constraints associated with a subject table are applied between the execution of BEFORE and AFTER triggers. BEFORE triggers allow modifications to the values being inserted or updated before the actual database data is changed, while AFTER triggers are used for actions that need to occur after the data modification, such as maintaining data relationships or audit trails.