网友您好, 请在下方输入框内输入要搜索的题目:

题目内容 (请给出正确答案)
单选题
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.


参考答案

参考解析
解析: 暂无解析
更多 “单选题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.” 相关考题
考题 You are the desktop administrator for Ezonexam, Inc. The company's network contains an intranet Web farm, which consists of three Web servers. The Web servers are named Ezonexam1, Ezonexam2, and Ezonexam3. Users access the Web farm by using the URL http://team.Ezonexam.com. The relevant portion of the network is configured as shown in the exhibit.Jack is a user in the company operations department. Jack uses Internet Explorer on this Windows 2000 Professional computer to access files that are located on the Web farm. Jack reports that when he attempts to access a file named Schedule.xls by using the URL http://team.Ezonexam.com/ops/schedule.xls, Internet Explorer displays the following error message: "DNS error or server not found".The network administrator informs you that the company DNS server is unavailable. However, Jack needs to access the Schedule.xls file immediately. You need to ensure that King can access the file by using Internet Explorer on his computer.Which URL should you instruct King to use?A.http://Ezonexam1/ops/schedule.xlsB.file://Ezonexam1/ops/schedule.xlsC.http://team.Ezonexam.com/ops$/schedule.xlsD.file://team.Ezonexam.com/ops/schedule.xls

考题 You are the administrator of a SQL Server 2000 computer. Your company purchased an accounting application from a vendor. The application stores its data in a database named Accounting on the server. The tables in this database contain columns that function as primary keys, but PRIMARY KEY and FOREIGN KEY constraints are not used.You need to replicate data from this database to another SQL Server computer. This server will use the replicated data to generate reports. Most reports will run each month, but the accounting department needs to have the ability to run reports at any time. Reports should be accurate through the last full working day.You cannot make any changes to the database, but you need to implement replication. Which two actions should you take? (Each correct answer presents part of the solution. Choose two)A.Implement merge replication.B.Implement snapshot replication.C.Implement transactional replication.D.Schedule replication to run continuously.E.Schedule replication to run during off-peak hours.

考题 You are the network administrator for All network servers run Windows Server 2003.A member server named TESTKING1 hosts several hundred folders, which residein various locations on the server. TESTKING1 is configured to run a normalbackup of the folder every Saturday at 1:00 A.M.You discover that users edit the contents of the folders on Saturday and Sunday.You need to use the Backup utility to reschedule the backup job so that it runs everyMonday at 1:00 A.M. instead of every Saturday at 1:00 A.M. You must achieve thisgoal by using the minimum amount of administrative effort.What should you do?()A. Specify Monday as the start date of the job.B. Reconfigure the job schedule to run the backup every Monday at 1:00 a.m.C. Add an additional schedule to the job. Configure the additional schedule to run the backup on Monday at 1:00 a.m.D. Use the Repeat Task option to configure the existing job to repeat every 48 hours until an interval of 336 hours passes.

考题 You are the network administrator for All servers run Windows Server 2003. You are creating a backup schedule for the main file server. You need to create a schedule so that backup jobs are completed in the shortest amount of time possible. What should you do?()A、Schedule a normal backup every Sunday. Schedule incremental backups every Monday through Saturday.B、Schedule a normal backup every Sunday. Schedule differential backups every Monday through Saturday.C、Schedule a copy backup every day.D、Schedule a normal backup every day.

考题 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.

考题 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 TableB、 Flashback QueryC、Flashback Version QueryD、 Flashback Transaction Query

考题 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.

考题 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.

考题 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

考题 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).

考题 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.

考题 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.

考题 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 accountB、Log on by using the local Administrator account. Then schedule the task to run under User1C、Take the ownership of Addusers.cmd file. Then schedule the task to run under User1D、Grant User1 Read  Execute permission for AddUsers.cmd. Then schedule the task to run  under User1.

考题 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.

考题 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.

考题 单选题Your business has departmental reports that are generated every day. Each department must use the same set of queries, but accesses 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 variablesB by creating a program using DBMS_JOB that accepts one or more variables, and creating a job that calls this program using DBMS_JOBC by having each user schedule a job using DBMS_JOB that accepts one or more input variables and calls a procedure that generates the reportD by having each user create a job using DBMS_SCHEDULER that includes all the information and commands necessary to generate the reportE by creating a program using DBMS_SCHEDULER that accepts one or more variables, and creating a job that calls this program using DBMS_SCHEDULER

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

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

考题 单选题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 TableB  Flashback QueryC Flashback Version QueryD  Flashback Transaction Query

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

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

考题 单选题You are the network administrator for All servers run Windows Server 2003. You are creating a backup schedule for the main file server. You need to create a schedule so that backup jobs are completed in the shortest amount of time possible. What should you do?()A Schedule a normal backup every Sunday. Schedule incremental backups every Monday through Saturday.B Schedule a normal backup every Sunday. Schedule differential backups every Monday through Saturday.C Schedule a copy backup every day.D Schedule a normal backup every day.

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

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

考题 单选题You are the network administrator for All network servers run Windows Server 2003. A member server named TESTKING1 hosts several hundred folders, which reside in various locations on the server. TESTKING1 is configured to run a normal backup of the folder every Saturday at 1:00 A.M. You discover that users edit the contents of the folders on Saturday and Sunday. You need to use the Backup utility to reschedule the backup job so that it runs every Monday at 1:00 A.M. instead of every Saturday at 1:00 A.M. You must achieve this goal by using the minimum amount of administrative effort. What should you do?()A Specify Monday as the start date of the job.B Reconfigure the job schedule to run the backup every Monday at 1:00 a.m.C Add an additional schedule to the job. Configure the additional schedule to run the backup on Monday at 1:00 a.m.D Use the Repeat Task option to configure the existing job to repeat every 48 hours until an interval of 336 hours passes.

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

考题 多选题Identify four uses of the Oracle Scheduler.()Aenables Oracle database to schedule which processes execute on which processors in a multiple CPU environmentBenables Oracle database to do patches according to a DBA-defined scheduleCenables you to schedule the execution of jobs based on timeDenables you to execute jobs in a clustered environmentEenables you to periodically execute operating systemscript files located on the same server as the databaseFenables you to create a job that makes use of saved programs and schedulesGenables you to automate the management of the jobs that are created using the DBMS_JOB package