Answer d explanation when record group is used in a

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: isses the New Record Group dialog box. D. When the user enters data in the HOTEL item, and the Validate from List property for the HOTEL item is set to YES. Answer: D 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. QUESTION 98: Examine this code: BEGIN IF :SYSTEM.EVENT_WINDOW = 'WELCOME' THEN DO_KEY('exit_form'); ELSE MESSAGE('Illegal operation'); END IF; END; In which form level trigger would you implement this? A. When-Window-Closed B. When-Window-Changed C. When-Window-Resized D. When-Window-Activated Answer: A 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 QUESTION 99: 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? A. Two B. One C. One per report style. D. One per report style + one more Answer: B QUESTION 100: 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 value. B. Double click the dept column in the group to open the property palette and change the set break order value. 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. Answer: A QUESTION 101: 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 structure? 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 parent group. D. Change the position of the dept_name and the job columns within the g_emp group. Answer: C QUESTION 102: 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 column. D. In the data model add a place holder column outside the group to give a % of total of the amount column. E. In the layout model add a final in the field in the repeating group to calculate a % of the total of the amount column. Answer: A QUESTION 103: 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. Answer: D QUESTION 104: 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. Answer: B QUESTION 105: 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. Answer: A QUESTION 106: Yo...
View Full Document

This document was uploaded on 03/08/2014.

Ask a homework question - tutors are online