📄 que_041.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 041 </b>
</p><hr color="#99CCFF">
<p>The ORDERS table has these columns: </p><table border="1" bordercolor="gray">
<tr>
<td align="left" width="486" bgcolor="#99CCFF">
<p><b>The ORDERS table</b></p>
</td>
</tr>
<tr>
<td align="left" bgcolor="white">
<p><b>ORDER_ID NUMBER(4) NOT NULL </b></p>
</td>
</tr>
<tr>
<td align="left" bgcolor="white">
<p><b>CUSTOMER_ID NUMBER(12) NOT NULL </b></p>
</td>
</tr>
<tr>
<td align="left" bgcolor="white">
<p><b>ORDER_TOTAL NUMBER(10,2) </b></p>
</td>
</tr>
</table>
<p>The ORDERS table tracks the Order number, the order total, and the customer to whom the Order belongs. Which two statements retrieve orders with an inclusive total that ranges between 100.00 and 2000.00 dollars? (Choose two.) </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="checkbox" name="AN" value="A"> A.</b></p>
</td>
<td align="left" width="566">
<p> SELECT customer_id, order_id, order_total <br>
FROM orders <br>
RANGE ON order_total (100 AND 2000) INCLUSIVE;
</p>
</td>
</tr>
<tr>
<td align="center" width="89">
<p><b><input type="checkbox" name="AN" value="B"> B.</b></p>
</td>
<td align="left" width="566">
<p> SELECT customer_id, order_id, order_total <br>
FROM orders <br>
HAVING order_total BETWEEN 100 and 2000;
</p>
</td>
</tr>
<tr>
<td align="center" width="89">
<p><b><input type="checkbox" name="AN" value="C"> C.</b></p>
</td>
<td align="left" width="566">
<p> SELECT customer_id, order_id, order_total <br>
FROM orders <br>
WHERE order_total BETWEEN 100 and 2000;
</p>
</td>
</tr>
<tr>
<td align="center" width="89">
<p><b><input type="checkbox" name="AN" value="D"> D.</b></p>
</td>
<td align="left" width="566">
<p> SELECT customer_id, order_id, order_total <br>
FROM orders <br>
WHERE order_total >= 100 and <= 2000;
</p>
</td>
</tr>
<tr>
<td align="center" width="89">
<p><b><input type="checkbox" name="AN" value="E"> E.</b></p>
</td>
<td align="left" width="566">
<p> SELECT customer_id, order_id, order_total <br>
FROM orders <br>
WHERE order_total >= 100 and order_total <= 2000;</b></p>
</td>
</tr>
</span>
</form>
</table>
</body>
</html>
<br>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -