Learning Visually with Examples [Electronic resources]

Which data movement utility supports the CURSOR input file type?

What other privileges are needed to load a table if the person already has LOAD authority?

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?

With the same target table definition,

load command, and input file as in question 3,, which rows will be stored in the

stockexp exception table?

A table is created with the following statement:

CREATE TABLE employee 
( id   SMALLINT NOT NULL 
, name VARCHAR(10) 
, job  CHAR(5) CHECK (job IN ('Sales', 'Mgr', 'Clerk') ) 
, PRIMARY KEY (id)) 

If this

load command is issued, what state would the

employee table be in?

load from emp2.del of del insert into emp2 

A table is created with the following statement:

CREATE TABLE employee 
( id   SMALLINT NOT NULL 
, name VARCHAR(10) 
, job  CHAR(5) CHECK (job IN ('Sales', 'Mgr', 'Clerk') ) 
, PRIMARY KEY (id)) 

If this

import command is issued, what state would the

employee table be in?

import from emp2.del of del insert into emp2 

What will this command do?

db2look d department a e m x f o db2look.sql 

Bob just completed a load operation to insert 300,000 rows of data into various tables. He performed a

RUNSTATS to update the database statistics so that the DB2 optimizer knows about the new data. However, when the user logs in and runs the application, the performance is not acceptable. The application is mainly coded in static SQL and SQL stored procedures. What can Bob do to improve performance?

Bob tries to execute the following command:

import from largeinputfile.ixf of ixf 
messages import.out 
create into newtable in datats index in indexts 

However, he receives log full errors. What can he do to solve this problem?

What is the prerequisite for a table to be imported with the

insert_update option?

Which of the following tools will read data from an ASCII file and add them to a table?

1. insert

2. merge

3. load

4. export

5. import

Which of the following tools will read data from an ASCII file and add them to a view?

1. insert

2. merge

3. load

4. export

5. import

Which of the following formats is not supported by the import utility?

1. IXF

2. DEL

3. ASC

4. XLS

You want to import the following rows of data in the file

foo.txt into the table

foo :

"Hello"|"World"
"Goodbye"|"Cruel World"

Which of the following commands must you run?

1. Import from foo.txt of txt insert into foo

2. Import from foo.txt of del insert into foo

3. Import from foo.txt of pipedel insert into foo

4. Import from foo.txt of del modified by coldel| insert into foo

Which of the following tools cannot act on a view?

1. Export

2. Import

3. Load

Which of the following tools, commands, or statements can be used to rename a database?

1. Rename database

2. db2relocatedb

3. db2move

4. db2renamedb

Which of the following tools can capture statistics on the data it adds to the table?

1. Export

2. Import

3. Load

Which of the following are true?

1. The load utility locks the whole table space for the table being loaded.

2. The load utility locks the whole table being loaded.

3. The load utility by default locks only the existing data in the table until the load completes.

4. The load utility allows read access to all data that existed in the table before the load was run.

Which of the following tools can create a new table as well as populating the table?

1. Load

2. Import

3. Export

4. db2look

Given a table is defined with PCTFREE = 1, which of the following tools will not leave free space in a table for subsequent inserts?

1. Load

2. Import

3. Reorg