nerdexam
Oracle

1Z0-450 · Question #17

In your Orders application, you created a 30 Pie Flash chart page to display products by category. You provided the following query: Select null link, category_name# count (*) from (SELECT CASE WHEN…

The correct answer is C. Edit the Flash Chart region to specify the chart title and select the Show Values check box. See the full explanation below for the reasoning.

Question

In your Orders application, you created a 30 Pie Flash chart page to display products by category. You provided the following query:

Select null link, category_name# count (*) from (SELECT CASE WHEN (category_id between 10 and 19) THEN 'Television1 WHEN (category_id between 20 and 29) THEN 'Computer1 ELSE 'Others1 END category_name VMM new_product. Group by category_name order by 1 View the Exhibit. What action should you perform to display the chart title and the total number of products under each category without using custom XML?

Exhibit

1Z0-450 question #17 exhibit

Options

  • AEdit the Flash Chart region to select the Show Values check box.
  • BModify the query to display the value and edit the Flash Chart region to display the chart title
  • CEdit the Flash Chart region to specify the chart title and select the Show Values check box.
  • DEdit the Flash Chart region to specify the chart title.

How the community answered

(43 responses)
  • A
    14% (6)
  • B
    7% (3)
  • C
    77% (33)
  • D
    2% (1)

Community Discussion

No community discussion yet for this question.

Full 1Z0-450 Practice