当前分类: 1Z0-132
问题:单选题You established access to menu modules using roles. While testing the application, you need access to all the menus in the SALES form module for all the roles. Which method will override the Menu Module Roles property to allow you to access all the men...
查看答案
问题:单选题Which datatype is returned by the FIND_MENU_ITEM built-in function?()A number B Boolean C menuitem D VARCHAR2...
问题:多选题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...
问题:单选题You create a data block based on a relational table containing a REF column. You select the REF column for your form module. What is true about the items based on the REF column attributes?()A The Query Only property is set to Yes. B The Conceal Data p...
问题:单选题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....
问题:单选题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...
问题:单选题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....
问题:单选题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 fund code entered. The value needed to generate this summary data are stored in multiple tables. How would y...
问题:单选题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...
问题:多选题Which two triggers are mouse movement triggers?()AWhen-Mouse-UpBWhen-Mouse-MoveCWhen-Mouse-DownDWhen-Mouse-ClickEWhen-Mouse-Leave...
问题:单选题You created a custom menu for the Order Entry application. The shipping administrator has requested an additional submenu containing four items to invoke various reports. Which command type must you use to identify the parent menu item as a submenu? ()...
问题:多选题Which three values are valid parameters for the DO_KEY built-in?()AENTERBGO_ITEMCVALIDATEDEXIT_FORMEEXECUTE_QUERY...
问题:多选题Which two chart base types can you select using the Chart Wizard?()ALineBColumnCBubbleDFlowchartEOHLC candle stock...
问题:单选题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...
问题:多选题You need to create a trigger to locate the Product report in the Rpt_Server, run the report, and test the status of the report. Which three built-ins would you use to accomplish this task?()ARUN_PRODUCTBSET_REPORT_OBJECT_PROPERTYCRUN_REPORT_OBJECTDFIND...
问题:多选题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...
问题:单选题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 cr...
问题:单选题You want to create a temporary table while executing a procedure in a form. Which statement is true?()A You cannot create a table form within Forms. B You must use the FORMS_DDL built-in to create the table. C You must use the DBMS_DYNAMIC_DDL package ...
问题:多选题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....