当前分类: 1Z0-132
问题:单选题You are creating the SAL_INFO data block on the EMP_QUERY form. The SALARY field should only be populated if the logged-on user is a manager. Since this query could potentially return a large amount of records, you have created a stored procedure which...
查看答案
问题:单选题What is the data type returned by the CREATE_TIMER built-in?()A longB timerC numberD varchar2...
问题:单选题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....
问题:单选题The transportation department requested a shipping cost report to list the resources used by each department. A separate page should be product for each department. Which property would you modify to achieve these results?()A Minimum widow records. B C...
问题:单选题The accounting manager wants you to create a form that when queried will display a calculated total of year-to-date actual expenditures for the found code entered. The values needed to generate this summary data are stored in multiple tables. Which dat...
问题:单选题You established access to menu modules using roles. You have allowed the sales role to access the menu module, but prevented access to the Update menu item. Which item property would you alter to gray out the menu option for the role?()A Item Roles. B ...
问题:单选题Which technique retrieves the error number when explicit DML fails?()A SQLCODE in an On-Error trigger. B SQLCODE in an exception handler. C DBMS_ERROR_CODE in an On-Error trigger. D DBMS_ERROR_CODE in an exception handler....
问题:单选题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...
问题:单选题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...
问题:单选题Which datatype is returned by the FIND_MENU_ITEM built-in function?()A number B Boolean C menuitem D VARCHAR2...
问题:单选题Form_A invokes Form_B in Post-Only mode. Which statement must be true?()A Form_A has updates or deletes that have not been posted or committed, and Form_A invokes Form_B with the OPEN_FORM built-in. B Form_A has updates or deletes that have not been po...
问题:单选题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...
问题:多选题Which three values are valid parameters for the DO_KEY built-in?()AENTERBGO_ITEMCVALIDATEDEXIT_FORMEEXECUTE_QUERY...
问题:多选题Which two triggers are mouse movement triggers?()AWhen-Mouse-UpBWhen-Mouse-MoveCWhen-Mouse-DownDWhen-Mouse-ClickEWhen-Mouse-Leave...
问题:单选题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...
问题:单选题he data blocks in your form module are based on object tables. How would you create a master-detail relationship between two of these blocks?()A Use the Data Block Wizard and base the relation on a REF pointer. B In the Object Navigator, select the Rel...
问题:单选题You are developing the Payroll application that contains the SALARY and COMMISSION forms. When a user invoked the COMMISSION form from the SALARY form, the SAL value should be passed to the COMMISSION form. In which data form and at what time should yo...
问题:多选题Your application requires that you programmatically manipulate a nonquery record group. Which three built-ins can you use?()ACREATE_GROUPBADD_GROUP_NOWCPOPULATE_GROUPDADD_GROUP_COLUMNECREATE_GROUP_FROM_QUERY...
问题:单选题You are creating a new form for the Order Entry application. You define a record group that will be created when the form is executing this built in: CREATE_GROUP(rg_emplist, global_scope) Which form(s) in the application will have access to this recor...
问题:多选题Which two are examples of a mouse event?()AThe user clicks the mouse.BThe user moves the mouse into an item.CThe cursor style changes from default to busy.DThe user moves the mouse into the window title bar....