单选题You are building two forms. Each form has a button and a non-base table field. When the button is pressed, a complicated calculation is executed. The calculation is the same for both forms. The calculation code does not query or change the data in the 

题目
单选题
You are building two forms. Each form has a button and a non-base table field. When the button is pressed, a complicated calculation is executed. The calculation is the same for both forms. The calculation code does not query or change the data in the database. When the calculation completes, it returns a single value to the non-base table field. To optimize performance and maintainability, which PL/SQL structure should be used? （）
A

A trigger in each form. 

B

A subprogram in each form. 

C

A stored subprogram in the database. 

D

A subprogram in a library that is attached to each form.

相似考题

1.When will John give the feedback to Miller()A. After he talks with his manager.B. After he makes a careful calculation.C. After he does a market survey.

2.You are developing a Windows Presentation Foundation (WPF) application to play audio files. You add MediaElement mediaElement1 and a Button control named btnPlayAudio to the design surface. The MediaElement co.. audio file. The LoadedBehavior attribute is set to Manual.You add the following code to the main Window.You set the command of the button to MediaCommands.Play.You need to ensure that the application will play the audio file when the button is pressed.What should you add to constructor of the main window ?（）A.B.C.D.

3.You are creating the DEPT_SAL data block from the PAYHIST form. Users should be able to enter a valid department ID number, which will then display the employee salary information for that department. This data block could potentially retrieve a large number of records. Since users will probably only view a small number of these records, only 10 records should be fetched at one time. How would you create the data block?（）A、Select The Data Blocks node in the Object Navigator and click the Create button. Choose to build the data block manually, enter the procedure name in the Query Data Source Columns property, and the procedure code in the Query Data Source Arguments property. B、Choose Tools -> Data Block Wizard, select Table as the data source type, and base the block on the columns from the tables. C、Choose Tools -> Data Block Wizard, select, View as the data source type, and base the block on the columns from the tables. D、Select the Data Blocks node in the Object Navigator and click the Create button. Choose to build the data block manually, alter the Query Data Source Type property to 'FROM clause query', and enter the SELECT statement in the Query Data Source Name property. E、Select the Data Block node in the Object Navigator and click the Create button. Alter the Query Data Source Type, Query Data Source Name, Query Data Sources Columns, and Query Data Source Arguments properties to create a stored procedure that uses a red cursor.

4.You are the administrator of a SQL Server 2000 database. You import a table of geographic information from a Microsoft access database into a SQL Server 2000 database. The table has 12,000 rows. Each row averages 5,000 bytes. The table contains lockup data that does not change.You want to minimize the size of the data file and the time required to back up the data. Which two actions should you take? (Each correct answer presents part of the solution. Choose two)A. Create a 60-MB data file named geography.ndfB. Create a 95-MB data file named geography.ndfC. Create a 60-MB data file named geography.mdfD. Create a 95-MB data file named geography.mdfE. Place the table in the PRIMARY filegroup.F. Place the table in a new filegroup named LOCATION.

