What will happen to Jeff’s SELECT privilege?

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

January 9, 2020 No Comments READ MORE +

Which database object can be locked explicitly?

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

January 9, 2020 No Comments READ MORE +

Which operation typically requires a Share (S) lock?

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

January 9, 2020 No Comments READ MORE +

BLU Acceleration is included in which of the following edition of DB2 LUW? (Choose two.)

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

January 8, 2020 No Comments READ MORE +

Which of the following editions of DB2 include support for Federation with Oracle database?

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

January 7, 2020 No Comments READ MORE +

Which of the following is TRUE if this statement is executed later?

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

January 6, 2020 No Comments READ MORE +

How can you tell what privileges on a table or view have been granted to a user? (Choose two.)

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

January 6, 2020 No Comments READ MORE +

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

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

January 6, 2020 No Comments READ MORE +

What of the following is TRUE about triggers?

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

January 6, 2020 No Comments READ MORE +

Which of the following statements about stored procedures is TRUE?

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

January 5, 2020 No Comments READ MORE +