网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
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')
参考答案
更多 “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 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
考题
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
考题
You create a master-detail form. The users need to be able to exit the form quickly, adhering to default transaction processing, regardless of the cursor location. You believe you can achieve this using a Key-Exit trigger. What do you need to do to implement this request? （）A、Define a Key-Exit trigger for all the blocks in the form. B、In the Object Navigator, highlight all the items and define a Key-Exit trigger. C、Define a Key-Exit trigger on the primary key item in the master block.D、No additional key-trigger definition is necessary.
考题
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.
考题
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.
考题
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.
考题
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.
考题
You are responsible for managing the database schema for an order entry application in a SQL Server 2005 database. After a design review, a member of the development staff asks you to add a new column named CommissionRate to the Product table. Because the actual commission rates for all products are not known at this time, each product has a default commission rate of 12 percent. The rate can be modified as necessary. You add the new column. You need to configure the table to assign the default value as efficiently as possible. What should you do?（）A、 Create an INSERT trigger to assign the default value to each item in the table. B、 Create a CHECK constraint to validate the data and to assign the default value to each item in the table. C、 Create an UPDATE trigger to update the default value for each new item in the table. D、 Create a DEFAULT constraint to assign the default value specifying the WITH VALUES argument.
考题
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 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.
考题
单选题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.
考题
单选题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.
考题
单选题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.
考题
单选题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？（）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.
考题
单选题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.
考题
单选题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
考题
单选题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')
热门标签
最新试卷