单项选择题

A.REFERENCESB.SELECTC.UPDATED.ALTERA user needs to crea……

A user needs to create a trigger that will update table T2 whenever a row is added to table T1. Assuming the user has all appropriate privileges for table T2, which privilege is required on table T1 to create the trigger?（）

A.REFERENCES
B.SELECT
C.UPDATE
D.ALTER

<上一题目录下一题>

热门试题

单项选择题Assuming PUBLIC has been granted all privileges on table T1, which of the following statements would continue to permit any user to add rows to table T1, but not remove them?（）

A.REVOKE DROP ON t1 FROM PUBLIC
B.REVOKE UPDATE ON t1 FROM PUBLIC
C.REVOKE DELETE ON t1 FROM PUBLIC
D.REVOKE CONTROL ON t1 FROM PUBLIC

单项选择题A user utilizing an alias to update a subset of columns in a table must have UPDATE privileges on which of the following DB2 objects?（）

A.Table
B.Columns
C.Table and Alias
D.Columns and Alias

单项选择题Given the following DDL and INSERT statements: CREATE VIEW v1 AS SELECT col1 FROM t1 WHERE col1 > 10; CREATE VIEW v2 AS SELECT col1 FROM v1 WITH CASCADED CHECK OPTION; CREATE VIEW v3 AS SELECT col1 FROM v2 WHERE col1 < 100; INSERT INTO v1 VALUES(5); INSERT INTO v2 VALUES(5); INSERT INTO v3 VALUES(20); INSERT INTO v3 VALUES(100); How many of these INSERT statements will be successful?（）

A.0
B.1
C.2
D.3

单项选择题Which of the following database objects is considered executable using SQL?（）

A.View
B.Table
C.Routine
D.Package

单项选择题Which of the following describes the objects of a DB2 database and their relationships?（）

A.Instance
B.Table space
C.System catalog
D.Schema repository