1Z0-132 Oracle9i, Build Internet Applications II Testking Exam

Demo Question 6.

You are creating a matrix report. Using query builder, you select the SALES_ID and DEPT_ID columns from the SALES table, The CUST_BALANCE column from the CUSTOMER table and the INVOICE_TOTAL column from the INVOICE table. Using the report wizard you select SALES_ID as the row values, DEPT_ID as the column values and SUM/CUST_BALANCE. as the cell values. You add a summary column for a SALES_ID row. If the summary column has a null value you need to display a zero. What is the easiest way to accomplish this task?

A. Alter the value if null property on the summary column property palette.
B. Alter the value if null property on the save_ID palette.
C. Alter the initial value property on the sales ID property palette.
D. Create a format trigger for a summery value field to display a zero if the field is null.
E. Create a boiler plate text object in the layout model containing a zero and place it between the row repeating frame and the matrix object.


Display Answer

Answer: A

Explanation: