C2090-320

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

Your current authorization ID is DBA. Only one of your secondary authorization IDs, DB2, has the privilege to create an index DB2.AAA on a table. The appropriate SQL statement starts with “CREATE INDEX AAA ON…”. Which of the following statements must precede the CREATE statement so that you can create...

Which of the following are contained in the PLAN_TABLE? (Choose two.)A . RUNSTATS recommendationsB . Access to LOB values, which are stored separately from the base tableC . Access to parent or dependent tables needed to enforce referential constraintsD . Whether an index access or table space scan is used...

The metadata for which of the following objects is NOT stored in the DB2 catalog table SYSIBM.SYSTABLES?A . A viewB . A temporal tableC . A created global temporary tableD . A declared global temporary tableView AnswerAnswer: B

The DB2 subsystem DSN has been correctly configured to access a remote DB2 location MYREMOTE. Which of the following processes can be used on subsystem DSN to access MYUSER.EMP table at MYREMOTE location?A . SELECT * FROM MYUSEB . EMP;C . CONNECT TO MYREMOTE;SELECT * FROM MYUSED . EMP;E ....

Which of the following is NOT TRUE?A . An index can be created on XML columnsB . Length must be specified for an XML columnC . XML columns can be added to existing tablesD . Triggers can be created on tables with XML columnsView AnswerAnswer: D

Your current authorization ID is DBA. Only one of your secondary authorization IDs, DB2, has the privilege to create an index DB2.AAA on a table. The appropriate SQL statement starts with “CREATE INDEX AAA ON…”. Which of the following statements must precede the CREATE statement so that you can create...

Which authorizations can change the value of the subsystem parameter SYSADM using the CSET SYSPARM command? (Choose two.)A . SYSADMB . SECADMC . SYSCTRLD . Installation SYSADME . Installation SYSOPRView AnswerAnswer: D,E

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 SQL constructs does NOT provide information about the success or failure of the SQL statement that was just executed?A . SQLCAB . SQLDAC . SQLCODED . SQLSTATEView AnswerAnswer: B