单项选择题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.


您可能感兴趣的试卷

你可能感兴趣的试题

2.单项选择题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?()

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. 

3.单项选择题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. 

4.单项选择题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.

5.单项选择题Using the report wizard you create a tabular report to display all the columns in the EMP table. The records are ordered by the deptname and job columns. You need to create a hierarchical report that breaks on the deptname and job values. Using the data model how would you create this break structure?()

A.Specify the break order on the gemp 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 gemp group to create a new parent group. 
D.Change the position of the dept_name and the job columns within the gemp group.

6.单项选择题 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.

8.单项选择题At design time, you create a query record group for the LOV associated with the HOTEL text item in a form module for the Travel Planner Application. When is the record group populated?()

A.When the user navigates to the HOTEL item. 
B.When the form module successfully compiles. 
C.After Form Builder validates the SELECT statement and dismisses 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. 

9.单项选择题The users request that [F2], [F3], and [F4] be used to commit, rollback, and exit,respectively. How do you accomplish this?()

A.Add the appropriate PL/SQL code for each key. 
B.Map the logical keys to the physical keys, then add the appropriate PL/SQL code for each key.
C.Create an object library to define the key triggers, then reference the object library in the form. 
D.This cannot be accomplished because other function keys provide this functionality by default.

10.单项选择题You want to provide a tool that allows users quick access to form modules, by listing them in an Explorer-style interface. Which reusable component do you use?()

A.ActiveX controls 
B.Calendar Class 
C.Standard Object Library 
D.Picklist Class 
E.Wizard Class 
F.Navigator Class

最新试题

 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 are developing a tax report for the payroll application. You created a before parameter form report trigger to create three temporary tables to store text that are need while the report is executed. Which report trigger would you use to delete these temporary tables?()

题型:单项选择题

You are developing a bonus report for the payroll application to calculate and display the bonus issue to each envelope. Employees with a salary of less than 50000$ earn a bonus of 15% and the employees who earn 50000$ or more earn out 10% bonus. Which type of trigger would you use to conditionally assign a bonus percentage?()

题型:单项选择题

You creating a report that will run in both character mode and bitmapped environments. You include some printer codes in your report. What will happen when you run the report in bitmapped mode? ()

题型:单项选择题

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?()

题型:单项选择题

Which report style would you use to create a report listing each department and including a listing of employees beneath their respective department?()

题型:单项选择题

You create the sales report and run it in the live previewer. After which change would the live previewer require the data? ()

题型:单项选择题

Which tool in the layout model could you use to create an external boiler plate object?()

题型:单项选择题

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?()

题型:单项选择题

Which setting change would you allow to make a child object to be moved out of a parent object?()

题型:单项选择题