1Z0-061 · Question #11
View the Exhibit and examine the structure of the customers table. Using the customers table, you need to generate a report that shows an increase in the credit limit by 15% for all customers…
The correct answer is D. Option D. Converts a null value to an actual value: Data types that can be used are date, character, and number. Data types must match: NVL(commission_pct, 0) NVL(hire_date, '01-JAN-97') NVL(job_id, 'No Job Yet')
Question
View the Exhibit and examine the structure of the customers table. Using the customers table, you need to generate a report that shows an increase in the credit limit by 15% for all customers. Customers whose credit limit has not been entered should have the message "Not Available" displayed. Which SQL statement would produce the required result?
Exhibits
Options
- AOption A
- BOption B
- COption C
- DOption D
How the community answered
(14 responses)- A7% (1)
- B14% (2)
- C7% (1)
- D71% (10)
Explanation
Converts a null value to an actual value: Data types that can be used are date, character, and number. Data types must match: NVL(commission_pct, 0) NVL(hire_date, '01-JAN-97') NVL(job_id, 'No Job Yet')
Topics
Community Discussion
No community discussion yet for this question.