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 

第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题：

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.

第3题：

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.

第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题：

You upgrade your Oracle database in a multiprocessor environment. As a recommended you execute thefollowing script:SQL > @utlrp.sqlWhich two actions does the script perform?（）

• A、Parallel compilation of only the stored PL/SQL code
• B、Sequential recompilation of only the stored PL/SQL code
• C、Parallel recompilation of any stored PL/SQL code
• D、Sequential recompilation of any stored PL/SQL code
• E、Parallel recompilation of Java code
• F、Sequential recompilation of Java code

第6题：

You design a Business Intelligence （BI） solution by using SQL Server 2008. You plan to design the report strategy for a new report project that will be used by a financial application. The application uses five calculations that are implemented in Microsoft .NET Framework 3.5 assemblies. The assemblies are written in the C# language and use the static methods. You need to ensure that the calculations can be used by the expressions in all reports. You also need to ensure consistency within the reports by using the least amount of development effort. What should you do？（）

• A、 Add a reference to the assemblies in the Report Properties References tab. 
• B、 Write the calculation logic used by the calculations by using T-SQL functions. 
• C、 Write the code of the calculation logic into the Report Properties Custom Code tab.
• D、 Write the calculation logic in each report by using the mathematical functions available natively to SQL Server 2008 Reporting Services （SSRS）.

第7题：

You are designing a group management strategy for users in the finance department. You need to  identify the appropriate changes that need to be made to the current group management strategy. You want to accomplish this goal by using the minimum number of groups.  What should you do？（）

• A、 Add the finance users to the financeData group to which the necessary permissions have been assigned.
• B、 Add the finance users to the financeGG group to which the necessary permissions have been assigned.
• C、 Add the finance users to the financeGG group. Then add the financeGG group to the financeData group to which the necessary permissions have been assigned.
• D、 Add the finance users to the financeGG group. Add the financeGG group to the financeUG group to the financeDat group to which the necessary permissions have been assigned.

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

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.

第14题：

You write a procedure that will be called from two level triggers and a database trigger. Where should you store this code? （）

• A、On the Oracle server. 
• B、Locally in each form module. 
• C、In an attached PL/SQL library 
• D、On your file network server.

第15题：

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.

第16题：

You observe that in your PROD database， customer information is being modified by some unauthorized users. You want to keep track of all of the transactions happening on the table using PL/SQL. Which type of PL/SQL subprogram or construct would you use to accomplish this task？（）

• A、functions
• B、packages
• C、procedures
• D、database triggers
• E、anonymous PL/SQL block

第17题：

In your Supportcenter.cn 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.

第18题：

You work as an application developer at Certkiller .com. Certkiller .com has instructed you to create a class named MetricFormula. This class will be used to compare MetricUnit and EnglishUnit objects.The MetricFormula is currently defined as follows （Line numbers are used for reference purposes only）： 1. public class MetricFormula2. { 3. 4. } You need to ensure that the MetricFormula class can be used to compare the required objects. What should you do？ （）

• A、 Add the following code on line 1： ： IComparable {
• B、 Add the following code on line 1： ： IComparer {
• C、 Add the following code on line 3： public int Compare （object x， object y） {// implementation code }
• D、 Add the following code on line 3： public int CompareTo （object obj） {// implementation code }

第19题：

第20题：

第21题：

第22题：

第23题：