exp_109.htm

来自「oracle DBA的资料」· HTM 代码 · 共 42 行

HTM
42
字号
<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 109: &nbsp;</span></b></p>

<span style="font-size:18pt">
	<p>
	You cannot roll back DROP TABLE statement. All pending transactions related on this table are committed. If the table is dropped, Oracle automatically drops any index, trigger and constraint associated with the table as well. All data in the table is deleted, and the table structure is also deleted. <br>
	</p>

	<p>
	  Incorrect Answers <br>
	</p>

	<p>
	  C: All views based on the DEPT table become invalid, but they are not deleted. <br>
	</p>

	<p>
	  F: All data in the table is deleted, and the table structure is also deleted. Command TRUNCATE deletes all data in the table, but does not delete the structure of the table. <br>
	</p>

	<p>
	  G: All synonyms based on the DEPT table are not deleted after dropping the table. <br>
	</p>

	<p>
	  OCP Introduction to Oracle 9i: SQL Exam Guide, Jason Couchman, p. 225 <br>
	</p>

	<p>
	  Chapter 5: Creating Oracle Database Objects
	</p>

</span>

</body>
</html>

⌨️ 快捷键说明

复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?