IBM(000-730)

单选题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

题目
单选题
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
解析： 暂无解析
如果没有搜索结果，请直接 联系老师 获取答案。
相似问题和答案

第1题：

You need to replicate a table from a master to a slave. The master and slave copies of the table will have different number of columns.Which two conditions must be true?()

A.Each extra column in the copy with more columns must not have a default value

B.Columns that are common to both versions of the table must be defined in the same order on the master and the slave

C.The slave database cannot have more columns than the master. Only the master database can have more columns

D.Columns that are common to both versions of the table must come first in the table definition, before any additional columns are additional columns are defined on either server

E.The master database cannot have more columns than the slave. Only the slave deatbase can have more columns


参考答案：B, D

第2题：

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

第3题：

实现“取消用户USER4对学生表STUD中学号(XH)的修改权限”这一功能的SQL语句是( )。

A．REVOKE UPDATE (XH) ON TABLE FROM USER4;

B．REVOKE UPDATE (XH) ON TABLE STUD FROM PUBLIC ;

C．REVOKE UPDATE (XH) ON TABLE STUD FROM USER4;

D．REVOKE ALL PRIVILEGES ON TABLE STUD FROM USER4;


正确答案：C
解析：在SQL中取消用户对数据的权限的命令是REVOKE UPDATE ()。本题中括号内的参数应该是XH，取消的用户是USER4，取消的操作权限是STUD，位置是在TABLE表上。所以全部正确的就是C选项。

第4题：

You need to replicate a table from a master to a slave. The master and slave copies of the table will have different number of columns. Which two conditions must be true?（）

  • A、Each extra column in the copy with more columns must not have a default value
  • B、Columns that are common to both versions of the table must be defined in the same order on the master and the slave
  • C、The slave database cannot have more columns than the master. Only the master database can have more columns
  • D、Columns that are common to both versions of the table must come first in the table definition, before any additional columns are additional columns are defined on either server
  • E、The master database cannot have more columns than the slave. Only the slave deatbase can have more columns

正确答案:B,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题：

Which data dictionary table should you query to view the object privileges granted to the user on specific columns? ()

A. USER_TAB_PRIVS_MADE

B. USER_TAB_PRIVS

C. USER_COL_PRIVS_MADE

D. USER_COL_PRIVS


参考答案：D

第7题：

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

第8题：

Which view should a user query to display the columns associated with the constraints on a table owned by the user? ()

A. USER_CONSTRAINTS

B. USER_OBJECTS

C. ALL_CONSTRAINTS

D. USER_CONS_COLUMNS

E. USER_COLUMNS


参考答案：D

第9题：

Which table of EIGRP route information are held in RAM and maintained through the use of hello and update packets?（）

  • A、Neighbor table
  • B、SPF table
  • C、RTP table
  • D、Topology table
  • E、Query table
  • F、DUAL table

正确答案:A,D

第10题：

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

更多相关问题
相关内容