Using the report builder how would you change this

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: properties. Answer: D QUESTION 127: The character mode sales report is stored on the network drive as a .REX. You need to make changes to the report layout. Using the report builder how would you change this file? A. Open the file using the menu option file->open make the changes and recompile the report. B. Convert the file into .REP file using the report compiler make the changes and convert the file back to a .REX file. C. Execute the R30CONV command to convert the file to a .RDF file, make the changes and convert the file back to a .REX file. D. Choose file -> administration->compile. Convert the file to a .REP file, make the changes and convert the file back to a .REX file. E. Execute the R30CONV command to convert the file to a .REP file, make the changes and convert the file back to a .REX file. Answer: D QUESTION 128: Which report style would you use to create a report listing each department and including a listing of employees beneath their respective department? Actualtests.com - The Power of Knowing 1Z0-132 A. Group left. B. Form like. C. Matrix W/group. D. Group above. E. Mailing label. F. Form letter. Answer: D QUESTION 129: Human resources department requested a report to display the total number of employees working in each department. To begin you created this query: SELECT dept_ID, count (employee_id) FROM employee C. GROUP BY dept_ID You defaulted the layout and choose a tabular report style. In the layout model which property sheet would you alter to restrict the number of records appearing on each page? A. Frame B. Report C. Field D. Repeating frame Answer: D QUESTION 130: When is an implicit anchor created? A. When an object is enclosed by another object. B. When a page break after pagination property is enabled. C. When a link is created between two objects. D. When a keep with anchoring object pagination property is enabled. Answer: A QUESTION 131: Which statement is true about mouse events? A. The cursor style can be set to CAUTION. B. Double-clicking a mouse button can potentially fire six mouse event triggers. C. The values for the SYSTEM.MOUSE_BUTTON_PRESSED system variable can only be 1 or 2. D. Click and double-click button actions can only detect if the mouse is positioned in an item. Actualtests.com - The Power of Knowing 1Z0-132 Answer: B QUESTION 132: You are creating the DEPT_SAL data block from the PAYHIST form. Users should be able to enter a valid department ID number, which will then display the employee salary information for that department. This data block could potentially retrieve a large number of records. Since users will probably only view a small number of these records, only 10 records should be fetched at one time. How would you create the data block? A. Select The Data Blocks node in the Object Navigator and click the Create button. Choose to build the data block manually, enter the procedure name in the Query Data Source Columns property, and the procedure code in the Query Data Source Arguments property. B. Choose Tools -> Data Block Wizard, select Table as the data source type, and base the block on the columns from the tables. C. Choose Tools -> Data Block Wizard, select, View as the data source type, and base the block on the columns from the tables. D. Select the Data Blocks node in the Object Navigator and click the Create button. Choose to build the data block manually, alter the Query Data Source Type property to 'FROM clause query', and enter the SELECT statement in the Query Data Source Name property. E. Select the Data Block node in the Object Navigator and click the Create button. Alter the Query Data Source Type, Query Data Source Name, Query Data Sources Columns, and Query Data Source Arguments properties to create a stored procedure that uses a red cursor. Answer: E QUESTION 133: The manager of the sales department requested all the sales data report execute daily 5 P.M. The result should be sent to her via e-mail. Which destination type would you use to send the output using your company's MAPI-compliant system? A. Screen B. Preview C. File D. Printer E. E-mail F. The destination type depends on how the manager prevents to preview the result. Answer: E QUESTION 134: You are creating a report wizard to create a matrix report. The query build, you select the patient_name column from the patient table; the doctor_name from the doctors table; and the Actualtests.com - The Power of Knowing 1Z0-132 doctor_ID, patient_ID and ID columns from the procedure table. In the report wizard you select patient_name as the row value, doctor_ID as the column values and the count as the cell values. You need to add a total for each doctors column. In the wizard report which tab will allow you to create the summary column? A. Rows B. Totals C. Columns D. Cells E. Data Answer: B QUESTION 135: How would you default the layout of a parameter form? A. Use the default layout tool in the parameter form editor. B. Select menu item tool->parameter form builder. C. Open the parameter form editor and select menu items tool->default layout. D. You cannot default...
View Full Document

This document was uploaded on 03/08/2014.

Ask a homework question - tutors are online