Unformatted text preview: ur company has implemented the report's server three-tier architecture. From 4 to 5 P.M each day
several departments begin running their daily reports. Which tier of this architecture will spawn
extra run time engines to process the increased activity?
C. Database server.
D. These extra run time engines are not automatically created they must be initiated by the users
executing the report.
You created a tabular report for the sales department to display each customer and the sales person
assign to the customer. The data is sorted by customer using the order by clause in this query. This is
department manager asks you to alter the report so that data is sorted by sales person rather than by
customer. What is the best way to make the needed change?
A. Recreate the query and default the layout.
B. Alter the query, default the layout and redo the boiler plates.
C. Query and manually change the layout to save the boiler plate.
D. Alter the query and make no further change.
The CALC function is used several times within the sales report. To simplify maintenance you want to
store the function in one place and call it from within your PL/SQL trigger code. Which node would
you use in object navigator to create a report level programme unit to store the function?
A. Programme units.
B. PL/SQL libraries.
C. Database object.
D. Built in packages.
Actualtests.com - The Power of Knowing 1Z0-132 Answer: A
You are developing an inventory report to list the item number, description price and picture of all
inventory items. The layout of each item is a repeating frame that contains three fixed fields and a
image. When possible you want all objects in the repeating frame to appear on the same logical page
without creating blank pages between instances. Which pagination property would you alter to
achieve these results?
A. Page break before.
B. Page break after.
C. Page protect.
D. Keep with anchoring object.
You are creating a report containing two headers and three tailor pages. You set the logical page size
to 2 into 1. The body if the report is four logical pages. How many physical pages is the entire report?
The IT department requested a report to list each server name and the name of each department that
utilizes resources from each server. You create a tabular layout that breaks on the server name. You
ran the report and noticed that the department field is too large for most of the department names.
Which field size setting would you use to allow the field to be smaller but not larger than the field
Answer: C Actualtests.com - The Power of Knowing 1Z0-132
The IT department is creating a human resources application that will require several new tables.
You need to develop a standard alone executable that will defines these tables and their relationships.
Which developer/2000 component could you use to create the executable?
A. Procedure builder.
B. Query builder.
C. Schema builder.
D. Form builder.
E. Project builder.
F. Transactional builder.
You want to create a template to be used as a standard for all company reports. What is the easiest
way to do this?
A. Open an existing template file, rename it and modify the template objects.
B. Open the report wizard and create a new template.
C. Open the layout model and copy the paste items from the default templates provided in report
D. Templates cannot be modified in release 2.
In the data model you created two queries that produced two groups named employee and sales. The
sales group is a child in the employee group. You establish a relationship between the two queries by
creating a link. Which modifications would you make to the data link property sheet for this
A. No modifications are needed because the default values represent the relationship.
B. Modify the SQL clause to having and conditioned to like.
C. Modify the SQL clause to where and condition to like.
D. Modify the SQL clause to having and condition to =.
The sales report needs to display the sales person with the highest order total. Which build report
builder component would you use to create a place holder column to display the value?
Actualtests.com - The Power of Knowing 1Z0-132 A. Report wizard.
B. Layout model.
C. Data model.
D. Life previewer.
The accounts receivable department requested an accounts status to allow users to enter either a
customer name, customer number, customer phone number and then display the customer out
standing balance. You want to restrict the data retrieved based on values entered by the users. Which
where clause would you write in the query to select statement to accomplish this task?
C. WHERE CUST_ID=P_CUST_ID or cust_name=:p_cust_name or cust_phone=:p_cust_phone
D. Where cust_ID=&p_custid cust_name=&p_cust_name or cust_phone=&p_cust_phone
The order entry department requested a report to display the average time to enter an order fro...
View Full Document