This preview shows page 1. Sign up to view the full content.
Unformatted text preview: isses the New Record Group dialog
D. When the user enters data in the HOTEL item, and the Validate from List property for the HOTEL
item is set to YES.
Explanation: When record group is used in a LOV for a text item, The record group is populated when the
user enters data in the text item and the Validate From List property of the text item is set to YES.
Examine this code:
IF :SYSTEM.EVENT_WINDOW = 'WELCOME' THEN
ELSE MESSAGE('Illegal operation');
In which form level trigger would you implement this?
Explanation: The code IF :SYSTEM.EVENT_WINDOW = 'WELCOME' will check for active window
name. DO_KEY('exit_form') will exit the form, This code can be called to check the name of the window
which is about to close. It should be placed in When-Window-Closed form trigger. Actualtests.com - The Power of Knowing 1Z0-132
You want to create a template to be used as a standard for all company reports, which are many
different styles. How many different templates must you have if you plan to use multiple report styles?
C. One per report style.
D. One per report style + one more
You create a salary report to display employee salaries grouped by the dept column. You need to
change the break order from ascending to descending using the model. How would you reverse the
display order of the department?
A. Double click the dept column in the group to alter the property palette and change the break out order
B. Double click the dept column in the group to open the property palette and change the set break order
C. Double click the g_dept group object to change the break order.
D. Click the dept column in the group to change the break order.
Using the report wizard you create a tabular report to display all the columns in the EMP table. The
records are ordered by the dept_name and job columns. You need to create a hierarchical report that
breaks on the dept_name and job values. Using the data model how would you create this break
A. Specify the break order on the g_emp group Property palette.
B. Specify a break order on the dept_name and job columns property palettes.
C. Click and drag the dept_name and jobs column out and above of the g_emp group to create a new
D. Change the position of the dept_name and the job columns within the g_emp group.
A few months ago, you created a sales transaction report using this query:
SELECT sales_ID, transaction number, amount
Actualtests.com - The Power of Knowing 1Z0-132
D. FROM sales
WHERE sales_date=trunk(sys date)
Today you need to modify the report to include each transactions % of totally daily transactions. How
can you accomplish this task?
A. In the date model add a summary column to the group to give up % of a total of the amount column.
B. In the data model add a place holder column to the group to give a % of total of the amount column.
C. In the data model add a summary column outside the group to give a % of total of the amount
D. In the data model add a place holder column outside the group to give a % of total of the amount
E. In the layout model add a final in the field in the repeating group to calculate a % of the total of the
How are messages displayed when you use the SRW.MESSAGE packaged procedure?
A. Dialogue box that implicitly determines report execution.
B. Message line that implicitly determines report execution.
C. Message line that suppresses the default oracle message.
D. Dialogue box that does not terminate report execution.
E. Dialogue box that suppresses the default oracle message.
You created a tabular report for human resources department. After viewing layout users have
requested that you change the label of the dept column to something more meaningful. How would
you change the label in the live previewer?
A. Use the report wizard to change the column label.
B. Click and high light the column label and replace it with desired text.
C. Click the column label and alter its property palette.
D. Click the dept column and alter its property palette.
You created a department report and preview it in life preview. The font for the department name is
too small and you want to enlarge it but do not want to change the font for any other fields. What is
the easiest way to make this change?
Actualtests.com - The Power of Knowing 1Z0-132 A. Select the text to be enlarged in the life previewer and make the size change using the style bar.
B. Select the text to be enlarged in the layout mode and make the change.
C. Open the report wizard in the re-entrant mode and make the change.
D. Make the copy of the report, open the copy, make the changes and then delete the original report.
View Full Document
This document was uploaded on 03/08/2014.
- Fall '09