更多“单选题You are building two forms. Each form has a button and a non-base table field. When the button is pressed, a complicated calculation is executed. The calculation is the same for both forms. The calculation code does not query or change the data in the ”相关问题

  • 第1题：

    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

    正确答案:D

  • 第2题：

    Which two statements are true about mouse button variables?（）

    • A、SYSTEM.MOUSE_BUTTON_PRESSED returns a string. 
    • B、SYSTEM.MOUSE_BUTTON_PRESSED returns a numeric value. 1Z0-132 World Leaders In Certifications Material - Test-king.com 
    • C、A possible value for SYSTEM.MOUSE_BUTTON_MODIFIERS is Control+Alt+Delete. 
    • D、SYSTEM.MOUSE_BUTTON_MODIFIERS can only be references in form-level triggers. 
    • E、SYSTEM.MOUSE_BUTTON_MODIFIERS identifies which special key was pressed in conjunction with the usual mouse button action. 

    正确答案:B,E

  • 第3题：

    You are working in an online transaction processing （OLTP） environment. You realize that the salary for an employee， John， has been accidentally modified in the EMPLOYEES table. Two days ago， the data was in the correct state. Flashback logs generated during last two days are available in the flash recovery area.  Which option would you choose to bring the data to the correct state while ensuring that no other data in the same table is affected？（）

    • A、perform point-in-time recovery
    • B、perform a Flashback Table operation to restore the table to the state it was in two days ago
    • C、perform a Flashback Database operation to restore the database to the state it was in two days ago
    • D、perform Flashback Versions Query and Flashback Transaction Query to determine all the necessary undo SQL statements， and then use them for recovery

    正确答案:D

  • 第4题：

    Which three scenarios describe appropriate uses for key triggers?（）

    • A、Alter data in a database table. 
    • B、Add custom item validation code. 
    • C、Disable the Next Block key and menu item. 
    • D、Display a custom form in place of a List of Values. 
    • E、Change the navigational order of the blocks in a form. 
    • F、Perform a complex calculation each time the F10 key is pressed. 

    正确答案:C,D,E

  • 第5题：

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

    正确答案:A

  • 第6题：

    You are creating a custom user control. The custom user control will be used on 10 Web Forms for an ASP.NET Web site that allows users to register and log on to a personalized experience. The custom user control uses two TextBox controls and two Button controls. You need to ensure that the controls are visible only when users are not logged on to the Web site. You also need to minimize the amount of effort in development and maintenance for the Web site. Which two actions should you perform? （）

    • A、Add the OnClick event handler for the Login button to the code used in the custom user control.
    • B、Add the OnClick event handler for the Login button to the code used in the Web Form where the control is added.
    • C、In the Page_Load method of the Web Form, add a code segment to set the visibility of the TextBox and Button controls where the control is added.
    • D、In the Page_Load method of the custom user control, add a code segment to set the visibility of the TextBox and Button controls.

    正确答案:A,D

  • 第7题：

    单选题
    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 fund code entered. The value needed to generate this summary data are stored in multiple tables. How would you define the data source for this data block without having the DBA create a database object? （）
    A

    Choose Tools -> Data Block Wizard, select View as the data source type, and base the block on the columns from the bales. 

    B

    Choose Tools -> Data Block Wizard, select Table as the data source type, and base the block on the columns from the tables. 

    C

    Select the Data Blocks node in the Object Navigator and click the Create button. Choose to build the data block manually and alter the Query Data Source Columns and Query Data Source Arguments properties to enter the SELECT statement. 

    D

    Select the Data Blocks node in the Object Navigator and click the Create button. Choose to build the data block manually, alter the Query Data Source Type property to 'Table', and enter the SELECT statement in the Query Data Source Name property. 

    E

    Choose Tools -> Data Block Wizard, select Stored Procedure as the data source type, and base the block on the columns the tables. 

    F

    Select the Data Blocks node in the Object Navigator and click the Create button. Choose to build the data block manually. Alter the Query Data Source Type to 'FROM' clause query', and enter the SELECT statement in the Query Data Source Name property.


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

  • 第8题：

    单选题
    You are developing the Payroll application that contains the SALARY and COMMISSION forms. When a user invoked the COMMISSION form from the SALARY form, the SAL value should be passed to the COMMISSION form. In which data form and at what time should you define the parameter to accept the value?（）
    A

    SALARY form at runtime. 

    B

    SALARY form at design time. 

    C

    COMMISSION form at runtime. 

    D

    COMMISSION form at design time. 


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

  • 第9题：

    单选题
    You are creating the DEPT_SAL data block from the PAYHIST form. Users should be able to enter a valid department ID number, which will then display the employee salary information for that department. This data block could potentially retrieve a large number of records. Since users will probably only view a small number of these records, only 10 records should be fetched at one time. How would you create the data block?（）
    A

    Select The Data Blocks node in the Object Navigator and click the Create button. Choose to build the data block manually, enter the procedure name in the Query Data Source Columns property, and the procedure code in the Query Data Source Arguments property. 

    B

    Choose Tools -> Data Block Wizard, select Table as the data source type, and base the block on the columns from the tables. 

    C

    Choose Tools -> Data Block Wizard, select, View as the data source type, and base the block on the columns from the tables. 

    D

    Select the Data Blocks node in the Object Navigator and click the Create button. Choose to build the data block manually, alter the Query Data Source Type property to 'FROM clause query', and enter the SELECT statement in the Query Data Source Name property. 

    E

    Select the Data Block node in the Object Navigator and click the Create button. Alter the Query Data Source Type, Query Data Source Name, Query Data Sources Columns, and Query Data Source Arguments properties to create a stored procedure that uses a red cursor.


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

  • 第10题：

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


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

  • 第11题：

    单选题
    You are working in an online transaction processing （OLTP） environment. You realize that the salary for an employee， John， has been accidentally modified in the EMPLOYEES table. Two days ago， the data was in the correct state. Flashback logs generated during last two days are available in the flash recovery area.  Which option would you choose to bring the data to the correct state while ensuring that no other data in the same table is affected？（）
    A

    perform point-in-time recovery

    B

    perform a Flashback Table operation to restore the table to the state it was in two days ago

    C

    perform a Flashback Database operation to restore the database to the state it was in two days ago

    D

    perform Flashback Versions Query and Flashback Transaction Query to determine all the necessary undo SQL statements， and then use them for recovery


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

  • 第12题：

    多选题
    Which three scenarios describe appropriate uses for key triggers?（）
    A

    Alter data in a database table.

    B

    Add custom item validation code.

    C

    Disable the Next Block key and menu item.

    D

    Display a custom form in place of a List of Values.

    E

    Change the navigational order of the blocks in a form.

    F

    Perform a complex calculation each time the F10 key is pressed.


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

  • 第13题：

    when robert created a response form. he set the "formulas inherit values from selected document" option on the form properties, the field name on the review form is the same as the field name on the inheriting form, however the form does not inherit any data ,why ?（）

    • A、he failed to specify the form type  
    • B、the inheriting form is not a response form  
    • C、he specified the same field names on both forms 
    • D、he failed to provide inheritance formulas for each field 

    正确答案:D

  • 第14题：

    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 fund code entered. The value needed to generate this summary data are stored in multiple tables. How would you define the data source for this data block without having the DBA create a database object? （）

    • A、Choose Tools -> Data Block Wizard, select View as the data source type, and base the block on the columns from the bales. 
    • B、Choose Tools -> Data Block Wizard, select Table as the data source type, and base the block on the columns from the tables. 
    • C、Select the Data Blocks node in the Object Navigator and click the Create button. Choose to build the data block manually and alter the Query Data Source Columns and Query Data Source Arguments properties to enter the SELECT statement. 
    • D、Select the Data Blocks node in the Object Navigator and click the Create button. Choose to build the data block manually, alter the Query Data Source Type property to 'Table', and enter the SELECT statement in the Query Data Source Name property. 
    • E、Choose Tools -> Data Block Wizard, select Stored Procedure as the data source type, and base the block on the columns the tables. 
    • F、Select the Data Blocks node in the Object Navigator and click the Create button. Choose to build the data block manually. Alter the Query Data Source Type to 'FROM' clause query', and enter the SELECT statement in the Query Data Source Name property.

    正确答案:F

  • 第15题：

    You are developing the Payroll application that contains the SALARY and COMMISSION forms. When a user invoked the COMMISSION form from the SALARY form, the SAL value should be passed to the COMMISSION form. In which data form and at what time should you define the parameter to accept the value?（）

    • A、SALARY form at runtime. 
    • B、SALARY form at design time. 
    • C、COMMISSION form at runtime. 
    • D、COMMISSION form at design time. 

    正确答案:D

  • 第16题：

    You are building two forms. Each form has a button and a non-base table field. When the button is pressed, a complicated calculation is executed. The calculation is the same for both forms. The calculation code does not query or change the data in the database. When the calculation completes, it returns a single value to the non-base table field. To optimize performance and maintainability, which PL/SQL structure should be used? （）

    • A、A trigger in each form. 
    • B、A subprogram in each form. 
    • C、A stored subprogram in the database. 
    • D、A subprogram in a library that is attached to each form.

    正确答案:D

  • 第17题：

    You create a Web Form that contains a button named btnCancel that enables users to exit the page. When users click this button, validation must not occur. During testing you learn that clicking the Cancel button does not enable users to exit the page. You need to ensure that users can always exit the page. What should you do?（）

    • A、Set the Enabled property of the validation controls on the Web Form to False.
    • B、Set the CausesValidation property of the btnCancel button to False.
    • C、Set the CausesValidation property of the btnCancel button to True.
    • D、Set the Visible property of the validation controls on the Web Form to False.

    正确答案:B

  • 第18题：

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


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

  • 第19题：

    单选题
    You are creating the SAL_INFO data block on the EMP_QUERY form. The SALARY field should only be populated if the logged-on user is a manager. Since this query could potentially return a large amount of records, you have created a stored procedure which uses a ref cursor on which to base the data block. How would you create the data block?（）
    A

    Click the Data Blocks node in the Object Navigator and click the create button. Choose to build the data block manually. Enter the procedure name in the Query Data Source Columns property and the procedure code in the Query Data Source Arguments property. 

    B

    Choose Tools -> Data Block Wizard, select Table as the data source type, and base the data block on the columns included in the procedure. 

    C

    Select the Data Blocks node in the Object Navigator and click the Create button. Choose to build the data block manually, alter the Query Data Source Type property to 'Ref cursor', and enter the name of the procedure in the Query Data Source Name property. 

    D

    Select the Data Blocks node in the Object Navigator and click the Create button. Alter the Query Data Source Name, Query Data Source Columns, and Query Data Source Arguments properties to create a stored procedure that uses a ref cursor. 

    E

    Launch the Data Block Wizard, select Stored Procedures as the data source type, and base the block on the procedure.


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

  • 第20题：

    单选题
    when robert created a response form. he set the "formulas inherit values from selected document" option on the form properties, the field name on the review form is the same as the field name on the inheriting form, however the form does not inherit any data ,why ?（）
    A

    he failed to specify the form type  

    B

    the inheriting form is not a response form  

    C

    he specified the same field names on both forms 

    D

    he failed to provide inheritance formulas for each field 


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

  • 第21题：

    单选题
    You create a Web Form that contains a button named btnCancel that enables users to exit the page. When users click this button, validation must not occur. During testing you learn that clicking the Cancel button does not enable users to exit the page. You need to ensure that users can always exit the page. What should you do?（）
    A

    Set the Enabled property of the validation controls on the Web Form to False.

    B

    Set the CausesValidation property of the btnCancel button to False.

    C

    Set the CausesValidation property of the btnCancel button to True.

    D

    Set the Visible property of the validation controls on the Web Form to False.


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

  • 第22题：

    单选题
    How do you determine the weight of the vessel that is supported by the ground when a vessel has run aground?（）.
    A

    This requires extensive calculation and is usually performed only by a naval architect not by a ship's officer

    B

    Determine the point where aground and the draft at that point，then calculate it using the grounding formula

    C

    Use the hydrostatic tables and enter with the mean draft before grounding and the mean draft after grounding

    D

    Use the inclining experiment formula and substitute the change of trim for the angle of list


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

  • 第23题：

    多选题
    Which two statements are true about mouse button variables?（）
    A

    SYSTEM.MOUSE_BUTTON_PRESSED returns a string.

    B

    SYSTEM.MOUSE_BUTTON_PRESSED returns a numeric value. 1Z0-132 World Leaders In Certifications Material - Test-king.com

    C

    A possible value for SYSTEM.MOUSE_BUTTON_MODIFIERS is Control+Alt+Delete.

    D

    SYSTEM.MOUSE_BUTTON_MODIFIERS can only be references in form-level triggers.

    E

    SYSTEM.MOUSE_BUTTON_MODIFIERS identifies which special key was pressed in conjunction with the usual mouse button action.


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

相关内容