- All Exams Instant Download
Which single SQL statement will do this?
We want to increase the salary for each employee (EMP) in the department (WORKDEPT) D11 and we want to see the new salaries (SALARY) for each of them. Which single SQL statement will do this?A . B . C . D . View AnswerAnswer: D
What is the result XQuery FLWOR expression when running the following scenario?
What is the result XQuery FLWOR expression when running the following scenario? A . Joe SmithB . <name> Joe Smith </name>C . <employeeinfo><name> Joe Smith </name></employeeinfo>D . <name> Joe Smith </name><department name>DB2</department name>View AnswerAnswer: A
How can you accomplish this?
You want to reduce lock contention that results from uncommitted insert and delete operations by enabling transactions that read data to access only the currently committed data rather than waiting for the uncommitted changes to be resolved. How can you accomplish this?A . Bind your application with ISOLATION(UR)B . Bind...
Which of the following SQL constructs does NOT provide information about the success or failure of the SQL statement that was just executed?
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
What is the result?
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 ....
Which of the following is the appropriate built-in data type for a salary column?
You are designing a payroll table that will contain a salary column. Which of the following is the appropriate built-in data type for a salary column?A . REALB . BIGINTC . DECIMALD . INTEGERView AnswerAnswer: C Explanation: Reference: https://www.ibm.com/support/knowledgecenter/en/SS6NHC/ com.ibm.swg.im.dashdb.sql.ref.doc/doc/r0000791.html
Which of the following can be defined on the basis of a query?
Which of the following can be defined on the basis of a query?A . An aliasB . A base tableC . An accelerator-only tableD . A materialized query tableView AnswerAnswer: D Explanation: Reference: https://www.ibm.com/developerworks/data/library/techarticle/dm-0509melnyk/
Which privilege will user smith be able to grant to another user on table emp when the following SQL is executed?
Which privilege will user smith be able to grant to another user on table emp when the following SQL is executed? GRANT ALL ON TABLE emp TO smith WITH GRANT OPTION;A . BINDB . REORGC . TRIGGERD . EXECUTEView AnswerAnswer: D
In a unique referential constraint, which type of key does a foreign key reference?
In a unique referential constraint, which type of key does a foreign key reference?A . Child keyB . Collation keyC . Parent keyD . Secondary keyView AnswerAnswer: C Explanation: Reference: https://www.ibm.com/support/knowledgecenter/en/SSEPGG_11.1.0/ com.ibm.db2.luw.admin.dbobj.doc/doc/c0020166.html
Which BIND option determines when DB2 will do authorization checking?
Which BIND option determines when DB2 will do authorization checking?A . DEFERB . DEPLOYC . VALIDATED . CURRENTDATAView AnswerAnswer: C Explanation: Reference: https://www.ibm.com/support/knowledgecenter/en/SSEPEK_10.0.0/comref/src/tpc/ db2z_bindoptvalidate.html
