📄 exp_020.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 020: &nbsp;</span></b></p>

<span style="font-size:18pt">
	<p>
	This query shows correct JOIN ON clause syntax and provides equivalent to the above SQL statement. <br>
	</p>

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

	<p>
	  A: This statement will show data only for the EMPLOYEES table with records that have department ID from DEPARTMENTS table, not join result of two tables. <br>
	</p>

	<p>
	  B: NATURAL join selects rows from the tables that have equal values in all matched columns (same column names). If the columns having the same names have different datatypes, an error is returned. <br>
	</p>

	<p>
	  D: There is incorrect usage of JOIN clause with USING keyword. <br>
	</p>

	<p>
	  OCP Introduction to Oracle 9i: SQL Exam Guide, Jason Couchman, p. 112-114 <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 + -