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
Get 50% Discount on All Your Purchases
at PrepAway.com - Latest Exam Questions
This is ONE TIME OFFER
50%
UPDATE (column-name,…)
Grants the privilege to use the UPDATE statement to update only those columns specified in the column list. Each column-name must be an unqualified name that identifies a column of the table or view identified in the ON clause. Column level UPDATE privilege cannot be granted on typed tables, typed views, or nicknames (SQLSTATE 42997).
0
0