📄 exp_028.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 028: &nbsp;</span></b></p>

<span style="font-size:18pt">
	<p>
	When we want to alter the underlying data used in the definition of a view, we use the CREATE OR REPLACE VIEW statement. When a CREATE OR REPLACE VIEW statement is issued, Oracle will disregard the error that arises when it encounters the view that already exists with that name, and it will overwrite the definition for the old view with the definition for the new one. <br>
	</p>

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

	<p>
	  A: There is no ALTER VIEW command in Oracle. <br>
	</p>

	<p>
	  B: There is no MODIFY VIEW command in Oracle. <br>
	</p>

	<p>
	  C: There is no ALTER VIEW command in Oracle. <br>
	</p>

	<p>
	  D: There is no MODIFY VIEW command in Oracle. <br>
	</p>

	<p>
	  F: You don't need to remove the existing view to create modified view. You are able to do that with CREATE OR REPLACE command. <br>
	</p>

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

	<p>
	  Chapter 7: Creating Other Database Objects in Oracle
	</p>

</span>

</body>
</html>
<br>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -