exp_032.htm

来自「oracle DBA的资料」· HTM 代码 · 共 42 行

HTM
42
字号
<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=gb2312">
<title>Ocp test </title>
</head>
<body bgcolor="white" text="black" link="blue" vlink="purple" alink="red">
<p><b><span style="font-size:22pt">Explaination 032: &nbsp;</span></b></p>

<span style="font-size:18pt">
	<p>
	These statements show correct syntax and semantics to receive correct results. <br>
	</p>

	<p>
	  Incorrect Answers <br>
	</p>

	<p>
	  A: JOIN ON keywords need to be used to build correct query. <br>
	</p>

	<p>
	  C: This query will built Cartesian product because there is no join conditions in WHERE clause to join tables. <br>
	</p>

	<p>
	  E: NATURAL JOIN is a join between two where Oracle joins the tables according to the column(s) in the two tables sharing the same name. It is required to add one more NATURAL JOIN clause to join additional table. <br>
	</p>

	<p>
	  OCP Introduction to Oracle 9i: SQL Exam Guide, Jason Couchman, p. 98-118 <br>
	</p>

	<p>
	  Chapter 3: Advanced Data Selection in Oracle
	</p>

</span>

</body>
</html>
<br>

⌨️ 快捷键说明

复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?