单项选择题

Which of the following actions may cause a trigger to be fired?（）

A.DROP
B.ALTER
C.DELETE
D.ROLLBACK

点击查看答案

上一题目录下一题

相关考题

单项选择题

What type of constraint is used to ensure that each row inserted into the EMPLOYEE table with a value in the WORKDEPT column has a row with a corresponding value in the DEPTNO column of the DEPARTMENT table?（）

A.A check constraint on the EMPLOYEE table
B.A unique constraint on the EMPLOYEE table WORKDEPT column
C.A foreign key reference from the DEPARTMENT tables DEPTNO column to the WORKDEPT column of the EMPLOYEE table
D.A foreign key reference from the EMPLOYEE tables WORKDEPT column to the DEPTNO column of the DEPARTMENT table

单项选择题

Which of the following constraint types can be used to ensure the value of an INTEGER column references only positive values?（）

A.Unique
B.Check
C.Referential
D.Informational

单项选择题

A view is created with the following statement:CREATE VIEW v1 AS SELECT col1, col2, col3 FROM t1 WHERE col4 > 1000 ; When will DB2 access the data from table T1 for view V1?（）

A.When view V1 is created
B.Each time the REFRESH VIEW v1 statement is executed
C.Each time an SQL statement is executed against view V1
D.Only the first time an SQL statement is executed against view V1

备案号：湘ICP备2022003000号-1

微信扫一扫,加关注免费搜题