📄 que_033.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 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>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -