Oracle-Build Internet Applications II Set 4

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?

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 layout size?

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?

You want to create a template to be used as a standard for all company reports. What is the easiest way to do this?

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 relationship?

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?

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?

The order entry department requested a report to display the average time to enter an order from each order entry clerk sorted by supervisor with a group average after viewing the report users requested to bold the value for each supervisors group average. Where would you make this change?

You created a report from the human resources department based on all the columns in the EMP table. After viewing the report users requested that the cmp_ID columns peers first in the output. How would you change the position of the column?