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 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 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 are the administrator of a SQL Server 2000 computer named SQL1. You want to perform. ad hoc distribution queries against a database that is stored on a SQL Server 2000 computer named SQL2. SQL2 contains several databases, and each of these databases uses a different collation.You want to ensure that comparisons in distributed queries are evaluated correctly. You also want to minimize administrative overhead.How should you configure SQL1?A.Use the ALTER DATABASE statement to change the collation of the databases on SQL1.B.Add SQL2 as remote server.C.Add SQL2 as a linked server. Select the Use Remote Collation check box, and do not specify a collation name.D.Add SQL2 as a linked server. Select the Use Remote Collation check box, and specify a collation name. Repeat this process once for each database on SQL2.
You need to configure Active Directory to implement the new password policy for the HR department. What should you do?()A、Create a new child domain named hr.ad.margiestravel.com in the existing forest. Move the resources from the HR OU to this new domain. Add the appropriate security settings in the Default Domain Policy for this new domain.B、Add the appropriate security settings to the current Default Domain Policy.C、Add the appropriate security settings to the local security policy of SQL1.D、Set the SQL server check_policy and check_expiration options to On when creating all user accounts.
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 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.
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 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.
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 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.
You design a Business Intelligence (BI) solution by using SQL Server 2008. You plan to design the report strategy for a new report project that will be used by a financial application. The application uses five calculations that are implemented in Microsoft .NET Framework 3.5 assemblies. The assemblies are written in the C# language and use the static methods. You need to ensure that the calculations can be used by the expressions in all reports. You also need to ensure consistency within the reports by using the least amount of development effort. What should you do?()A、 Add a reference to the assemblies in the Report Properties References tab. B、 Write the calculation logic used by the calculations by using T-SQL functions. C、 Write the code of the calculation logic into the Report Properties Custom Code tab.D、 Write the calculation logic in each report by using the mathematical functions available natively to SQL Server 2008 Reporting Services (SSRS).
You work as an application developer at Certkiller .com. Certkiller .com has instructed you to create a class named MetricFormula. This class will be used to compare MetricUnit and EnglishUnit objects.The MetricFormula is currently defined as follows (Line numbers are used for reference purposes only): 1. public class MetricFormula2. { 3. 4. } You need to ensure that the MetricFormula class can be used to compare the required objects. What should you do? ()A、 Add the following code on line 1: : IComparable {B、 Add the following code on line 1: : IComparer {C、 Add the following code on line 3: public int Compare (object x, object y) {// implementation code }D、 Add the following code on line 3: public int CompareTo (object obj) {// implementation code }
You are designing a group management strategy for users in the finance department. You need to identify the appropriate changes that need to be made to the current group management strategy. You want to accomplish this goal by using the minimum number of groups. What should you do?()A、 Add the finance users to the financeData group to which the necessary permissions have been assigned.B、 Add the finance users to the financeGG group to which the necessary permissions have been assigned.C、 Add the finance users to the financeGG group. Then add the financeGG group to the financeData group to which the necessary permissions have been assigned.D、 Add the finance users to the financeGG group. Add the financeGG group to the financeUG group to the financeDat group to which the necessary permissions have been assigned.
单选题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 write a procedure that will be called from two level triggers and a database trigger. Where should you store this code? ()AOn the Oracle server. BLocally in each form module. CIn an attached PL/SQL library DOn your file network server.
单选题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?()AWrite client-side subprograms containing the PL/SQL8 constructs, and move them into an object group. BWrite server-side subprograms, and call the subprograms from the form application. CStore the PL/SQL8 constructs in a PL/SQL library, and attack the library to each form muddle in your application.
单选题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 design a Business Intelligence (BI) solution by using SQL Server 2008. You plan to design the report strategy for a new report project that will be used by a financial application. The application uses five calculations that are implemented in Microsoft .NET Framework 3.5 assemblies. The assemblies are written in the C# language and use the static methods. You need to ensure that the calculations can be used by the expressions in all reports. You also need to ensure consistency within the reports by using the least amount of development effort. What should you do?()A Add a reference to the assemblies in the Report Properties References tab. B Write the calculation logic used by the calculations by using T-SQL functions. C Write the code of the calculation logic into the Report Properties Custom Code tab.D Write the calculation logic in each report by using the mathematical functions available natively to SQL Server 2008 Reporting Services (SSRS).
单选题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.
单选题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')