网友您好， 请在下方输入框内输入要搜索的题目：

题目内容 （请给出正确答案）
单选题
Which of the following privileges permits a user to update the comment on a sequence?（）
A

CONTROL

B

UPDATE

C

USAGE

D

ALTER

参考答案

参考解析
解析： 暂无解析
更多 “单选题Which of the following privileges permits a user to update the comment on a sequence?（）A CONTROLB UPDATEC USAGED ALTER” 相关考题
考题 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
查看答案
考题 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
查看答案
考题 Which of the following privileges permits a user to update the comment on a sequence?() A.CONTROLB.UPDATEC.USAGED.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.
查看答案
考题 更改oracle用户HR，使其变为不可用（锁定）状态（）A、UPDATE  USER  HR  ACCOUNT  DISABLEB、UPDATE  USER  HR  ACCOUNT  LOCKC、ALTER USER  HR  ACCOUNT  DISABLED、ALTER USER  HR  ACCOUNT  LOCK
查看答案
考题 Which of the following groups should a user be added to for the ability to restore files, withoutgranting any ownership privileges?（）A、Remote Desktop UsersB、Power UsersC、AdministratorsD、Backup Operators
查看答案
考题 Which of the following approval member groups can an organization administrator grant privileges to？（）A、ApprovalGroupB、Order ProcessC、User GroupD、User RegistrationE、AccessGroup
查看答案
考题 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
查看答案
考题 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
查看答案
考题 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
查看答案
考题 Which of the following privileges permits a user to update the comment on a sequence?（）A、CONTROLB、UPDATEC、USAGED、ALTER
查看答案
考题 Which object privileges can be granted on a view? （）A、noneB、DELETE, INSERT,SELECTC、ALTER, DELETE, INSERT, SELECTD、DELETE, INSERT, SELECT, UPDATE
查看答案
考题 The DBA is defining role for users. Which of the following is not an acceptable method for defining a default role?（）A、ALTER USER DEFAULT ROLE ALLB、ALTER USER DEFAULT ROLE ALL EXCEPT ROLE_1C、ALTER USER DEFAULT ROLE NONED、ALTER USER DEFAULT ROLE NONE EXCEPT ROLE_1
查看答案
考题 You are attempting to clear an unarchived redo log file. In order to manually enact a log switch, which of the following statements is appropriate?（）A、ALTER DATABASE B、ALTER SYSTEM C、ALTER USER D、ALTER REDO LOG
查看答案
考题 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.
查看答案
考题 The user HR owns the EMP table. The user HR grants privileges to the user SCOTT by using this command：  SQL GRANT SELECT，INSERT，UPDATE ON emp TO scott WITH GRANT OPTION； The user SCOTT executes this command to grant privileges to the user JIM： SQL GRANT SELECT，INSERT，UPDATE ON hr.emp TO jim；  Now， the user HR decides to revoke privileges from JIM using this command： SQL REVOKE SELECT，INSERT，UPDATE ON emp FROM jim； Which statement is true after HR issues the REVOKE command（）A、The command fails because SCOTT still has privileges.B、The command succeeds and privileges are revoked from JIM.C、The command fails because HR cannot revoke the privileges from JIM.D、The command succeeds and only HR has the privilege to perform the SELECT， INSERT， and UPDATEoperations on the EMP table.
查看答案
考题 User A issues the command: LOCK TABLES pets READ; Which command can User B execute against the pets table?（）A、UPDATE pets…B、SELECT….FROM petsC、INSERT INTO pets…D、ALTER TABLE pets…
查看答案
考题 单选题Which of the following roles provides the privileges to maintain and query the recovery catalog schema？（）A EXECUTE_CATALOG_ROLEB CONNECTC RESOURCED RECOVERY_CATALOG_OWNERE RECOVERY_CATALOG_USER
查看答案
考题 单选题View the Exhibit and examine the parameters. User A executes the following command to update the TRANStable： SQL UPDATE B.trans SET tr_amt=tr_amt+500 WHERE c_code=’C005’； Before user A issues a COMMIT orROLLBACK 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 ALTER TABLE command modifies the column successfully.B The DDL operation gets higher priority and transaction for user A is rolled back.C The ALTER TABLE command waits indefinitely until user A ends the transaction.D The ALTER TABLE command fails after waiting for 60 seconds due to the resource being busy
查看答案
考题 单选题The user HR owns the EMP table. The user HR grants privileges to the user SCOTT by using this command：  SQL GRANT SELECT，INSERT，UPDATE ON emp TO scott WITH GRANT OPTION； The user SCOTT executes this command to grant privileges to the user JIM： SQL GRANT SELECT，INSERT，UPDATE ON hr.emp TO jim；  Now， the user HR decides to revoke privileges from JIM using this command： SQL REVOKE SELECT，INSERT，UPDATE ON emp FROM jim； Which statement is true after HR issues the REVOKE command（）A The command fails because SCOTT still has privileges.B The command succeeds and privileges are revoked from JIM.C The command fails because HR cannot revoke the privileges from JIM.D The command succeeds and only HR has the privilege to perform the SELECT， INSERT， and UPDATEoperations on the EMP table.
查看答案
考题 单选题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
查看答案
热门标签
最新试卷