单选题You are developing a report to allow customers in a department store to view product information. You added a button to the layout to allow customers to view the picture of the product. Which button property would you alter to specify the source of the

第1题：

You are creating a tabular report for the sales department with a department break group. You need to ensure that if al least six sales records will not fit at the button of a page, the group will start on the next page. Which printing frame property would you alter to achieve these results?（）

• A、Source 
• B、Print direction 
• C、Maximum records per page 
• D、Minimum Widow records 
• E、Column mode

第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题：

You need to create a view EMP_VU. The view should allow the users to manipulate the records of only the employees that are working for departments 10 or 20.Which SQL statement would you use to create the view EMP_VU?（）

• A、CREATE VIEW emp_vu AS SELECT * FROM employees WHERE department_id IN (10,20);
• B、CREATE VIEW emp_vu AS SELECT * FROM employees WHERE department_id IN (10,20) WITH READ ONLY;
• C、CREATE VIEW emp_vu AS SELECT * FROM employees WHERE department_id IN (10,20) WITH CHECK OPTION;
• D、CREATE FORCE VIEW emp_vu AS SELECT * FROM employees WHERE department_id IN (10,20);
• E、CREATE FORCE VIEW emp_vu AS SELECT * FROM employees WHERE department_id IN (10,20) NO UPDATE;

第4题：

You created a tabular report for human resources department. After viewing layout users have requested that you change the label of the dept column to something more meaningful. How would you change the label in the live previewer?（）

• A、Use the report wizard to change the column label. 
• B、Click and high light the column label and replace it with desired text. 
• C、Click the column label and alter its property palette. 
• D、Click the dept column and alter its property palette. 

第5题：

You are the administrator of a Windows 2000 network. You need to store secured files for your company’s Accounting and Legal departments on a Windows 2000 Professional computer. You want to accomplish the following goals：  • Enable users in both departments to access their own files from the network  • Enable users in the Accounting department to view the Legal department’s documents  • Prevent users in the Legal department from being able to view the Accounting department’s    documents  • Enable managers within the company to access and modify both the Accounting and the Legal   department’s files You take the following actions：   • Create two shared folders named Accounting and Legal  • Create three groups named Accounting， Legal， and Management  • Allow the Accounting group Modify permission on the Accounting folder  • Allow the Accounting group Read permissions on the Legal folders.  • Allow the Management group Modify permission on both the Accounting and Legal folders.   Which result or results do these actions produce？（）

• A、Users in both departments can access to their own files from the network.
• B、Users in the Accounting department can view the Legal department’s documents.
• C、Users in the Legal department cannot view the Accounting department’s documents.
• D、Company managers can access and modify both departments’ files.

第6题：

第7题：

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

You are responsible for maintaining a SQL Server 2005 database. Business analysts in the company routinely use a view named v CustomerSales to join the Customers and Sales tables in the database. They use the view to aggregate total sales by customer by month. You need to increase the performance of the view. What should you do？（）

• A、Update the view to use an outer join between the Customers and Sales tables.
• B、Create a clustered index on the v CustomerSales view.
• C、Create two separate views that do not contain any joinsone view named Customers for the Customers table and another one named v Sales for the Sales table.
• D、Create a stored procedure for the business analysts that uses the v CustomerSales view.

第14题：

Which command would you configure globally on a Cisco router that would allow you to view directly connected Cisco devices?（）

• A、enable cdp
• B、cdp enable
• C、cdp run
• D、run cdp

第15题：

You are developing an inventory report to list the item number, description price and picture of all inventory items. The layout of each item is a repeating frame that contains three fixed fields and a image. When possible you want all objects in the repeating frame to appear on the same logical page without creating blank pages between instances. Which pagination property would you alter to achieve these results?（）

• A、Page break before. 
• B、Page break after. 
• C、Page protect. 
• D、Keep with anchoring object.

第16题：

You need to provide ad hoc reporting capabilities to fulfill business requirements. What should you do?（）

• A、Create a SQL Server Reporting Services （SSRS） report. Enable customers to modify the report by using Report Builder.
• B、Create an ASP.NET application that will enable customers to view and modify reports by calling the SQL Server Reporting Services （SSRS） API.
• C、Create an ASP.NET application that will enable customers to view and modify reports by using a SQL Server Reporting Services （SSRS） ActiveX control.
• D、Create a SQL Server Reporting Services （SSRS） Report Model. Enable customers to modify reports based on the model by using Report Builder.

第17题：

You are developing a Windows Presentation Foundation (WPF) application. You need to use XAML to create a custom control that contains two Button controls. From which base class should you inherit? （）

• A、 FrameworkElement
• B、 UIElement
• C、 UserControl
• D、 Button

第18题：

第19题：

第20题：

第21题：

第22题：

第23题：

第24题：