FOR EACH STATEMENT MODE DB2SQL
BEGIN ATOMIC
INSERT INTO changes
SELECT empno, CURRENT TIMESTAMP FROM ntable;
END;
After executing the following SQL statements:
DELETE FROM changes;
UPDATE emp SET deptno = 'D98' WHERE deptno = 'D95';
INSERT INTO emp VALUES('0050', 'KEN', 'D90', 35000);
UPDATE emp SET salary = salary - 500 WHERE salary > 35000;
UPDATE emp SET salary = salary + 1000 WHERE salary <= 25000;
What value will be returned by this query?
SELECT count(*) FROM changes
A. 2
B. 3
C. 4
D. 6
Answer: A
QUESTION NO: 9
Given the following table and view definitions:
CREATE TABLE city (
cityid INT GENERATED ALWAYS AS IDENTITY ,
city_name CHAR(10),
state_code CHAR(2) CHECK(state_code IN ('CA','IL','NY','OH','TX')));
CREATE VIEW city_view AS (
SELECT city_name||','||state_code AS fullname FROM city
WHERE state_code NOT IN ('OH','IL'));
and the following trigger definition:
CREATE TRIGGER city_viewInput
INSTEAD OF INSERT ON city_view
REFERENCING NEW AS n
FOR EACH ROW MODE DB2SQL
5
http://killcert.taobao.com 考题大师
QQ:28763249 电话：18974730867 阿里旺旺:testinside考题大师
