单选题The telesales force requested additional ways to terminate the automated polling questionnaire. In addition to the default functionality, you provide a menu item and a button for this purpose. Adhering to efficient coding practices, which PL/SQL code d

第1题：

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 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? （）

• A、Menu 
• B、Plus 
• C、Macro
• D、PL/SQL

第3题：

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、 .PLD
• D、 .PRT

第4题：

The telesales force requested additional ways to terminate the automated polling questionnaire. In addition to the default functionality, you provide a menu item and a button for this purpose. Adhering to efficient coding practices, which PL/SQL code do you use for the menu item and the button?（）

• A、EXIT 
• B、EXIT_FORM 
• C、DO_KEY('Key-Exit') 
• D、DO_KEY('EXIT_FORM')

第5题：

Your organization decided to upgrade the existing Oracle 10g database to Oracle 11g database in a multiprocessor environment. At the end of the upgrade，you observe that the DBA executes the following script：   SQL> @utlrp.sql   What is the significance of executing this script？（）  

• A、 It performs parallel recompilation of only the stored PL/SQL code.
• B、 It performs sequential recompilation of only the stored PL/SQL code.
• C、 It performs parallel recompilation of any stored PL/SQL as well as Java code.
• D、 It performs sequential recompilation of any stored PL/SQL as well as Java code.

第6题：

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.

第7题：

Where can you add your own PL/SQL code in relation-handling triggers?（）

• A、Before the "End default relation program section" comment. 
• B、After the "Begin default relation program section" comment. 
• C、Before the "Begin default relation program section" comment. 
• D、It is not possible to modify the relation-handling code that Forms automatically creates for relations.

第8题：

In your Certkiller .com database server the parameter PLSQL_CODE_TYPE has been set to NATIVE. Which object would be achieved by the setting？（）

• A、The source PL/SQL code will be stored in native machine code.
• B、The source PL/SQL code will be stored in interpreted byte code.
• C、The compiled PL/SQL code will be stored in native machine code.
• D、The compiled PL/SQL code will be stored in interpreted byte code.

第9题：

Your organization decided to upgrade the existing Oracle 10g database to Oracle 11g database in a multiprocessor environment. At the end of the upgrade, you observe that the DBA executes the following script: SQL> @utlrp.sql What is the significance of executing this script?（）

• A、It performs parallel recompilation of only the stored PL/SQL code.
• B、It performs sequential recompilation of only the stored PL/SQL code.
• C、It performs parallel recompilation of any stored PL/SQL as well as Java code.
• D、It performs sequential recompilation of any stored PL/SQL as well as Java code.

第10题：

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、Menu Item Roles. 
• C、Display without Privilege. 
• D、Use Security. 
• E、Command Type.