78.Evaluate the following query:
来源:互联网 发布:网络远程教育在哪报名 编辑:程序博客网 时间:2024/05/29 09:12
78.Evaluate the following query:
SQL> SELECT TRUNC(ROUND(156.00,-1),-1) FROM DUAL;
What would be the outcome?
A.16
B.100
C.160
D.200
E.150
答案:C
解析:round,trunc正数是小数点右边,负数是小数点左边,因此
round(156.00.-1) 结果是160,trunc(160.00,-1)还是160
SQL> SELECT TRUNC(ROUND(156.00,-1),-1) FROM DUAL;
What would be the outcome?
A.16
B.100
C.160
D.200
E.150
答案:C
解析:round,trunc正数是小数点右边,负数是小数点左边,因此
round(156.00.-1) 结果是160,trunc(160.00,-1)还是160
0 0
- 78.Evaluate the following query:
- 19.Evaluate the following query:
- 16.Evaluate the following query: SQL> SELECT promo_name||q'{'s start date was }'||promo_begin_date A
- 30.Evaluate the following CREATE TABLE commands:
- 31.Evaluate the following SQL commands:
- 43.Evaluate the following CREATE SEQUENCE statement:
- 55.Evaluate the following two queries:
- 55.Evaluate the following two queries:
- 146.Evaluate the following SQL statement:
- 155.Evaluate the following SQL statement
- 156.Evaluate the following SQL statement:
- 167.Evaluate the following DELETE statement:
- ocp 047-141 Evaluate the following SQL statement:SELECT product_name || 'it's not available for orde
- ocp 047-92 Evaluate the following expression using meta. character for regular expression:'[^Ale|ax
- 39.Evaluate the following command:CREATE TABLE employees(employee_id NUMBER(2) PRIMARY KEY
- 55.View the Exhibit to examine the output produced by the following query at three different times s
- identify internal components that are stealing the most pages from buffer pool using the following DMV query
- Following the pipeline
- android 百度地图画路线(驾车路线)
- 多编程-NSThread
- oracle默认的用户名和密码
- POJ 3415(后缀自动机)
- JAVA设计模式-代理模式
- 78.Evaluate the following query:
- iPhone入门学习——NetworkReachable学习笔记
- ssh (MVC软件开发模式)
- 策略模式
- Android:BaseListAdapter——摒弃ViewHolder使开发更高效的BaseAdapter
- CRITICAL_SECTION //critical_section
- View滑动动画的选择及其left, marginLeft, translationX参数的总结
- POJ 2479 Maximum sum(2次最大字段和)
- 如何让Window批处理文件可以支持带有空格的路径