C2090-320 exam

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

Which of the following can activate a trigger?A . A row is insertedB . A table or view is createdC . A check constraint is definedD . A referential constraint is violatedView AnswerAnswer: D Explanation: Reference: https://www.ibm.com/support/knowledgecenter/en/SSEPEK_11.0.0/intro/src/tpc/ db2z_triggers.html

Given the tables: Which SQL statement would join the tables on product number (prod#) and provide a table of what products (product), if any, the parts (part) are used? Limit the result to only parts where suppliers (supplier) do not start with the letter A. A. B. C. D. View...

In order to run a DB2 program, the user issues the following commands: TSO prompt: READY USER enters: DSN SYS(SSTR) USER enters: RUN PROGRAM(MYPROG) USER enters: END What is the result?A . DB2 does not allow these commandsB . DSN command can not be used to run a programC ....

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

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 statement is TRUE regarding ROLLBACK processing?A . It only reads active logsB . It always needs archive logsC . It can never be processed just from memoryD . It uses output buffers, active and archive logsView AnswerAnswer: D

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

Which types of user-defined data types are supported? (Choose two.)A . CHARB . ARRAYC . NUMERICD . DISTINCTE . TIMESTAMPView AnswerAnswer: BD Explanation: Reference: https://www.ibm.com/support/knowledgecenter/en/SSEPEK_11.0.0/sqlref/src/tpc/ db2z_userdefineddatatypes.html

Which statement is TRUE regarding catalog table SYSIBM.SYSROUTINES?A . Contains scheduled tasks for the administrative schedulerB . Contains information about UDFs, BIFs and stored proceduresC . Contains information about bound packagesD . Contains information about UDFs and stored proceduresView AnswerAnswer: D Explanation: Reference: https://www.ibm.com/support/knowledgecenter/en/SSEPEK_10.0.0/cattab/src/tpc/ db2z_sysibmsysroutinestable.html