OCP 1Z0 051 75

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 

RPAD 右边补齐
LPAD 左边补齐

SQL> SELECT prod_id,  2         prod_list_price,  3         rpad((round(prod_list_price)), 10, '*') AS rp,  4         lpad((round(prod_list_price)), 10, '*') AS lp  5    FROM sh.products  6   WHERE prod_id = 13;PROD_ID PROD_LIST_PRICE RP                   LP------- --------------- -------------------- --------------------     13          899.99 900*******           *******9001 row selected

Answer: A