A.REVOKE SELECT FROM user2 ON TABLE org.tab1
B.REVOKE SELECT ON TABLE org.tab1 FROM user2
C.REVOKE READ ACCESS FROM user2 ON TABLE org.tab1
D.REVOKE READ ACCESS ON TABLE org.tab1 FROM user2
您可能感兴趣的试卷
你可能感兴趣的试题
A.Sequence
B.Schema
C.Group
D.View
A.User ID/password file
B.Communications layer
C.Client applications
D.Operating system
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
最新试题
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?()
An application needs a table for each connection that tracks the ID and Name of all items previously ordered and committed within the connection. The table also needs to be cleaned up and automatically removed each time a connection is ended. Assuming the ITEMS table was created with the following SQL statement:CREATE TABLE items item_no INT, item_name CHAR(5), item_qty INT)Which of the following SQL statements will provide the table definition that meets the specified requirements?()
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?()
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?()
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?()
Which of the following database objects is considered executable using SQL?()
Given the following two tables:TAB1 R1A A A B B C C D E TAB2 R2A A B B C C DWhich of the following queries returns the following result set? RETVAL E()
Given the following requirements:Create a table to contain employee data, with a unique numeric identifier automatically assigned when a row is added, has an EDLEVEL column that permits only the values 'C', 'H' and 'N', and permits inserts only when a corresponding value for the employee's department exists in the DEPARTMENT table.Which of the following CREATE statements will successfully create this table?()
An application needs to store a 5 MB JPEG image in a DB2 table. Which data type should be specified for the column that will be used for storing the image?()