单选题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 int

题目
单选题
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.

相似考题

1.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.sqlWhat 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.

2. In your database， the RESULT_CACHE_MODE parameter has been set to MANUAL in the initialization parameter file. You issued the following command：   SQL>SELECT /*+ RESULT_CACHE */ sale_category， sum（sale_amt） FROM sales  GROUP BY sale_category；   Where would the result of this query be stored（）？  A、 database buffer cacheB、 shared poolC、 PGAD、 large pool

3.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 found code entered. The values needed to generate this summary data are stored in multiple tables. Which data source type can you assign to the data block for this form without having the DBA create a database object?（）A、database table B、transactional trigger C、stored procedure D、FROM clause query E、client-side procedure

4.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 codeB. Sequential recompilation of only the stored PL/SQL codeC. Parallel recompilation of any stored PL/SQL codeD. Sequential recompilation of any stored PL/SQL codeE. Parallel recompilation of Java codeF. Sequential recompilation of Java code

更多“单选题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 int”相关问题

  • 第1题：

    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.

    正确答案:C

  • 第2题：

    Your system has been upgraded from Oracle Database 10g to Oracle Database 11g. You imported SQL Tuning Sets （STS） from the previous version. After changing the  OPTIMIZER_FEATURE_ENABLE parameter to 10.2.0.4 and running the SQL Performance Analyzer， you observed performance regression for a few SQL statements.  What would you do with these SQL statements？（）

    • A、 Set OPTIMIZER_USE_PLAN_BASELINES to FALSE to prevent the use of regressed plans.
    • B、 Capture the plans from the previous version using STS and then load them into the stored outline.
    • C、 Capture the plans from the previous version using STS and then load them into SQL Management Base （SMB）
    • D、 Set OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES to FALSE to prevent the plans from being loaded to the SQL plan baseline.

    正确答案:C

  • 第3题：

    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.

    正确答案:A

  • 第4题：

    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.

    正确答案:C

  • 第5题：

    You are analyzing how Oracle processes user statements. SQL and PL/SQL parse information is stored in which of the following database memory areas? （）

    • A、Library cache 
    • B、Row cache
    • C、Dictionary cache 
    • D、Large area 
    • E、Buffer cache

    正确答案:B

  • 第6题：

    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

    正确答案:D

  • 第7题：

    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.

    正确答案:C

  • 第8题：

    单选题
    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


    正确答案： C
    解析： 暂无解析

  • 第9题：

    单选题
    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.


    正确答案： C
    解析： 暂无解析

  • 第10题：

    单选题
    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.


    正确答案： C
    解析： 暂无解析

  • 第11题：

    单选题
    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.


    正确答案： D
    解析： 暂无解析

  • 第12题：

    单选题
    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


    正确答案： B
    解析： 暂无解析

  • 第13题：

    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.

    正确答案:A

  • 第14题：

    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.

    正确答案:B

  • 第15题：

    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

    正确答案:D

  • 第16题：

    Which two PL/SQL8 features are supported in Oracle Forms?（）

    • A、methods 
    • B、object tables 
    • C、object columns 
    • D、collection types 
    • E、object as stored procedure parameters

    正确答案:B,C

  • 第17题：

    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.

    正确答案:C

  • 第18题：

    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

    正确答案:C,E

  • 第19题：

    You create a Web Form. The Web Form allows users to log on to a Web site. You implement the login logic using a Login control named Login1. The membership data for the application is stored in a SQL Express database in the App_Data directory. You need to configure your application so that the membership data is stored in a local Microsoft SQL Server database. You add the following code segment to the Web.config file. Which two additional actions should you perform?（）

    • A、Use Aspnet_regsql.exe to create the Microsoft SQL Server database.
    • B、Set Login1's MembershipProvider property to MySqlProviderConnection.
    • C、Add the following code segment to the Web.config file.<connectionStrings> <add name="MySqlProviderConnection" connectionString="valid connection string" /></connectionStrings>
    • D、Add the following code segment to the Web.config file.  <appSettings><add key="MySqlProviderConnection" value="valid connection string" /></appSettings>
    • E、In the ASP.NET configuration settings within IIS, ensure that Role Management Enabled is selected.
    • F、Use the Web Site Administration Tool to select AspNetSqlMembershipProvider as the membership provider for your application.

    正确答案:B,D

  • 第20题：

    单选题
    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.


    正确答案： D
    解析： 暂无解析

  • 第21题：

    单选题
    You are analyzing how Oracle processes user statements. SQL and PL/SQL parse information is stored in which of the following database memory areas? （）
    A

    Library cache 

    B

    Row cache

    C

    Dictionary cache 

    D

    Large area 

    E

    Buffer cache


    正确答案： E
    解析： 暂无解析

  • 第22题：

    单选题
    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.


    正确答案： D
    解析： 暂无解析

  • 第23题：

    单选题
    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.


    正确答案： A
    解析： 暂无解析

相关内容