📄 que_057.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 057 </b>
</p><hr color="#99CCFF">
<p>You need to create a view EMP_VU. The view should allow the users to manipulate the
records of only the employees that are working for departments 10 or 20.
Which SQL statement would you use to create the view EMP_VU? </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> CREATE VIEW emp_vu AS <br>
SELECT * <br>
FROM employees <br>
WHERE department_id IN (10,20);
</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> CREATE VIEW emp_vu AS <br>
SELECT * <br>
FROM employees <br>
WHERE department_id IN (10,20) <br>
WITH READ ONLY;
</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> CREATE VIEW emp_vu AS <br>
SELECT * <br>
FROM employees <br>
WHERE department_id IN (10,20) <br>
WITH CHECK OPTION;
</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> CREATE FORCE VIEW emp_vu AS <br>
SELECT * <br>
FROM employees <br>
WHERE department_id IN (10,20);
</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> CREATE FORCE VIEW emp_vu AS <br>
SELECT * <br>
FROM employees <br>
WHERE department_id IN (10,20) <br>
NO UPDATE;</b></p>
</td>
</tr>
</span>
</form>
</table>
</body>
</html>
<br>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -