Practice exam questions

The following practice exam questions test your knowledge of material that this chapter covers.

1:Which statement is true?

  1. The CHAR scalar function returns a string representation of the input value.

  2. The DECIMAL scalar function returns a decimal representation of the input value.

  3. The YEAR scalar function produces a single scalar value for each table row that satisfies the search condition.

  4. All of the above are true.

2:Which result table below could be generated by the following SQL statement? 
SELECT EMPNO, (SALARY + COMM)
 FROM EMP;

  1. EMPNO      SALARY      COMM
======     ========    =======     ========
000010     52750.00    4220.00     56970.00
000020     41250.00    3300.00     44550.00
000030     38250.00    3060.00     41310.00
000060     32250.00    2500.00     34830.00

  2.  EMPNO ====== ...

Get Official Introduction to DB2® for z/OS®, The, 2nd Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial