Understanding DB2®: Learning Visually with Examples

12.12. Review Questions

1:	Which data movement utility supports the CURSOR input file type?
2:	What other privileges are needed to load a table if the person already has LOAD authority?
3:	Bob creates the stock table: CREATE TABLE stock ( id INTEGER NOT NULL , name VARCHAR(10) , bandlevel INTEGER NOT NULL , PRIMARY KEY (id) ) He then loads the table with this load command: load from stock.del of del modified by dumpfile=stockdump.dmp messages stock.out replace into stock for exception stockexp The input file stock.del looks like this: 10, "AAA", 30 20, "BBB", - 30, "CCC", 3 30, "DDD", 4 40, "EEE", x After the load command is executed, which rows will be stored in the stockdmp.dmp file?
4:	With the same target table definition, load command, and ...