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

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.


参考答案:D

第2题:

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

第3题:

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.


参考答案:A

第4题:

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

第5题:

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

第6题:

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.

正确答案:E

第7题:

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

第8题:

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

B. Create a 95-MB data file named geography.ndf

C. Create a 60-MB data file named geography.mdf

D. Create a 95-MB data file named geography.mdf

E. Place the table in the PRIMARY filegroup.

F. Place the table in a new filegroup named LOCATION.


正确答案:BF
B,F 解析:Explanation: As SQL Server 2000 supports backing up or restoring individual files or file groups within a database, it is possible to reduce back up time by creating a separate data file table so that only that table will be backed up. This separate data file will have to be a secondary data file because a database can only have one primary data file, which is identified by the .mdf extension, it is the starting point of the database and locates all the other files in the database. Secondary data files are identified by the .ndf extension and comprise all of the data files except the primary data file. A database need not have a secondary data file and it is also possible to create multiple secondary data files on database.

Rows are stored in data pages. Rows cannot cross different data pages. The size of data page in SQL Server 2000 (or SQL 7.0) is 8,192 bytes. We can only store one row in every data page in this scenario. Thus, to estimate the size of the tale we would need to multiply the number of rows, 12,000 in this scenario, by 8,192 bytes. This will give us a table size of 98,304,000 bytes. As computer data storage is calculated using the binary rather than the decimal system, there is 1,024 bytes per Kb and 1,024 Kb per MB, rather than 1,000 bytes per Kb and 1,000 Kb per MB, we thus require a database size of at least 93.75 MB.

Incorrect Answers:
A: The data size of this table is insufficient as a minimum size of 93.75 MB is required.

C: The data size of this table is insufficient as a minimum size of 93.75 MB is required. Furthermore, the .mdf file extension indicate in this solution implies that the data file will be placed in the primary filegroup. It would thus not be possible to backup the data file pertaining to the table only.

D: The .mdf file extension indicate in this solution implies that the data file will be placed in the primary filegroup. It would thus not be possible to backup the data file pertaining to the table only.

E: As SQL Server 2000 supports backing up or restoring individual files or file groups within a database, it is possible to reduce back up time by creating a separate data file table so that only that table will be backed up. This separate data file will have to be a secondary data file because a database can only have one primary data file, which is identified by the .mdf extension, it is the starting point of the database and locates all the other files in the database.

第9题:

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

第10题:

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

更多相关问题