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:大于它的最小整数
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:大于它的最小整数