Which of the following privileges permits a user to update the comment on a sequence?()A、CONTROLB、UPDATEC、USAGED、ALTER

题目

Which of the following privileges permits a user to update the comment on a sequence?()

  • A、CONTROL
  • B、UPDATE
  • C、USAGE
  • D、ALTER
如果没有搜索结果或未解决您的问题,请直接 联系老师 获取答案。
相似问题和答案

第1题:

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.REFERENCES

B.SELECT

C.UPDATE

D.ALTER


参考答案:D

第2题:

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.Table

B.Columns

C.Table and Alias

D.Columns and Alias


参考答案:A

第3题:

The user SYS creates a job by using the following command:Which two statements are true about the job that was created by the preceding command?()

A. The job is enabled by default after creation

B. The job is automatically dropped after the end date

C. The job executes with the privileges of the user SYS

D.


参考答案:B, C

第4题:

更改oracle用户HR,使其变为不可用(锁定)状态()

  • A、UPDATE  USER  HR  ACCOUNT  DISABLE
  • B、UPDATE  USER  HR  ACCOUNT  LOCK
  • C、ALTER USER  HR  ACCOUNT  DISABLE
  • D、ALTER USER  HR  ACCOUNT  LOCK

正确答案:D

第5题:

Which of the following privileges permits a user to update the comment on a sequence?()

A.CONTROL

B.UPDATE

C.USAGE

D.ALTER


参考答案:D

第6题:

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 PUBLIC

B.REVOKE UPDATE ON t1 FROM PUBLIC

C.REVOKE DELETE ON t1 FROM PUBLIC

D.REVOKE CONTROL ON t1 FROM PUBLIC


参考答案:C

第7题:

Which of the following statements is used to revoke all DML privileges on table EMPLOYEE from user TOM?()

A.REVOKE ALL PRIVILEGES FROM USER tom

B.REVOKE ALL ON EMPLOYEE FROM USER tom

C.REVOKE EXECUTE ON EMPLOYEE FROM USER tom

D.REVOKE PRIVILEGES ON EMPLOYEE FROM USER tom


参考答案:B

第8题:

Which of the following groups should a user be added to for the ability to restore files, withoutgranting any ownership privileges?()

A. Remote Desktop Users

B. Power Users

C. Administrators

D. Backup Operators


参考答案:D

第9题:

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.

正确答案:D

第10题:

Which of the following allows a Windows 7 remote user to edit a file offline then automatically update the changes when back in the office?()

  • A、Windows Defender
  • B、Sync Center
  • C、Windows Aero
  • D、HomeGroup

正确答案:B

更多相关问题