Practice exam questions

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

1:Which statement is false?

  1. You can put data into a table that you create by using the DB2 LOAD utility or SQL INSERT statement.

  2. When you define a base table, you define all the columns of the table.

  3. When you create a base table, DB2 records the table's definition in the DB2 directory.

  4. Creating a table does not store the application data.

2:Which statement is valid? 
  1. CREATE TABLE EMP
 (EMPNO CHAR(6) NOT NULL,
  FIRSTNME VAR CHAR(12) NOT NULL,
  LASTNAME VAR CHAR(15) NOT NULL,
  PRIMARY KEY (EMPNO)
IN MYDB.MYTS;

  2.  CREATE TABLE EMP (EMPNO CHAR(6) NOT NULL, FIRSTNME VAR CHAR(12) NOT NULL, LASTNAME VAR CHAR(15) NOT NULL, PRIMARY KEY (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