Free C2090-320 Exam Braindumps (page: 13)

Page 12 of 31

What are two major encoding schemes? (Choose two.)

  1. UNIX
  2. Linux
  3. CCSID
  4. Unicode
  5. EBCDIC

Answer(s): D,E


Reference:

https://www.ibm.com/support/knowledgecenter/en/SSEPEK_10.0.0/intro/src/tpc/ db2z_introcodepage.html



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?

  1. A view
  2. Multilevel security
  3. An MQT (Materialized Query Table)
  4. A combination of row permissions and column masks

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?

  1. The resource limit facility table authid.DSNRLMTxx
  2. The DB2 catalog table SYSIBM.SYSENVIRONMENT
  3. The profile table SYSIBM.DSN_PROFILE_ATTRIBUTES
  4. The communications database table SYSIBM.USERNAMES

Answer(s): C






Post your Comments and Discuss IBM C2090-320 exam with other Community members:

C2090-320 Exam Discussions & Posts