C2090-616 exam

Which constraint can be used to ensure that identical values are never stored in a set of columns in a table?A . NOT NULLB . Foreign keyC . Primary keyD . Informational constraintView AnswerAnswer: C Explanation:https://www.ibm.com/developerworks/data/library/techarticle/dm-0401melnyk/index.html

Which of the following editions of DB2 include support for Federation with Oracle database?A . DB2 Express-CB . DB2 Developer EditionC . DB2 Enterprise Server EditionD . DB2 Workgroup Server EditionView AnswerAnswer: C Explanation:https://www.ibm.com/developerworks/data/library/techarticle/dm-1311db2compare/index.html

Which of the following statements about stored procedures is TRUE?A . Stored procedures can be written in SQL PL, but not in the PL/SQL dialectB . The CREATE SOURCED PROCEDURE statement defines a procedure that is based on another procedure in a federated databaseC . There are three types of...

Which of the following statements about triggers are TRUE? (Choose two.)A . There is a limit of 8 for the maximum number of cascading trigger activationsB . Triggers can be activated as a result of changes due to referential constraint enforcementC . Multiple INSTEAD OF triggers are allowed for each...

Which three facilities are used to control authorization in DB2?A . privileges, db2ssh, LBAC credentialsB . privileges, authority levels, certificatesC . db2ssh, trusted contexts, authority levelsD . privileges, authority levels, LBAC credentialsView AnswerAnswer: D Explanation:https://www.ibm.com/support/knowledgecenter/zh/SSEPGG_9.5.0/ com.ibm.db2.luw.admin.sec.doc/doc/c0006307.html

The following statements are executed: GRANT CREATETAB, DATAACCESS, ON DATABASE TO ROLE role A; GRANT CREATETAB, BINDADD ON DATABASE TO ROLE role B; GRANT ROLE role A to USER db2inst3; GRANT ROLE role B to USER db2inst3; Which of the following is TRUE if this statement is executed later? REVOKE...

How can you tell what privileges on a table or view have been granted to a user? (Choose two.)A . db2look with the Cx optionB . db2pd with the Cauth optionC . Query the SYSCAD . DBAUTH viewE . Query the SYSCAF . TABLES viewG . Query the SYSCAH ....

What is the purpose of a role?A . To define exactly what a specific user can and cannot do within a particular database once they have been authenticatedB . To group a collection of users together so that they can be simultaneously granted and revoked specific authorities and privilegesC ....

A user executes the following statements: СREATE TABLE t1 (c1 INT, c2 INT); CREATE ALIAS a1 FOR t1; What will be the result if the user executes the following statement? DROP ALIAS a1;A . The alias A1 will be droppedB . The table T1 will be droppedC . Both T1...

Which of the following is TRUE about a COMMIT statement executed at the end of the T1 unit of work?A . A ROLLBACK command executed just after the COMMIT command cancels that COMMITB . Save points defined during transaction T1 are released only if there is a RELEASE SAVEPOINT command...