📄 exp_109.htm

📁 oracle　DBA的资料

💻 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 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 + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -