9.9. Review Questions

1:Given the following employee table: 
    empno    firstnme     lastname      salary
----------------------------------------------
    000010   Peter        Smith       38752.00
    000020   Christine    Haas        52234.00
    000030   John         Geyer       38250.00
    000040   Irving       Poon        40175.00
    000050   Eva          Pulaski     36170.00

How many rows are returned from the following SQL statement?

								SELECT empno
								FROM employee
								WHERE lastname LIKE 'P%'
								AND salary > 38500

  1. 1

  2. 2

  3. 3

  4. 4

  5. 5

2:Given the following table t1: 
     id    job     bonus
---------------------------
     1     Mgr     -
     2     Sales   10
     3     Mgr     -
     4     DBA     15

Which of the following SQL statement will retrieve the rows that have unknown values in the bonus column?

  1. SELECT * FROM t1 WHERE bonus = NULL

  2. SELECT * FROM t1 WHERE bonus = ''

  3. SELECT * FROM t1 WHERE bonus = '' OR bonus = 'NULL' ...

Get Understanding DB2®: Learning Visually with Examples 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