当前分类: 1Z0-132
问题:单选题You have forgotten the name of binary PL/SQL library saved to the operating system. This file contains the PL/SQL constricts you created for the inventory report. For which file extension should you reach?()A .SQL B .PLL C .PLDD .PRT...
查看答案
问题:单选题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 aver...
问题:单选题A sales analyst reviews the first draft on your Sales application, and requests that the application graphically represent revenue generated for each sales representative, in addition to the textual data currently displayed for the ORDER block. How wou...
问题:单选题What does the term application partitioning refer to?()A The feature of a forms application enabling it to run both in client-server mode and on the Web. B Storing PL/SQL program units between the Oracle server and the application to make optimal use o...
问题:单选题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 modul...
问题:单选题You need to create a data block for DML operations in the NEW_EMPLOYEE form module. Which data source can you use for this block?()A REF cursor query. B Stored function. C From clause query. D Transactional trigger....
问题:多选题Which three scenarios describe appropriate uses for key triggers?()AAlter data in a database table.BAdd custom item validation code.CDisable the Next Block key and menu item.DDisplay a custom form in place of a List of Values.EChange the navigational o...
问题:单选题For an inventory report, you created a work_in_progress that contains two columns, ID_number and quantity. The parent group of the work_in_progress is in_inventory which contains one column, dept_no. You added a filter of fist fifteen to total_inventor...
问题:单选题You have written a custom menu for a Forms application. You saved the menu module to the file custmenu.mmb. In the Property Palette for the form, you set the Menu Module property to custmenu. When you run the form, the custom menu does not appear. What...
问题:单选题You are creating the CUST_PREMIUM data block in the AUTO_INSURANCE form. A new state law requires that premiums be lowered for drivers with a good driving history. Because this could potentially affect a large number of records, you want to base the da...
问题:单选题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? ()A The report will not execute. B The report will only ac...
问题:单选题You create a tabular employee report and are concerned about readability because the employee records are very close together. What is the best way to increase the amount of white space between the records?()A In the layout model increase the size of t...
问题:单选题Which setting change would you allow to make a child object to be moved out of a parent object?()A Flex mode on. B Flex mode off. C Confined mode on. D Confined mode off....
问题:单选题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 wi...
问题:单选题The record group in the EMP form is populated using a SELECT statement that is constructed programmatically at runtime. Five employee records are displayed at one time, and a user chooses item two from the record group. Which built-in would you use 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?()A Report wizard. B Layout model. C Data model. D Life previewer....
问题:多选题What are three uses for record groups?()ATo pass data to a pop-up menu.BTo populate a base table block.CTo pass data to other form modules.DTo pass data to other Oracle products.ETo dynamically construct SELECT statements.FTo server as the source for a...
问题:多选题Which three objects can be components of a menu module?()AwindowsBparametersCobject groupsDreport objectsEvisual attributes...
问题:单选题In the data model you created this query: SELECT ID_no, description, price, quantity, manufacturer_ID FROM inventory Next you click and drag the manufacturer_ID column out of and above the default group. You needed to sort the child group by ID_number....