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 y

第1题：

You create a master-detail form. The users need to be able to exit the form quickly, adhering to default transaction processing, regardless of the cursor location. You believe you can achieve this using a Key-Exit trigger. What do you need to do to implement this request? （）

• A、Define a Key-Exit trigger for all the blocks in the form.  
• B、In the Object Navigator, highlight all the items and define a Key-Exit trigger. 
• C、Define a Key-Exit trigger on the primary key item in the master block.
• D、No additional key-trigger definition is necessary.

第2题：

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.

第3题：

第4题：

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.

第5题：

The system analysts have requested heavy use of object features. The database design makes use of PL/SQL8 object types, methods, and LOB types. How do you work with these features on the client?（）

• A、Write client-side subprograms containing the PL/SQL8 constructs, and move them into an object group. 
• B、Write server-side subprograms, and call the subprograms from the form application. 
• C、Store the PL/SQL8 constructs in a PL/SQL library, and attack the library to each form muddle in your application.

第6题：

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.

第7题：

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.

第8题：

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

第9题：

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

第10题：

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.