📄 exp_001.htm
字号:
<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=gb2312">
<title>无标题</title>
</head>
<body bgcolor="white" text="black" link="blue" vlink="purple" alink="red">
<p><span style="font-size:16pt;">Explanation to Question 1: </span></p>
<p><span style="font-size:16pt;">Answer F is correct. This query shows correct syntax to retrieve all employees,
whether or not </span></p>
<p><span style="font-size:16pt;">they have matching departments in the department table. Oracle9i extends
ts compliance with ANSI/ISO by supporting that standard's requirements for outer join syntax
and semantics. </span></p>
<p><span style="font-size:16pt;">Incorrect Answers </span></p>
<p><span style="font-size:16pt;">A: This query uses "+" to create outer join as it was in Oracle8i,
but it requires also usage of WHERE clause in SELECT statement. </span></p>
<p><span style="font-size:16pt;">B: The JOIN clause cannot be used with in conjunction with "+":
syntax is incorrect. </span></p>
<p><span style="font-size:16pt;">C: The JOIN clause cannot be used with in conjunction with "+":
syntax is incorrect. </span></p>
<p><span style="font-size:16pt;">D: This statement requires LEFT OUTER JOIN, not RIGHT OUTER JOIN. </span></p>
<p><span style="font-size:16pt;">E: This query uses incorrect syntax with "+" and ON to create outer
join. <br> </span></p>
<p><span style="font-size:16pt;">OCP Introduction to Oracle 9i: SQL Exam Guide, Jason Couchman, p. 112-114
</span></p>
<p><span style="font-size:16pt;">Chapter 3: Advanced Data Selection in Oracle </span></p>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -