📄 que_001.htm
字号:
<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=gb2312">
<title>QUESTION 1 </title>
<meta name="generator" content="Namo WebEditor v5.0">
</head>
<body bgcolor="white" text="black" link="blue" vlink="purple" alink="red">
<form name="form2">
<p align="left"> <font face="Comic Sans MS" color="black"><span style="font-size:18pt;"><b>QUESTION 1</b></span></font><font face="Comic Sans MS" color="#99CCFF"><span style="font-size:18pt;"><b> </b></span></font></p>
</form>
<hr color="#99CCFF">
<p><span style="font-size:16pt;">Examine the data in the EMPLOYEES and DEPARTMENTS tables. </span></p>
<p><span style="font-size:16pt;">EMPLOYEES:</span></p>
<table border="1" bordercolor="gray">
<tr>
<td width="232" align="center" bgcolor="#99CCFF">
<p><b>LAST_NAME</b></p>
</td>
<td width="232" align="center" bgcolor="#99CCFF">
<p><b>DEPARTMENT_ID</b></p>
</td>
<td width="232" align="center" bgcolor="#99CCFF">
<p><b>SALARY</b></p>
</td>
</tr>
<tr>
<td width="232" align="center" bgcolor="white">
<p>Gets</p>
</td>
<td width="232" align="center" bgcolor="white">
<p>10</p>
</td>
<td width="232" align="center" bgcolor="white">
<p>3000</p>
</td>
</tr>
<tr>
<td width="232" align="center" bgcolor="white">
<p>Davis</p>
</td>
<td width="232" align="center" bgcolor="white">
<p>20</p>
</td>
<td width="232" align="center" bgcolor="white">
<p>1500</p>
</td>
</tr>
<tr>
<td width="232" align="center" bgcolor="white">
<p>King</p>
</td>
<td width="232" align="center" bgcolor="white">
<p>20</p>
</td>
<td width="232" align="center" bgcolor="white">
<p>2200</p>
</td>
</tr>
<tr>
<td width="232" align="center" bgcolor="white">
<p>Davis</p>
</td>
<td width="232" align="center" bgcolor="white">
<p>30</p>
</td>
<td width="232" align="center" bgcolor="white">
<p>5000</p>
</td>
</tr>
<tr>
<td width="232" align="center" bgcolor="white">
<p>Kochhar</p>
</td>
<td width="232" align="center" bgcolor="white">
<p> </p>
</td>
<td width="232" align="center" bgcolor="white">
<p>5000</p>
</td>
</tr>
</table>
<p><span style="font-size:16pt;">DEPARTMENTS:</span></p>
<table border="1" width="481" bordercolor="gray">
<tr>
<td width="232" align="center" bgcolor="#99CCFF">
<p><b>DEPARTMENT_ID</b></p>
</td>
<td width="233" align="center" bgcolor="#99CCFF">
<p><b>DEPARTMENT_NAME</b></p>
</td>
</tr>
<tr>
<td width="232" align="center" bgcolor="white">
<p>10</p>
</td>
<td width="233" align="center" bgcolor="white">
<p>Sales </p>
</td>
</tr>
<tr>
<td width="232" align="center" bgcolor="white">
<p>20</p>
</td>
<td width="233" align="center" bgcolor="white">
<p>Marketing</p>
</td>
</tr>
<tr>
<td width="232" align="center" bgcolor="white">
<p>30</p>
</td>
<td width="233" align="center" bgcolor="white">
<p>Accounts</p>
</td>
</tr>
<tr>
<td width="232" align="center" bgcolor="white">
<p>40</p>
</td>
<td width="233" align="center" bgcolor="white">
<p>Administration</p>
</td>
</tr>
</table>
<p><span style="font-size:16pt;">You want to retrieve all employees, whether or not they have matching departments
in the departments table. Which query would you use? </span></p>
<table border="1" bordercolor="gray" width="665">
<form name="youAnsForm">
<span style="font-size:16pt;">
<tr>
<td align="center" width="89">
<p><b><input type="radio" name="AN" value="A"> A.</b></p>
</td>
<td align="left" width="566">
<p> SELECT last_name, department_name<br>
FROM employees , departments(+);
</p>
</td>
</tr>
<tr>
<td align="center" width="89">
<p><b><input type="radio" name="AN" value="B"> B.</b></p>
</td>
<td align="left" width="566">
<p> SELECT last_name, department_name<br>
FROM employees JOIN departments (+);
</p>
</td>
</tr>
<tr>
<td align="center" width="89">
<p><b><input type="radio" name="AN" value="C"> C.</b></p>
</td>
<td align="left" width="566">
<p> SELECT last_name, department_name<br>
FROM employees(+) e JOIN departments d<br>
ON (e.department_id = d.department_id);
</p>
</td>
</tr>
<tr>
<td align="center" width="89">
<p><b><input type="radio" name="AN" value="D"> D.</b></p>
</td>
<td align="left" width="566">
<p> SELECT last_name, department_name<br>
FROM employees e<br>
RIGHT OUTER JOIN departments d ON (e.department_id = d.department_id);
</p>
</td>
</tr>
<tr>
<td align="center" width="89">
<p><b><input type="radio" name="AN" value="E"> E.</b></p>
</td>
<td align="left" width="566">
<p> SELECT last_name, department_name<br>
FROM employees(+) , departments<br>
ON (e.department_id = d.department_id);
</p>
</td>
</tr>
<tr>
<td align="center" width="89">
<p><b><input type="radio" name="AN" value="F"> F.</b></p>
</td>
<td align="left" width="566">
<p> SELECT last_name, department_name<br>
FROM employees e LEFT OUTER<br>
JOIN departments d ON (e.department_id = d.department_id)</p>
</td>
</tr>
</span>
</form>
</table>
</table>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -