exp_115.htm

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

<p><b><span style="font-size:22pt">Explaination 115: &nbsp;</span></b></p>

<span style="font-size:18pt">
	<p>
	Explanation : <br>
	</p>

	<p>
	  ROUND (45.953,-1) will round value to 1 decimal places to the left. <br>
	</p>

	<p>
	  TRUNC (45.936,2) will truncate value to 2 decimal <br>
	</p>

	<p>
	  The answer will be 50 and 45.93 <br>
	</p>

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

	<p>
	   <br>
	</p>

	<p>
	  A. Does not meet round and truncate functions <br>
	</p>

	<p>
	  B. Does not meet round functions <br>
	</p>

	<p>
	  D. Does not meet truncate functions <br>
	</p>

	<p>
	  E. Does not meet round functions <br>
	</p>

	<p>
	  F. Does not meet round functions <br>
	</p>

	<p>
	  Refer : Introduction to Oracle9i : SQL, Oracle University Student Guide, Single-Row functions, p. 3-13
	</p>

</span>

</body>
</html>