que_097.htm
来自「oracle DBA的资料」· HTM 代码 · 共 70 行
HTM
70 行
<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 097 </b>
</p><hr color="#99CCFF">
<p>You need to change the definition of an existing table. The COMMERCIALS table needs its DESCRIPTION column changed to hold varying length characters up to 2000 bytes.
The column can currently hold 1000 bytes per value. The table contains 20000 rows.
Which statement is valid? </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> ALTER TABLE commercials <br>
MODIFY (description CHAR2(2000));
</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> ALTER TABLE commercials <br>
CHANGE (description CHAR2(2000));
</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> ALTER TABLE commercials <br>
CHANGE (description VARCHAR2(2000));
</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> ALTER TABLE commercials <br>
MODIFY (description VARCHAR2(2000));
</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> You cannot increase the size of a column if the table has rows</b></p>
</td>
</tr>
</span>
</form>
</table>
</body>
</html>
<br>⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?