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?
Answer(s): 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?
Answer(s): C
Which of the following tables can be used to set the default of the special register CURRENT APPLICATION COMPATIBILITY for remote users?
Which statement is TRUE regarding catalog table SYSIBM.SYSROUTINES?
https://www.ibm.com/support/knowledgecenter/en/SSEPEK_10.0.0/cattab/src/tpc/ db2z_sysibmsysroutinestable.html
Which SQL statement can be used to provide diagnostic information about the last SQL statement that was executed?
Answer(s): A
https://www.ibm.com/support/knowledgecenter/en/SSEPEK_10.0.0/sqlref/src/tpc/ db2z_sql_getdiagnostics.html
Post your Comments and Discuss IBM C2090-320 exam prep with other Community members:
Our website is free, but we have to fight against AI bots and content theft. We're sorry for the inconvenience caused by these security measures. You can access the rest of the C2090-320 content, but please register or login to continue.