📄 que_066.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 066 </b>
</p><hr color="#99CCFF">
<p>Mary has a view called EMP_DEPT_LOC_VU that was created based on the EMPLOYEES, DEPARTMENTS, and LOCATIONS tables. She granted SELECT privilege to Scott on this view.
Which option enables Scott to eliminate the need to qualify the view with the name MARY .EMP_DEP_LOC_VU each time the view is referenced? </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> Scott can create a synonym for the EMP_DEPT_LOC_VU bus using the command: <br>
CREATE PRIVATE SYNONYM EDL_VU <br>
FOR mary.EMP DEPT_LOC_VU; <br>
then he can prefix the columns with this synonymn.
</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> Scott can create a synonym for the EMP_DEPT_LOC_VU by using the command: <br>
CREATE SYNONYM EDL_VU <br>
FOR mary.EMP_DEPT_LOC_VU; <br>
then he can prefix the columns with this synonym.
</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> Scott can create a synonym for the EMP_DEPT_LOC_VU by using the command: <br>
CREATE LOCAL SYNONYM EDL_VU <br>
FOR mary.EMP DEPT_LOC_VU; <br>
then he can prefix the columns with this synonym.
</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> Scott can create a synonym for the EMP_DEPT_LOC_VU by using the command: <br>
CREATE SYNONYM EDL_VU <br>
ON mary(EMP_DEPT_LOC_VU); <br>
then he can prefix the columns with this synonym.
</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> Scott cannot create a synonym because synonyms can be created only for tables.
</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> Scott cannot create any synonym for Mary's view. Mary should create a private synonym for the view and grant SELECT privilege on that synonym to Scott.</b></p>
</td>
</tr>
</span>
</form>
</table>
</body>
</html>
<br>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -