单项选择题
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
