单选题Using the reports server how would you force the orders report in the orders entry application to run every six hours?（）A Schedule the report's execution in the queue manager. B Schedule the reports execution using the R30RQM command line with schedule

第1题：

Using the reports server how would you force the orders report in the orders entry application to run every six hours?（）

• A、Schedule the report's execution in the queue manager. 
• B、Schedule the reports execution using the R30RQM command line with scheduled parameter. 
• C、Create a trigger in the application to execute the report every six hours. 
• D、You cannot schedule a reports execution.

第2题：

How are messages displayed when you use the SRW.MESSAGE packaged procedure? （）

• A、Dialogue box that implicitly determines report execution. 
• B、Message line that implicitly determines report execution. 
• C、Message line that suppresses the default oracle message. 
• D、Dialogue box that does not terminate report execution. 
• E、Dialogue box that suppresses the default oracle message.

第3题：

Which built-in would you reference in your trigger code to remove a report from the Reports Server queue dynamically?（）

• A、FIND_REPORT_OBJECT 
• B、CANCEL_REPORT_OBJECT 
• C、REPORT_OBJECT_STATUS 
• D、SET_PROPERTY OBJECT_PROPERTY

第4题：

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.

第5题：

You are the administrator of a Windows 2000 network. You use a user account named User1 to log on to a Windows 2000 Professional computer. Different students in a classroom use this Computer. User does not have administrative rights. However， you prefer to use this account for most of your daily activities， because it is not a security breach if you fail to log off. You want to schedule a task to run a command file named AddUsers.cmd that automatically adds six more student user accounts. What should you do？（）

• A、Schedule the task to run under an Administrative account
• B、Log on by using the local Administrator account. Then schedule the task to run under User1
• C、Take the ownership of Addusers.cmd file. Then schedule the task to run under User1
• D、Grant User1 Read & Execute permission for AddUsers.cmd. Then schedule the task to run  under User1.

第6题：

You are a network administrator for ExamSheet.net's Windows 2000 network.  You use a user account named User1 to log on tot a Windows 2000 Professional computer. The computer is used by different students in a classroom. User1 does not have administrative rights. However, you prefer to use this account for your daily activities. Using the Task Scheduler you schedule a task to run a command file named AddUsers.cmd that automatically adds six more student user accounts. You configure the task to run as the administrator account.  After the task was scheduled to have run you open the Task Scheduler and discover a status of "Could not start" for the task. You also discover account logon failure audit events in the computer's Security log.You want the scheduled task to successfully run AddUsers.cmd. You want to accomplish this with the least amount of administrative effort.  What should you do?（）

• A、Schedule the task using theATcommand.
• B、Reenter the password for the administrator account using the Task Scheduler.
• C、Log on with an administrative account and reschedule the task.
• D、Log on by using the local Administrator account. Then schedule the task to run under User1.

第7题：

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

You query the ORDERS table and discover that order number 1101 is missing. One of your reports， generated at 5：00 A.M. on April 23， 2005 using Oracle Reports， includes this order number in the output. You have inserted 100 new orders into the ORDERS table since generating this report. Which flashback technology would you use to recover order number 1101 into the ORDERS table without losing the 100 orders that you added after the report was generated？（）  

• A、 Flashback Table
• B、 Flashback Query
• C、Flashback Version Query
• D、 Flashback Transaction Query

第14题：

Your business has departmental reports that are generated every day. Each department must use the same set of queries， but access a different subset of data in the tables， depending on which department generates the report. The format of the reports is being developed； currently， the format changes daily. How would you configure the database to ensure that each department generates its report （based on its target data） using the most recent report format every day？（）

• A、 By having each user run the report generation procedure at the scheduled time， supplying the necessary input variables.
• B、 By creating a program using DBMS_JOB that accepts one or more variables， and creating a job that calls this program using DBMS_JOB.
• C、 By having each user schedule a job using DBMS_JOB that accepts one or more input variables and calls a procedure that generates the report.
• D、 By having each user create a job using DBMS_SCHEDULER that includes all the information and commands necessary to generate the report.
• E、 By creating a program using DBMS_SCHEDULER that accepts one or more variables， and creating a job that calls this program using DBMS_SCHEDULER.

第15题：

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

第16题：

You design a Business Intelligence （BI） solution by using SQL Server 2008. You create a SQL Server 2008 Reporting Services （SSRS） solution. You create reports by using Microsoft Visual Studio .NET 2008. The development team of your company must create 50 SSRS reports. You need to ensure that the company logo and the company name are included in the page header of all the reports. What should you do？（）

• A、 Create an SSRS report and include the required page header in the report. Use the report as a template for all the reports.
• B、 Create an SSRS report and include the required page header in the report. Create a subreport that refers to the report. Include the subreport to all the reports.
• C、 Create a SSRS report and include the required page header in the report. Copy the report definition to an XML file.Add the XML file as a data source for all the reports.
• D、 Create a SSRS report and include the required page header in the report. Create a class library that includes the report.Add the class library as an assembly reference for all the reports.

第17题：

You need to design the Service Broker queues that will be used to submit requests for long-running reports. Your solution must minimize complexity of using the queues by applications. What should you do?（）

• A、Specify one queue for each client application that can submit report requests.
• B、Specify one queue for each of the two report-generation services.
• C、Specify one queue for all long-running report requests.
• D、Specify eight queues：One for each service， and one for each client application.

第18题：

第19题：

第20题：

第21题：

第22题：

第23题：