7.Which two statements are true regarding the USING and ON clauses in table joins? (Choose two.)
来源:互联网 发布:双胞胎 双飞 知乎 编辑:程序博客网 时间:2024/04/29 18:05
7.Which two statements are true regarding the USING and ON clauses in table joins? (Choose two.)
A.Both USING and ON clauses can be used for equijoins and nonequijoins.
B.A maximum of one pair of columns can be joined between two tables using the ON clause.
C.The ON clause can be used to join tables on columns that have different names but compatible data types.
D.The WHERE clause can be used to apply additional conditions in SELECT statements containing the ON or the USING clause.
答案:CD
解析:using 只能用在equiue join ,而且必须列的名字要相同,类型可以不同,但是可以隐式转过去
on 可以用在等或不等的连接上,名字可以不等,类型可以不同,但是可以隐式转过去
A:错误
B:错误,只要名字一样就能连接,不是只有2个列
C:正确
D:正确,where是对结果集的筛选
A.Both USING and ON clauses can be used for equijoins and nonequijoins.
B.A maximum of one pair of columns can be joined between two tables using the ON clause.
C.The ON clause can be used to join tables on columns that have different names but compatible data types.
D.The WHERE clause can be used to apply additional conditions in SELECT statements containing the ON or the USING clause.
答案:CD
解析:using 只能用在equiue join ,而且必须列的名字要相同,类型可以不同,但是可以隐式转过去
on 可以用在等或不等的连接上,名字可以不等,类型可以不同,但是可以隐式转过去
A:错误
B:错误,只要名字一样就能连接,不是只有2个列
C:正确
D:正确,where是对结果集的筛选
0 0
- 7.Which two statements are true regarding the USING and ON clauses in table joins? (Choose two.)
- 121.Which two statements are true regarding the USING clause in table joins? (Choose two .)
- 170.Which two statements are true regarding the DELETE and TRUNCATE commands? (Choose two.)
- 35.Which two statements are true regarding constraints? (Choose two.)
- 38.Which two statements are true regarding views? (Choose two.)
- 41.Which two statements are true regarding views? (Choose two.)
- 48.Which two statements are true regarding indexes? (Choose two.)
- 133.Which two statements are true regarding subqueries? (Choose two.)
- 175.Which two statements are true regarding savepoints? (Choose two.)
- 130.Which two statements are true regarding listeners? (Choose two.)
- 98.Which two statements are true regarding the usage of the SQL*Loader utility? (Choose two.)
- 27.Which two statements are true regarding transactions in an Oracle database? (Choose two.)
- 67.Which two statements are true regarding the ORDER BY clause? (Choose two.)
- 108.Which two statements are true regarding the COUNT function? (Choose two.)
- 117.Which statements are true regarding the WHERE and HAVING clauses in a SELECT statement?
- 103.Which two statements are true regarding the Oracle Data Pump export and import operations? (Choo
- 4.Which two statements are true regarding single row functions? (Choose two.)
- 80.Which two statements are true regarding working with dates? (Choose two.)
- iOS获取xcassets中LaunchImage图片
- Java统计字符串中各种字母个数
- reason: 'launch path not accessible' abort() called 路径获取错误:
- Kafka+Storm+HDFS整合实践
- 修复TortoiseCVS图标显示问题
- 7.Which two statements are true regarding the USING and ON clauses in table joins? (Choose two.)
- UVALive 7344 I - Numbered Cards
- Hive 中的 Join 问题
- ASCII-转义字符
- 从QProcess说开来
- Poj 3216 Prime Path
- 亚马逊AWS和阿里云的员工数量和单兵营收能力几何
- 刷新页面更换CSS样式表-对网上document.write方式的修正
- shell编程基础