Home » Oracle » 1z0-051 » What would be the outcome?
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
Correct Answer: A
Explanation/Reference:
Explanation:
The LPAD(string, length after padding, padding string) and RPAD(string, length after padding, padding string) functions add a padding string of characters to the left or right of a string until it reaches the specified length after padding.
Download Printable PDF. VALID exam to help you PASS.
|
|