CONTROL
UPDATE
USAGE
ALTER
单选题Given the following ALTER SEQUENCE statement: ALTER SEQUENCE myseq RESTART WITH 0 INCREMENT BY 1 NO MAXVALUE CACHE 5 ORDER Assuming that the sequence had reached a value of 100 prior to the RESTART, which of the following is true?()A The next value will be 0 and the sequence will never use the values 101 to 105.B The next value will be 101 to ensure uniqueness between existing and newly generated sequence values.C Previously cached values are retained by DB2, and after the restart, will be used for values 101 to 105.D The next value will be 0 and DB2 will not ensure uniqueness between existing and newly generated values.
点击查看答案
单选题Which of the following statements is used to revoke all DML privileges on table EMPLOYEE from user TOM?()A REVOKE ALL PRIVILEGES FROM USER tomB REVOKE ALL ON EMPLOYEE FROM USER tomC REVOKE EXECUTE ON EMPLOYEE FROM USER tomD REVOKE PRIVILEGES ON EMPLOYEE FROM USER tom
单选题User A executes the following command to update the TRANS table) SQL> UPDATE B.trans SET tr_amt=tr_amt+500 WHERE c_code=’C005’; Before user A issues a COMMIT or ROLLBACK command, user B executes the following command on the TRANS table: SQl> ALTER TABLE trans MODIFY (tr_type VARCHAR2 (3)); What would happen in this scenario?()A The transaction for user A is rolled back.B The ALTER TABLE command modifies the column successfully.C The ALTER TABLE command fails due to the resource being busy.D The ALTER TABLE command waits until user A ends the transaction.
单选题A user needs to create a trigger that will update table T2 whenever a row is added to table T1. Assuming the user has all appropriate privileges for table T2, which privilege is required on table T1 to create the trigger?()A REFERENCESB SELECTC UPDATED ALTER
单选题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 TableB ColumnsC Table and AliasD Columns and Alias
单选题Assuming PUBLIC has been granted all privileges on table T1, which of the following statements would continue to permit any user to add rows to table T1, but not remove them?()A REVOKE DROP ON t1 FROM PUBLICB REVOKE UPDATE ON t1 FROM PUBLICC REVOKE DELETE ON t1 FROM PUBLICD REVOKE CONTROL ON t1 FROM PUBLIC
单选题Which of the following privileges permits a user to update the comment on a sequence?()A CONTROLB UPDATEC USAGED ALTER