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 s

第1题：

The sales report needs to display the sales person with the highest order total. Which build report builder component would you use to create a place holder column to display the value?（）

• A、Report wizard. 
• B、Layout model. 
• C、Data model. 
• D、Life previewer.

第2题：

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.

第3题：

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.

第4题：

In which two scenarios do you use SQL* Loader to load data?（）

• A、Transform the data while it is being loaded into the database.
• B、Use transparent parallel processing without having to split the external data first.
• C、Load data into multiple tables during the same load statement.
• D、Generate unique sequential key values in specified columns.

第5题：

Which two statements are true regarding the usage of the SQL*Loader utility（）

• A、You can load data into multiple tables during the same load session.
• B、You can load data from multiple files to a table during the same load session.
• C、You cannot perform selective data loading based on the values available in the records.
• D、You can use an export file generated by the EXPDP utility as an input data file to load the data.
• E、You can load data only if the input file is available on the disk and tape but not in a named pipes.

第6题：

You need to display a very large single-record data block. Since it will be so large, a convenient means of navigation is needed between items. Which type of canvas would you use to display the data block? （）

• A、Tab canvas. 
• B、Pop up canvas. 
• C、Spread table canvas. 
• D、Vertical toolbar canvas.

第7题：

You need to create a form for Payroll application that will allow the user to view all information for any employee ID queried. This data should be displayed to the user in a grouped format. The user should be able to choose which information they want to see from a pull down list containing the values PERSONAL and PAYROLL. Which format should you use to create this form?（）

• A、One content canvas and multiple stacked canvases. 
• B、One content and one stacked canvas.
• C、Tab canvas with several tab pages. 
• D、One content canvas. 
• E、A horizontal and vertical toolbar.

第8题：

You are creating a Windows Forms Application by using the .NET Framework 3.5.You plan to design a new control that will be used on multiple forms in the app.You need to ensure that the control meets the following requirement  （1）It retrieves data from a MSSQL Server 2008 database instance. （2）It uses WPF classes to display data.  （3）It uses user-customizable actions when the control is first painted on the form.   What should you do？（）

• A、Create a new custom class for the control that is derived from the Control class.
• B、Create a new custom class for the control that is derived from the UserControl class.
• C、Create a new custom class for the control that is derived from the ContentControl class.
• D、Create a new custom class for the control that is derived from the ContentPresenter class.

第9题：

You design a Business Intelligence （BI） solution by using SQL Server 2008.  You plan to create a SQL Server 2008 Reporting Services （SSRS） solution that contains five sales dashboard reports.  Users must be able to manipulate the reports’ parameters to analyze data. You need to ensure that the following requirements are met： Users can manipulate the parameters for data analysis in a single trip to the data source.  Reports are automatically rendered as soon as they are accessed for the first time. Which two tasks should you perform？（）

• A、 Filter data by using expressions.
• B、 Specify the default values for each parameter.
• C、 Create an available values list for each parameter.
• D、 Create report parameters by using query parameters to filter data at the data source.

第10题：

You create a Web Form. The Web Form allows users to log on to a Web site. You implement the login logic using a Login control named Login1. The membership data for the application is stored in a SQL Express database in the App_Data directory. You need to configure your application so that the membership data is stored in a local Microsoft SQL Server database. You add the following code segment to the Web.config file. Which two additional actions should you perform?（）

• A、Use Aspnet_regsql.exe to create the Microsoft SQL Server database.
• B、Set Login1's MembershipProvider property to MySqlProviderConnection.
• C、Add the following code segment to the Web.config file.<connectionStrings> <add name="MySqlProviderConnection" connectionString="valid connection string" /></connectionStrings>
• D、Add the following code segment to the Web.config file.  <appSettings><add key="MySqlProviderConnection" value="valid connection string" /></appSettings>
• E、In the ASP.NET configuration settings within IIS, ensure that Role Management Enabled is selected.
• F、Use the Web Site Administration Tool to select AspNetSqlMembershipProvider as the membership provider for your application.

第11题：

第12题：

第13题：

You need to create a data block for DML operations in the NEW_EMPLOYEE form module. Which data source can you use for this block?（）

• A、REF cursor query. 
• B、Stored function. 
• C、From clause query. 
• D、Transactional trigger.

