READ Free Dumps For Oracle- 1z0-061

Question ID 21016	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?
Option A	Option A
Option B	Option B
Option C	Option C
Option D	Option D
Correct Answer	D

Explanation Explanation: NVL Function 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 ID 21017	View the Exhibit and examine the structure of the promotions table. Evaluate the following SQL statement: Which statement is true regarding the outcome of the above query?
Option A	It shows COST_REMARK for all the promos in the table.
Option B	It produces an error because the SUBQUERY gives an error.
Option C	It shows COST_REMARK for all the promos in the promo category 'TV'
Option D	It produces an error because SUBQUERIES cannot be used with the case expression.
Correct Answer	A

Explanation

Previous-Page 1 2. . . 40 41 42 43 44 45 46. . . 58 59 Next-Page

Send email to admin@getfreedumps for new dumps request!!!