1 select e.employee_id,e.last_name,e.department_id,d.department_name from employees e,department d
where e.department_id=d.department_id
in the statement,which capabilities of SELECT statement are performed?
A. selection,projection,join
B. difference,projection,join
C. selection,intersection,join
D. intersection,projection,join
E. difference,projection,join
2 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
请问这两题应该怎么理解题目的意思?
where e.department_id=d.department_id
in the statement,which capabilities of SELECT statement are performed?
A. selection,projection,join
B. difference,projection,join
C. selection,intersection,join
D. intersection,projection,join
E. difference,projection,join
2 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
请问这两题应该怎么理解题目的意思?
解决方案 »
- 关于start with查询问题
- Pro*c获取UPDATE或INSERT影响条数
- 连接Oracle数据库编程问题?
- ORACLE专业级技术交流平台(18891623) 欢迎专业人士加入
- 求一存储过程,小弟新手!~急!~
- ORA-00905:缺少关键字
- 简单的建立视图问题,请高手指点!!!
- 英文Widows XP下Oracle9i中的汉字在程序中显示为乱码,是为什么??急急!!在线等待!
- 急求几本书!!!!!!谢谢大家帮忙,来者有分!
- oracle 中如何修改表的字段名(高手指点)
- oracle批量提交,autocommit设置
- ora-12514:tns:监听程序当前无法识别连接描述符中请求的服务,是什么错误呢?
2、user用户下哪个视图可以看到栏位和约束的关联:USER_CONSTRAINTS