C2090-320 exam

Which of the following is a characteristic of a stand-alone utility?A . It can only be executed using JCLB . It can only be executed by a user with SYSADMC . It can only be executed if no other utilities are runningD . It can only be executed in a...

Which of the following elements is affected by a ROLLBACK statement?A . LOB table spacesB . Changes in cursor positioningC . Acquisition and release of locksD . Caching of rolled back statementsView AnswerAnswer: A Explanation: Reference: https://www.ibm.com/support/knowledgecenter/en/SSEPEK_10.0.0/sqlref/src/tpc/ db2z_sql_rollback.html

Which DB2 address space manages DB2 locking?A . IRLMB . DISTC . DBM1D . MSTRView AnswerAnswer: A Explanation: Reference: https://www.ibm.com/support/knowledgecenter/en/SSEPEK_10.0.0/inst/src/tpc/ db2z_irlmaddrspcstgreq.html

Which of the following elements is affected by a ROLLBACK statement?A . LOB table spacesB . Changes in cursor positioningC . Acquisition and release of locksD . Caching of rolled back statementsView AnswerAnswer: A Explanation: Reference: https://www.ibm.com/support/knowledgecenter/en/SSEPEK_10.0.0/sqlref/src/tpc/ db2z_sql_rollback.html

What are two major encoding schemes? (Choose two.)A . UNIXB . LinuxC . CCSIDD . UnicodeE . EBCDICView AnswerAnswer: DE Explanation: Reference: https://www.ibm.com/support/knowledgecenter/en/SSEPEK_10.0.0/intro/src/tpc/ db2z_introcodepage.html

You want to limit the access of a table to allow users to only see certain columns and/or rows. Which of the following options CANNOT be used to accomplish this?A . A viewB . Multilevel securityC . An MQT (Materialized Query Table)D . A combination of row permissions and column...

Which of the following utilities CANNOT be executed from the DB2 utilities panel in DB2I?A . COPYB . REORGC . STOSPACED . BACKUP SYSTEMView AnswerAnswer: D Explanation: Reference: https://www.ibm.com/support/knowledgecenter/en/SSEPEK_11.0.0/ugref/src/tpc/ db2z_useutilitiespaneldb2i.html

Which of the following tables can be used to set the default of the special register CURRENT APPLICATION COMPATIBILITY for remote users?A . The resource limit facility table authid.DSNRLMTxxB . The DB2 catalog table SYSIBC . SYSENVIRONMENTD . The profile table SYSIBE . DSN_PROFILE_ATTRIBUTESF . The communications database table SYSIBG...

COL1 is defined as CHAR(05) and contains CHAR(‘12345’). Which of the following expressions returns the digits 12345 for further calculation?A . HEX(COL1)B . DEC(COL1)C . PACK(COL1)D . DIGITS(COL1)View AnswerAnswer: B

Given the following CREATE TABLE statement, and a unique index on column EMPID, which set of SQL statements is valid? A . B . C . D . View AnswerAnswer: D