• Description: 000-700 IBM DB2 UDB V8.1 Family Fundamentals
• Passing Score: 75%
• Practice Test - Number of questions: 99 questions
• Simulation Test - Number of questions: 99 questions
• Simulation Test Duration: 41 minutes
• Has explanations: No

Given the following tables: TABLEA TABLEB empid name empid weeknumber paycheck 1 USER1 1 1 2000.00 2 USER2 1 2 3000.00 2 1 2000.00 TABLEB was defined as follows: CREATE TABLE tableb (empid CHAR(3), weeknumber CHAR(3), paycheck DECIMAL(6,2), CONSTRAINT const1 FOREIGN KEY (empid) REFERENCES tablea (empid) ON DELETE CASCADE) How many rows would be deleted from TABLEB if the following command was issued? DELETE FROM tablea WHERE empid = '2'

Answer(s)

1. 2
2. 0
3. 1
4. 3

1