A.GRANT ADD DATA ON TABLE tab1 TO GROUP tom appgrp
B.GRANT INSERT TO USER tom, GROUP appgrp ON TABLE tab1
C.GRANT INSERT ON TABLE tab1 TO USER tom, GROUP appgrp
D.GRANT ADD DATA ON TABLE tab1 TO USER appgrp, GROUP tom
您可能感兴趣的试卷
你可能感兴趣的试题
A.REFERENCES
B.SELECT
C.UPDATE
D.ALTER
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.Table
B.Columns
C.Table and Alias
D.Columns and Alias
A.View
B.Table
C.Routine
D.Package
A.Instance
B.Table space
C.System catalog
D.Schema repository
A.View
B.Alias
C.Table
D.Package
A.Alias
B.View
C.Schema
D.Trigger
最新试题
A UDT is a data type which:()
CREATE TABLE customer (cid BIGINT NOT NULL PRIMARY KEY, info XML) How many names will be returned for this XQuery?()
The opening of cursor CSR01 produces the following result set:STUDENT LASTNM FIRSTNM CLASSNO 123 Brown John T100 213 Bailey JamesT100 312 Carter Arlene T210 465 Chas Devon T305 546 Davis Steven T405If this Fetch statement is executed: FETCH csr01 INTO :studnum, :firstname, :lastname, :class Which of the following DELETE statements will cause this row to be deleted?()
Given that tables T1 and T2 contain the following rows:Table T1: C1 C2 1 4 1 3 1 2Table T2: C1 C2 1 1 1 2 1 3Which of the following queries will return only those rows that exist in both T1 and T2?()
Which of the following statements is used to grant user TOM and Application team APPGRP the ability to add data to table TAB1?()
Which of the following database objects can be used to raise an error if a table is updated?()
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?()
Which of the following constraint types can be used to ensure the value of an INTEGER column references only positive values?()
Which of the following SQL statements will return the year and average salary for all employees hired within a given year that have a salary greater than $30,000?()
Which kind of non-sourced UDF can be created so that it only returns a single value?()