第14题：

A UDT is a data type which:（）

• A、must contain unique values.
• B、cannot be CAST to other data types.
• C、is created using the CREATE DISTINCT command.
• D、contains a value that was automatically calculated from values in other columns.

第15题：

Evaluate the following command：   SQL> CREATE TABLE design_data （id NUMBER， doc CLOB）  LOB（doc） STORE AS SECUREFILE（DEDUPLICATE）；   Which statement is true regarding the above command？（）  

• A、 The LOB values are automatically compressed.
• B、 The LOB values are cached by default in the buffer cache.
• C、 The LOB values are automatically stored in encrypted mode.
• D、 All LOB data that is identical in two or more rows in a LOB column share the same data blocks.

第16题：

36 You are creating a report wizard to create a matrix report. The query build, you select the patient_name column from the patient table; the doctor_name from the doctors table; and the doctor_ID, patient_ID and ID columns from the procedure table. In the report wizard you select patient_name as the row value, doctor_ID as the column values and the count as the cell values. You need to add a total for each doctors column. In the wizard report which tab will allow you to create the summary column?（）

• A、Rows 
• B、Totals 
• C、Columns 
• D、Cells 
• E、Data

第17题：

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. 

第18题：

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.

第19题：

Which tasks can be accomplished using the Enterprise Manager Support Workbench in Oracle Database 11g？（） 

• A、 Generate reports on data failure such as data file failures.
• B、 You can track the Service Request （SR） and implement repairs.
• C、 You can package and upload diagnostic data to Oracle Support.
• D、 You can manually run health checks to gather diagnostic data for a problem.

第20题：

You use Microsoft .NET Framework 4 to create a Windows Forms application. You add a new class named Customer to the application. You select the Customer class to create a new object data source. You add the following components to a Windows Form: A BindingSource component named customerBindingSource that is data-bound to the Customer object data source. A set of TextBox controls to display and edit the Customer object properties. Each TextBox control is data-bound to a property of the customerBindingSource component. An ErrorProvider component named errorProvider that validates the input values for each TextBox control. You need to ensure that the input data for each TextBox control is automatically validated by using the ErrorProvider component. Which two actions should you perform?（）

• A、 Implement the validation rules inside the Validating event handler of each TextBox control by throwing an exception when the value is invalid.
• B、 Implement the validation rules inside the TextChanged event handler of each TextBox control by throwing an exception when the value is invalid.
• C、 Implement the validation rules inside the setter of each property of the Customer class by throwing an exception when the value is invalid.
• D、 Add the following code segment to the InitializeComponent method of the Windows Form.   this.errorProvider.DataSource = this.customerBindingSource;
• E、 Add the following code segment to the InitializeComponent method of the Windows Form.    this.errorProvider.DataSource = this.customerBindingSource.DataSource;    this.errorProvider.DataMember = this.customerBindingSource.DataMember;

第21题：

You design a Business Intelligence （BI） solution by using SQL Server 2008. You plan to create a SQL Server 2008 Reporting Services （SSRS） solution. Developers generate random reports against a data source that contains 200 tables. Power users generate random reports against four of the 200 tables. You need to design a strategy for the SSRS solution to meet the following requirements： ·Uses minimum amount of development effort. ·Provides two sets of tables in SSRS to the developers group and the power users group. Which strategy should you use？（）

• A、 Create two Report Builder models.Include the four frequently used tables in the first model and all the tables in the second model.
• B、 Create a Report Builder model by using all the tables.Create a perspective within the model to use only the four frequently used tables.
• C、 Create a Report Builder model by using all the tables. Create two folders.Place the four frequently used tables in the first folder and the remaining tables in the second folder.
• D、 Create two Data Source Views.Include all the tables in one Data Source View and the four frequently used tables in the other Data Source View.Create two Report Builder models so that each model uses one of the Data Source Views.

第22题：

You need to ensure that old data and current data can be queried according to the business requirements. What should you do?（）

• A、Specify a view based on the archival data table and current data tables.
• B、Specify that the data must be queried by using a stored procedure.
• C、Specify that both the archival data table and the current data tables must have indexes created on the same columns.
• D、Specify that a SQL Server Agent job must be used to copy current data into the archival data table each night.

第23题：