单选题Which type of PL/SQL construct would you use to automatically correct the error resulting from a statement that was suspended due to a space-related problem？（）AfunctionsBpackageCprocedureDdatabase triggerEanonymous PL/SQL block

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

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.

第3题：

You want to configure and schedule offline database backups to run automatically.  Which tool or utilitywould you use to achieve this（）

• A、the XML script
• B、the PL/SQL script
• C、the DBMS_SCHEDULER package
• D、Enterprise Manager to schedule the backup

第4题：

You are using the backup scheduler in Enterprise Manager （EM） to schedule a backup of your database. Which type of script does the backup scheduler generate？ （）

• A、SQL script
• B、PL/SQL script
• C、Operating System （OS） script
• D、Enterprise Manager （EM） script
• E、Recovery Manager （RMAN） script

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

Examine the following PL/SQL block：   SET SERVEROUTPUT ON SET LONG 10000 ECLARE report clob；  BEGIN report ：= DBMS_SPM.EVOLVE_SQL_PLAN_BASELINE（）； DBMS_OUTPUT.PUT_LINE（report）； END；   Which statement describes the effect of the execution of the above PL/SQL block？（）  

• A、 The plan baselines are verified with the SQL profiles.
• B、 All fixed plan baselines are converted into nonfixed plan baselines.
• C、 All the nonaccepted SQL profiles are accepted into the plan baseline.
• D、 The nonaccepted plans in the SQL Management Base are verified with the existing plan baselines.

第7题：

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

Which type of PL/SQL construct would you use to automatically correct the error resulting from a statement that was suspended due to a space/x7frelated problem？ （）

• A、function
• B、package
• C、procedure
• D、database trigger
• E、anonymous PL/SQL block

第14题：

Which type of PL/SQL construct would you use to automatically correct the error resulting from a statement that was suspended due to a space-related problem？（）

• A、 functions
• B、 package
• C、 procedure
• D、 database trigger
• E、 anonymous PL/SQL block

第15题：

You want to make use of the object features available in the database for the form module you are developing. Which three statements about object types are true? （）

• A、An object type is a user-defined composite data type. 
• B、The attributes of an object type can be those of other object types. 
• C、A PL/SQL table of records is an example of a nested object type. 
• D、An object type must be declared as a type before the actual object itself can be declared.

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

第19题：

第20题：

第21题：

第22题：

第23题：

第24题：