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

<span style="font-size:18pt">
	<p>
	A view can be created as read only object. However, it is possible to change data in the underlying table(s) with some restrictions.<br>
	</p>

	<p>
	  A view also can be created as a join on two or more tables. This type of view is called complex view. Complex views provide complicated data models where many base tables are drawn together into one virtual table. <br>
	</p>

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

	<p>
	  C: Query operations containing ORDER BY clause are also permitted, so long as the <br>
	</p>

	<p>
	  ORDER BY clause appearsoutside the parentheses. The following is an example of what mean: CREATE VIEW my_view AS (SELECT*FROM emp) ORDER BYempno. <br>
	</p>

	<p>
	  D: A view can be created with a GROUP BY clause in the SELECT statement. <br>
	</p>

	<p>
	  E: It is not required to have aliases defined for the column names in the SELECT statement. <br>
	</p>

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