C2090-616 exam

Which of the following commands can undo the work done by the current unit of work executing UPDATE statements on a table?A . COMMITB . SAVEPOINTC . ROLLBACK WORKD . UPDATE TERMINATEView AnswerAnswer: C Explanation:https://www.ibm.com/support/knowledgecenter/en/SSEPEK_10.0.0/sqlref/src/tpc/ db2z_sql_rollback.html

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

Which DB2 object is associated with PREVIOUS VALUE and NEXT VALUE expressions?A . SequenceB . Row IdentifierC . Identity ColumnD . Insert time clustering tableView AnswerAnswer: A Explanation:https://www.ibm.com/support/knowledgecenter/en/SSEPEK_10.0.0/sqlref/src/tpc/ db2z_sequencereference.html

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 happens when you run the following statement if MYUSER holds no privileges on table MYTABLE? REVOKE SELECT ON TABLE mytable FROM USER myuserA . An error is returnedB . An entry is mane in SYSCAC . TABAUTHD . The REVOKE statement succeeds with no effectE . All privileges are...

Which of the following authorities is sufficient for connecting to a database?A . SQLADMB . CONNECTC . DATAACESSD . ACCESSCTRLView AnswerAnswer: D Explanation:http://www-01.ibm.com/support/docview.wss?uid=swg21427232

Which of the following authorities are sufficient for creating a database? (Choose two.)A . DBADMB . SYSADMC . SECADMD . SYSCTRLE . SYSMAINTView AnswerAnswer: BD Explanation:https://www.ibm.com/support/knowledgecenter/en/SSEPGG_11.1.0/ com.ibm.db2.luw.admin.cmd.doc/doc/r0001941.html

What type of function is created using the following command? CREATE FUNCTION TAN (X DOUBLE) RETURNS DOUBLE LANGUAGE SQL CONTAINS SQL NO EXTERNAL ACTION DETERMINISTIC RETURN SIN(X)/COS(X)A . RowB . TableC . ScalarD . ExternalView AnswerAnswer: C Explanation:https://www.ibm.com/support/knowledgecenter/en/SSEPEK_11.0.0/sqlref/src/tpc/ db2z_sql_createfuncinlinesqlscalar.html

Which of the following is TRUE about indexes on column organized tables?A . No indexes are allowedB . Indexes are only allowed on numeric columnsC . Indexes are automatically created to enforce unique constraintsD . An index is only allowed on the synopsis table supporting a column organized tableView AnswerAnswer:...

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