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

<span style="font-size:18pt">
	<p>
	This statement will create view that can be used to change tables in underlying table through simple views. It includes primary key, NOT NULL column and foreign key to avoid constraint restrictions. <br>
	</p>

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

	<p>
	  A: This statement does not include JOB_ID column that cannot be NULL. In general, all constraint restrictions defined on the underlying table also apply to modifying data via the view. For example, you can't add data to an underlying table via a view that violates the table's primary key constraint. <br>
	</p>

	<p>
	  C: You cannot update a column of an underlying table if the simple view use a single-row function to define the column. <br>
	</p>

	<p>
	  D: You may not insert, update, or delete records data on the table underlying the simple view if the SELECT statement creating the view contains a GROUP BY clause, GROUP function, or DISTINCT clause. <br>
	</p>

	<p>
	  OCP Introduction to Oracle 9i: SQL Exam Guide, Jason Couchman, p. 298-299 <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 + -