C2090-616

Consider the following sequence of events: Eddie grants SELECT WITH GRANT OPTION privilege to Mike. Mike grants SELECT privilege to Jeff. Eddie revokes SELECT privilege from Mike. What will happen to Jeff’s SELECT privilege?A . Jeff’s SELECT privilege will be revokedB . Jeff’s SELECT privilege will be retainedC . Jeff’s...

Which database object can be locked explicitly?A . RowB . ViewC . IndexD . TableView AnswerAnswer: D Explanation:https://www.ibm.com/support/knowledgecenter/hr/SSEPGG_9.7.0/ com.ibm.db2.luw.admin.perf.doc/doc/c0005270.html

Which operation typically requires a Share (S) lock?A . INSERTB . SELECTC . DELETED . UPDATEView AnswerAnswer: B Explanation:https://www.ibm.com/developerworks/data/library/techarticle/dm-0509schuetz/index.html

BLU Acceleration is included in which of the following edition of DB2 LUW? (Choose two.)A . Direct Standard EditionB . Enterprise Server EditionC . Workgroup Server EditionD . DB2 Direct Advanced EditionE . Advanced Enterprise Server EditionView AnswerAnswer: DE Explanation:https://www.ibm.com/support/knowledgecenter/en/SSEPGG_10.5.0/ com.ibm.db2.luw.licensing.doc/doc/r0053238.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: B Explanation:https://www.ibm.com/developerworks/data/library/techarticle/dm-1311db2compare/index.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 ....

Which edition of DB2 LUW has been discontinued in v11.1?A . DB2 Developer EditionB . DB2 Express Server EditionC . DB2 Enterprise Server EditionD . DB2 Connect Enterprise Server EditionView AnswerAnswer: B Explanation:https://www.ibm.com/support/knowledgecenter/en/SSEPGG_11.1.0/ com.ibm.db2.luw.licensing.doc/doc/r0053238.html

What of the following is TRUE about triggers?A . Triggers are activated by INSERT, UPDATE, DELETE and SELECT statementsB . Triggers can be used to perform data manipulation operations against complex viewsC . Triggers can only be used to execute logic before or after appropriate SQL statementsD . Only one...

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...