Правильно записанный сценарий с использованием триггера имеет вид:
(Отметьте один правильный вариант ответа.)
Варианты ответа
CREATE TABLE APPDATA ( CUST_ID INT NOT NULL, ACTION VARCHAR(10), USER_UP VARCHAR(25), DATETIME_UP TIMESTAMP,CONSTRAINT PK_AD PRIMARY KEY(CUST_ID) )CREATE TABLE APPDATA1 ( CUST_ID INT NOT NULL, ACTION VARCHAR(10), USER_UP VARCHAR(25), DATETIME_UP TIMESTAMP,CONSTRAINT PK_AD PRIMARY KEY(CUST_ID) )CREATE TRIGGER TRACK_CUSTOMER_UPDATES ON APPDATA FOR UPDATEAS SELECT CUST_ID, 'UPDATE', CURRENT_USER, CURRENT_TIMESTAMP
CREATE TABLE APPDATA ( CUST_ID INT NOT NULL, ACTION VARCHAR(10), USER_UP VARCHAR(25), DATETIME_UP TIMESTAMP,CONSTRAINT PK_AD PRIMARY KEY(CUST_ID) )CREATE TABLE APPDATA1 ( CUST_ID INT NOT NULL, ACTION VARCHAR(10), USER_UP VARCHAR(25), DATETIME_UP TIMESTAMP,CONSTRAINT PK_AD PRIMARY KEY(CUST_ID) )CREATE TRIGGER TRACK_CUSTOMER_UPDATES ON APPDATA FOR UPDATEAS INSERT INTO APPDATA1 ( CUST_ID, ACTION, USER_UP, DATETIME_UP ) SELECT CUST_ID, 'UPDATE', CURRENT_USER, CURRENT_TIMESTAMP FROM INSERTED(Верный ответ)
CREATE TABLE APPDATA ( CUST_ID INT NOT NULL, ACTION VARCHAR(10), USER_UP VARCHAR(25), DATETIME_UP TIMESTAMP,CONSTRAINT PK_AD PRIMARY KEY(CUST_ID) )CREATE TRIGGER TRACK_CUSTOMER_UPDATES ON APPDATA FOR UPDATEAS INSERT INTO APPDATA ( CUST_ID, ACTION, USER_UP, DATETIME_UP ) SELECT CUST_ID, 'UPDATE', CURRENT_USER, CURRENT_TIMESTAMP FROM INSERTED