75.The following data exists in the PRODUCTS table:

最新推荐文章于 2018-06-15 00:12:20 发布
最新推荐文章于 2018-06-15 00:12:20 发布
阅读量1.2k 收藏
点赞数
分类专栏： 1z0-051
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/dwj19830118/article/details/50781220
版权
75.The following data exists in the PRODUCTS table:
PROD_ID   PROD_LIST_PRICE
123456    152525.99
You issue the following query:
SQL> SELECT RPAD((ROUND(prod_list_price)), 10,'*') FROM products WHERE prod_id = 123456;

What would be the outcome?
A.152526****
B.**152525.99
C.152525****
D.an error message
答案：A
解析：
rpad是右补齐，排除B。round是四舍五入，没有指定位数的话，默认为0，去掉小数点，排除C，选A
round:四舍五入
floor:小于它的最大整数
trunc:保留指定位数
ceil:大于它的最小整数
今年我18
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
openGL 入门4 --- Following the data
AI小作坊 的博客
05-30 233
Example 1.2. Buffer Object Initialization void InitializeVertexBuffer() { glGenBuffers(1, &positionBufferObject); // 生成缓存对象，没有分配内存 glBindBuffer(GL_ARRAY_BUFFER, positionBufferObject); // 绑定对象 g...
053试题 69 - flashback query （select as of）
文档搬运工
08-14 301
题目： 69.The EMP table exists in your schema. You want to execute the following query: SELECT ename, sal FROM emp AS OF TIMESTAMP (SYSTIMESTAMP - INTERVAL '6' MINUTE) WHERE ename = 'ALLEN'; What are th...
OCP-1Z0-051 第75题 round和rpad函数
Oracle
05-08 4048
一、原题 The following data exists in the PRODUCTS table: PROD_ID   PROD_LIST_PRICE 123456     152525.99 You issue the following query: SQL> SELECT RPAD((ROUND(prod_list_price)), 10,'*') FROM produc
OCP-1Z0-053-V12.02-69题
836811384
11-04 144
69.The EMP table exists in your schema. You want to execute the following query: SELECT ename, sal FROM emp AS OF TIMESTAMP (SYSTIMESTAMP - INTERVAL '6' MINUTE) WHERE ename = 'ALLEN'; What are th...
1Z0-051 37. You issued the following command to drop the PRODUCTS table:
sun的专栏
07-05 683
SQL> DROPTABLE products; What is theimplication of this command? (Choose all that apply.) A. All dataalong with the table structure is deleted. B. The pendingtransaction in the session is committed
JSP 开发之THE SERVLET NAME ALREADY EXISTS.解决方法
10-19
主要介绍了JSP 开发之THE SERVLET NAME ALREADY EXISTS.解决方法的相关资料,希望通过本文大家能解决这样的问题，需要的朋友可以参考下
tree-log.rar_The Just_log
09-20
"tree-log.rar_The_Just_log"这个压缩包文件涉及到的是一种特定的日志实现，名为"The Just Log"，它关注的是如何在日志回放过程中高效地重建inode。 首先，让我们来理解一下"LOG_INODE_EXISTS"这个术语。在文件系统...
FileExistsError: [Errno 17] File exists: ‘/data1/XXX/val_processed/ct/’
12-22
在上述问题中，用户遇到了`FileExistsError: [Errno 17] File exists`的错误，这通常是由于尝试创建一个已经存在的目录时引发的。Python的`os`模块中的`mkdir()`函数用于创建目录，但当目标目录已经存在时，它会抛出...
模型迁移错误常见问题”django.db.utils.InternalError: (1050, “Table ‘django_content_type’ already exists”)”
01-21
django迁移模型常见错误django.db.utils.InternalError: (1050, “Table ‘django_content_type’ already exists”)” 这个问题经常出现在迁移模型时报错，表示该表已经存在，说明之前进行过模型的迁移操作。 例如...
106.Examine the data in the LIST_PRICE and MIN_PRICE columns of the PRODUCTS table:
dwj19830118的专栏
03-07 1186
106.Examine the data in the LIST_PRICE and MIN_PRICE columns of the PRODUCTS table:
OCP-1Z0-051 补充题库 第42题 DROP TABLE命令的影响
Oracle
04-03 2281
一、原题 You issue the following command to drop the PRODUCTS table: SQL>DROP TABLE products; What is the implication of this command? (Choose all that apply.) A. All data in the table are deleted b
Oracle 11G OCP 1Z0-053 69
cmff98425的博客
08-15 123
（69）The EMP table exists in your schema.You want to execute the following query: SELECT ename,sal FROM emp AS ...
1z0-071 Oracle Database 12c SQL 第11题 DROP语句
点滴的幸福
06-15 1464
Q11. You issue the following command to drop the PRODUCTS table:SQL > DROP TABLE products;Which three statements are true about the implication of this command?A. All data in the table is deleted b...
OCP-1Z0-051-V9.02-36题
一抹曦阳-Oracle
10-23 9409
36. Examine the following SQL commands:  SQL>CREATE TABLE products ( prod_id NUMBER(3) CONSTRAINT p_ck CHECK (prod_id > 0), prod_name CHAR(30), prod_qty NUMBER(6), CONSTRAINT p_name NOT NULL,  C
OCP 1Z0 051 75
有教无类的专栏
05-21 697
75. The following data exists in the PRODUCTS table:  PROD_ID     PROD_LIST_PRICE  123456        152525.99  You issue the following query:  SQL> SELECT RPAD(( ROUND(prod_list_price)), 10,'*')    
OCP 1Z0 053 69
有教无类的专栏
07-04 1124
69.The EMP table exists in your schema. You want to execute the following query:  SELECT ename, sal  FROM emp  AS OF TIMESTAMP (SYSTIMESTAMP - INTERVAL '6' MINUTE)  WHERE ename = 'ALLEN';  What a
3.You need to extract details of those products in the SALES table where the PROD_ID column contains
dwj19830118的专栏
01-17 1622
3.You need to extract details of those products in the SALES table where the PROD_ID column contains the string '_D123'.
OCP-1Z0-051 第37题 drop table
Oracle
05-05 5190
一、原题 You issued the following command to drop the PRODUCTS table: SQL> DROP TABLE products; What is the implication of this command? (Choose all that apply.) A. All data along with the table struc
ocp 1Z0-051 71-105题解析
Database、Code
12-03 5872
71. Which arithmeticoperations can be performed on a column by using a SQL function that is builtinto Oracle database ?(Choose three .) A. a ddition B. s ubtraction C. r aising to a power D. f in
hint: Updates were rejected because the tag already exists in the remote.
最新发布
09-27
当提示"Updates were rejected because the tag already exists in the remote"时，这意味着你尝试在远程仓库中创建一个已经存在的标签。远程仓库已经存在一个与你尝试创建的标签名称相同的标签。要解决这个问题，你...

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值