📄 exp_018.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><b><span style="font-size:22pt">Explaination 018: </span></b></p>
<span style="font-size:18pt">
<p>
The structure of the DEPT table will be displayed because the CREATE TABLE statement is DDL operation and it cannot be rolled back because implicit commit occurs on the database when a user exits SQL*Plus or issues a data-definition language (DDL) command such as a create table statement, user to create a database object, or an alter table statement, used to alter a database object. <br>
</p>
<p>
Incorrect Answers <br>
</p>
<p>
B: The ROLLBACK statement has nothing to do with the storage space of the DEPT table. <br>
</p>
<p>
C: The DESCRIBE DEPT statement does not produce the error. It displays the tructure of the DEPT table. <br>
</p>
<p>
D: The COMMIT statement does not need to be introduced because implicit commit occurs on the database after creation of the table. <br>
</p>
<p>
OCP Introduction to Oracle 9i: SQL Exam Guide, Jason Couchman, p. 281-283 <br>
</p>
<p>
Chapter 6: Manipulating Oracle Data
</p>
</span>
</body>
</html>
<br>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -