OCP-1Z0-新051-61题版本-14
来源:互联网 发布:数据采集兼职 编辑:程序博客网 时间:2024/06/01 08:47
QUESTION NO: 14
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
Answer: D
答案解析:
参考:http://docs.oracle.com/cd/E11882_01/server.112/e40402/statviews_1045.htm#REFRN20045
USER_CONS_COLUMNS
describes columns that are owned by the current user and that are specified in constraint definitions。
Explanation: view the columns associated with the constraint names in the USER_CONS_COLUMNS view.
Incorrect answer:
Atable to view all constraints definition and names
Bshow all object name belong to user
Cdoes not display column associated
Eno such view
Refer: Introduction to Oracle9i: SQL, Oracle University Study Guide, 10-25
- OCP-1Z0-新051-61题版本-14
- OCP-1Z0-新051-61题版本-61
- OCP-1Z0-新051-61题版本-1
- OCP-1Z0-新051-61题版本-2
- OCP-1Z0-新051-61题版本-3
- OCP-1Z0-新051-61题版本-4
- OCP-1Z0-新051-61题版本-5
- OCP-1Z0-新051-61题版本-6
- OCP-1Z0-新051-61题版本-7
- OCP-1Z0-新051-61题版本-8
- OCP-1Z0-新051-61题版本-9
- OCP-1Z0-新051-61题版本-10
- OCP-1Z0-新051-61题版本-11
- OCP-1Z0-新051-61题版本-12
- OCP-1Z0-新051-61题版本-13
- OCP-1Z0-新051-61题版本-15
- OCP-1Z0-新051-61题版本-16
- OCP-1Z0-新051-61题版本-17
- OCP-1Z0-新051-61题版本-11
- API创建员工地址
- OCP-1Z0-新051-61题版本-12
- OCP-1Z0-新051-61题版本-13
- 成功的钥匙?毅力——2013总结(经历)
- OCP-1Z0-新051-61题版本-14
- API创建员工
- 什么是逃逸分析(Escape Analysis)?
- OCP-1Z0-新051-61题版本-15
- OCP-1Z0-新051-61题版本-16
- 排錯體會
- Java--学习九九乘法表
- API创建员工联系人
- OCP-1Z0-新051-61题版本-17