The following statements are executed:
GRANT CREATETAB, DATAACCESS, ON DATABASE TO ROLE role A;
GRANT CREATETAB, BINDADD ON DATABASE TO ROLE role B;
GRANT ROLE role A to USER db2inst3;
GRANT ROLE role B to USER db2inst3;
Which of the following is TRUE if this statement is executed later?
REVOKE ROLE roleB FROM USER db2inst3;
Which of the following DB2 objects in an efficient way of representing data without the need to maintain it and requires no permanent storage?
Which constraint can be used to ensure that identical values are never stored in a set of columns in a table?
BLU Acceleration is included in which of the following edition of DB2 LUW? (Choose two.)
A user executes the following statements:
REATE TABLE t1 (c1 INT, c2 INT);
CREATE ALIAS a1 FOR t1;
What will be the result if the user executes the following statement?
DROP ALIAS a1;
