单选题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?()AEXIT BEXIT_FORM CDO_KEY('Key-Exit') DDO_KEY('EXIT_FORM')
单选题
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')
参考解析
解析:
暂无解析
相关考题:
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
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 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.
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.
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、MacroD、PL/SQL
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.
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.
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.
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')
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.
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、functionsB、packagesC、proceduresD、database triggersE、anonymous PL/SQL block
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 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.
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.
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.
单选题The users request that [F2], [F3], and [F4] be used to commit, rollback, and exit,respectively. How do you accomplish this?()AAdd the appropriate PL/SQL code for each key. BMap the logical keys to the physical keys, then add the appropriate PL/SQL code for each key.CCreate an object library to define the key triggers, then reference the object library in the form. DThis cannot be accomplished because other function keys provide this functionality by default.
单选题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?()AfunctionsBpackagesCproceduresDdatabase triggersEanonymous PL/SQL block
单选题How would you default the layout of a parameter form? ()AUse the default layout tool in the parameter form editor. BSelect menu item tool-parameter form builder. COpen the parameter form editor and select menu items tool-default layout. DYou cannot default the layout of the parameters.
单选题Where can you add your own PL/SQL code in relation-handling triggers?()ABefore the End default relation program section comment. BAfter the Begin default relation program section comment. CBefore the Begin default relation program section comment. DIt is not possible to modify the relation-handling code that Forms automatically creates for relations.
单选题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?()AItem Roles. BMenu Item Roles. CDisplay without Privilege. DUse Security. ECommand Type.
多选题Which two statements describe good practices for an application developer to reduce lockingconflicts in Oracle database()AAvoid coding unnecessary long-running transactions.BAllow the database to handle locks in default locking mode.CAlways explicitly code the locks as per the requirement of the application.DAllow escalation of row locks to block locks if too many row locks cause problem.
单选题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.
单选题In your Supportcenter.cn database server the parameter PLSQL_CODE_TYPE has been set to NATIVE. Which object would be achieved by the setting?()AThe source PL/SQL code will be stored in native machine code.BThe source PL/SQL code will be stored in interpreted byte code.CThe compiled PL/SQL code will be stored in native machine code.DThe compiled PL/SQL code will be stored in interpreted byte code.
单选题In your Certkiller .com database server the parameter PLSQL_CODE_TYPE has been set to NATIVE. Which object would be achieved by the setting?()AThe source PL/SQL code will be stored in native machine code.BThe source PL/SQL code will be stored in interpreted byte code.CThe compiled PL/SQL code will be stored in native machine code.DThe compiled PL/SQL code will be stored in interpreted byte code.
单选题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?()AIt performs parallel recompilation of only the stored PL/SQL code.BIt performs sequential recompilation of only the stored PL/SQL code.CIt performs parallel recompilation of any stored PL/SQL as well as Java code.DIt performs sequential recompilation of any stored PL/SQL as well as Java code.
单选题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? ()AMenu BPlus CMacroDPL/SQL
单选题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
单选题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?()AEXIT BEXIT_FORM CDO_KEY('Key-Exit') DDO_KEY('EXIT_FORM')