Free IBM C2090-320 Exam Dumps Questions & Answers

Which of the following is used to identify valid source and target combinations and to perform the conversion from one coded character set to another?

• A.  DB2's Distributed Relational Database Architecture
• B.  DB2 catalog table SYSIBM.SYSCOLUMNS
• C.  z/OS Unicode support
• D.  EBCDIC tables

A summary table can be easily maintained using which of the following?

• A.  A partitioned table
• B.  A bi-temporal table
• C.  An auxiliary table
• D.  A materialized query table

In order to evaluate the real-time relative disorganization of an index, which catalog table would you query?

• A.  SYSIBM.SYSINDEXSPACESTATS
• B.  SYSIBM.SYSINDEXSTATS
• C.  SYSIBM.SYSINDEXES
• D.  SYSIBM.SYSINDEXPART

COL1 is defined as CHAR(05) and contains CHAR('12345'). Which of the following expressions returns the digits 12345 for further calculation?

• A.  HEX(COL1)
• B.  DIGITS(COL1)
• C.  PACK(COL1)
• D.  DEC(COL1)

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

• A.  Unicode
• B.  EBCDIC
• C.  UNIX
• D.  CCSID
• E.  Linux