que_033.htm

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

<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 align="left" color="black" style="font-size:16pt;">
	<b>QUESTION 033	</b>
</p><hr color="#99CCFF">

<p>Examine the description of the EMPLOYEES table: </p><table border="1" bordercolor="gray">
	<tr>
		<td align="left" width="486" bgcolor="#99CCFF">
			<p><b>EMPLOYEES  table:  </b></p>
		</td>
	</tr>
	<tr>
		<td align="left" bgcolor="white">
			<p><b>EMP_ID  NUMBER(4)  NOT  NULL  </b></p>
		</td>
	</tr>
	<tr>
		<td align="left" bgcolor="white">
			<p><b>LAST_NAME  VARCHAR2(30)  NOT  NULL  </b></p>
		</td>
	</tr>
	<tr>
		<td align="left" bgcolor="white">
			<p><b>FIRST_NAME  VARCHAR2(30)  </b></p>
		</td>
	</tr>
	<tr>
		<td align="left" bgcolor="white">
			<p><b>DEPT_ID  NUMBER(2)  </b></p>
		</td>
	</tr>
	<tr>
		<td align="left" bgcolor="white">
			<p><b>JOB_CAT  VARCHAR2(30)  </b></p>
		</td>
	</tr>
	<tr>
		<td align="left" bgcolor="white">
			<p><b>SALARY  NUMBER(8,2)  </b></p>
		</td>
	</tr>
</table>
<p>Which statement shows the department ID, minimum salary, and maximum salary paid in that department, only of the minimum salary is less then 5000 and the maximum salary is more than 15000? </p><table border="1" bordercolor="gray" width="665">
	<form name="youAnsForm">
	<span style="font-size:18pt;">
	<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 dept_id, MIN(salary(, MAX(salary) <br>
			  FROM employees <br>
			  WHERE MIN(salary) < 5000 AND MAX(salary) > 15000; 
			</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 dept_id, MIN(salary), MAX(salary) <br>
			  FROM employees <br>
			  WHERE MIN(salary) < 5000 AND MAX(salary) > 15000 <br>
			  GROUP BY dept_id; 
			</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 dept_id, MIN(salary), MAX(salary) <br>
			  FROM employees <br>
			  HAVING MIN(salary) < 5000 AND MAX(salary) > 15000; 
			</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 dept_id, MIN(salary), MAX(salary) <br>
			  FROM employees <br>
			  GROUP BY dept_id <br>
			  HAVING MIN(salary) < 5000 AND MAX(salary) > 15000; 
			</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 dept_id, MIN(salary), MAX(salary) <br>
			  FROM employees <br>
			  GROUP BY dept_id, salary <br>
			  HAVING MIN(salary) < 5000 AND MAX(salary) > 15000;</b></p>
		</td>
	</tr>
	</span>
	</form>
</table>

</body>
</html>
<br>