📄 exp_032.htm

📁 oracle　DBA的资料

💻 HTM

字号:

<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 + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -