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

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

相似考题

1.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、 .PLDD、 .PRT

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

4.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.

更多“单选题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题：

    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

    正确答案:A

  • 第2题：

    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

  • 第3题：

    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')

    正确答案:D

  • 第4题：

    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

  • 第5题：

    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

  • 第6题：

    How would you default the layout of a parameter form? （）

    • A、Use the default layout tool in the parameter form editor. 
    • B、Select menu item tool->parameter form builder. 
    • C、Open the parameter form editor and select menu items tool->default layout. 
    • D、You cannot default the layout of the parameters.

    正确答案:B

  • 第7题：

    单选题
    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
    解析： 暂无解析

  • 第8题：

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


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

  • 第9题：

    多选题
    Which two statements describe good practices for an application developer to reduce lockingconflicts in Oracle database（）
    A

    Avoid coding unnecessary long-running transactions.

    B

    Allow the database to handle locks in default locking mode.

    C

    Always explicitly code the locks as per the requirement of the application.

    D

    Allow escalation of row locks to block locks if too many row locks cause problem.


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

  • 第10题：

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


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

  • 第11题：

    单选题
    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
    解析： 暂无解析

  • 第12题：

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


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

  • 第13题：

    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.

    正确答案:C

  • 第14题：

    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

  • 第15题：

    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.

    正确答案:C

  • 第16题：

    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

  • 第17题：

    Which two statements describe good practices for an application developer to reduce lockingconflicts in Oracle database（）

    • A、Avoid coding unnecessary long-running transactions.
    • B、Allow the database to handle locks in default locking mode.
    • C、Always explicitly code the locks as per the requirement of the application.
    • D、Allow escalation of row locks to block locks if too many row locks cause problem.

    正确答案:A,B

  • 第18题：

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


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

  • 第19题：

    单选题
    How would you default the layout of a parameter form? （）
    A

    Use the default layout tool in the parameter form editor. 

    B

    Select menu item tool->parameter form builder. 

    C

    Open the parameter form editor and select menu items tool->default layout. 

    D

    You cannot default the layout of the parameters.


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

  • 第20题：

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


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

  • 第21题：

    单选题
    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
    解析： 暂无解析

  • 第22题：

    单选题
    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
    解析： 暂无解析

  • 第23题：

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


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

  • 第24题：

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


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

相关内容