CONNECT TO test;
CREATE TABLE colors(id INT NOT NULL PRIMARY KEY,
descVARCHAR(12));
CREATE TABLE objects(desc VARCHAR(12),
c_idINT REFERENCES colors (id)
ON UPDATE NO ACTION);
INSERT INTO colors VALUES (1, 'Red'), (2, 'Blue'), (3, 'Yellow'), (4, 'Green');
INSERT INTO objects VALUES ('Fire Engine', 1), ('Grass', 4), ('Banana', 3);
CONNECT RESET;
A DB2 Command Line Processor script file containing the commands and statements shown in the exhibit was executed successfully.
The statement shown below is executed: UPDATE colors SET id = id + 1;
How many records will be modified?
Select one of the following: