违法和不良信息举报 联系客服
免费注册 登录

Which view should a user query to display the columns associ

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

参考答案和解析
正确答案： E
解析： 暂无解析
如果没有搜索结果或未解决您的问题，请直接 联系老师 获取答案。
相似问题和答案

第1题：

The EMP table contains these columns:You need to display the employees who have not been assigned to any department.You write the SELECT statement:What is true about this SQL statement?()

A. The SQL statement displays the desired results.

B. The column in the WHERE clause should be changed to display the desired results.

C. The operator in the WHERE clause should be changed to display the desired results.

D. The WHERE clause should be changed to use an outer join to display the desired results.


参考答案：C

第2题：

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

第3题：

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

第4题：

Which of the following abilities does a view NOT provide？（）

  • A、Change which columns show
  • B、Open a view from another database
  • C、Contain custom controls
  • D、Identify a column to act as a link

正确答案:C

第5题：

 Derek has created a view in the sales.nsf db. Derek wants the sales value column in the view to be punctuated to display two decimal places . which one of the following should he do?（）

  • A、 use the @function @decimal in the column formula in the view 
  • B、 select decimal on the numbers tab in the view properties box 
  • C、 select decimal on the numbers tab in the column properties box
  • D、 use the @function @decimal to format the value in the field on the form that will display in the view 

正确答案:C

第6题：

Derek has created a view in the products.nsf database. Derek wants the markup column in the view to display the selling price of the cost. He wants this value to display in currency. Which one of the following should derekl do? （）

  • A、 use the @currenty in thr column formula in the view  
  • B、 Select currency on the numbers tab in the view properties box 
  • C、 Select currency on the numbers tab in the column properties box 
  • D、 Select currency on the numbers tab in the field properties box 

正确答案:C

第7题：

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

第8题：

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

第9题：

You need to perform certain data manipulation operations through a view called EMP_DEPT_VU, which you previously created. You want to look at the definition of the view (the SELECT statement on which the view was create.) How do you obtain the definition of the view? （）

  • A、Use the DESCRIBE command in the EMP_DEPT VU view.
  • B、Use the DEFINE VIEW command on the EMP_DEPT VU view.
  • C、Use the DESCRIBE VIEW command on the EMP_DEPT VU view.
  • D、Query the USER_VIEWS data dictionary view to search for the EMP_DEPT_VU view.
  • E、Query the USER_SOURCE data dictionary view to search for the EMP_DEPT_VU view.
  • F、Query the USER_OBJECTS data dictionary view to search for the EMP_DEPT_VU view.

正确答案:D

第10题：

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

更多相关问题
相关内容