单选题Using the report wizard you create a tabular report to display all the columns in the EMP table. The records are ordered by the deptname and job columns. You need to create a hierarchical report that breaks on the deptname and job values. Using the dat

题目
单选题
Using the report wizard you create a tabular report to display all the columns in the EMP table. The records are ordered by the deptname and job columns. You need to create a hierarchical report that breaks on the deptname and job values. Using the data model how would you create this break structure?（）
A

Specify the break order on the gemp group Property palette. 

B

Specify a break order on the dept_name and job columns property palettes. 

C

Click and drag the dept_name and jobs column out and above of the gemp group to create a new parent group. 

D

Change the position of the dept_name and the job columns within the gemp group.

相似考题

1.You want to schedule a job to rebuild all indexes on the SALES table after the completion of a bulk load operation. The bulk load operation must also be a scheduled job that executes as soon as the first file that contains data arrives on the system.How would you create these jobs?（）A. Create both jobs by using events raised by the schedulerB. Create both jobs by using events raised by the applicationC. Create a job to rebuild indexes by using events arised by the application and then create another job to perform bulk load by using events raised by the schedulerD. Create a job to rebuild indexes by using events arised by the Scheduler and then create another job to perform bulk load by using events raised by the application

2. You want to schedule a job to rebuild all indexes on the SALES table after the completion of a bulk load operation. The bulk load operation must also be a scheduled job that executes as soon as the first file that contains data arrives on the system. How would you create these jobs?（）A、Create both jobs by using events raised by the schedulerB、Create both jobs by using events raised by the applicationC、Create a job to rebuild indexes by using events arised by the application and then create another job to perform bulk load by using events raised by the schedulerD、Create a job to rebuild indexes by using events arised by the Scheduler and then create another job to perform bulk load by using events raised by the application

3.You create a financial report to be represented to board of directors. The accounting manager has asked you to change the number format to show a thousand separator. What is the best method to make this change to the report quickly?（）A、Open the property palette and set the format mask for all the numeric items in the report. B、Select the data to be free formatted in the life previewer and lick on the thousand separator icon on the style bar. C、Go to the layout model and change the field attributes for the data to be changed on the report. D、Rebuild the report using the report wizard setting this format on creation.

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

更多“单选题Using the report wizard you create a tabular report to display all the columns in the EMP table. The records are ordered by the deptname and job columns. You need to create a hierarchical report that breaks on the deptname and job values. Using the dat”相关问题

  • 第1题：

    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

    正确答案:B

  • 第2题：

    Using the report wizard you create a tabular report to display all the columns in the EMP table. The records are ordered by the deptname and job columns. You need to create a hierarchical report that breaks on the deptname and job values. Using the data model how would you create this break structure?（）

    • A、Specify the break order on the gemp group Property palette. 
    • B、Specify a break order on the dept_name and job columns property palettes. 
    • C、Click and drag the dept_name and jobs column out and above of the gemp group to create a new parent group. 
    • D、Change the position of the dept_name and the job columns within the gemp group.

    正确答案:C

  • 第3题：

    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.

    正确答案:E

  • 第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.

    正确答案:D

  • 第5题：

    You have a server that runs Windows Server 2003 Service Pack 2 (SP2). A server application creates report files. The application saves the report files in a folder named Report. A service account is listed as the owner of all report files. You need to assign ownership of the report files to a user in a department named Audit. You must achieve this goal by using the minimum amount of administrative effort. What should you do? （）

    • A、Rewrite the application.
    • B、Create a scheduled task to run Attrib.exe.
    • C、Create a scheduled task to run Icacls.exe.
    • D、Use the Advanced Security settings to change the owner of each file.

    正确答案:C

  • 第6题：

    You design a Business Intelligence （BI） solution by using SQL Server 2008. You create a SQL Server 2008 Reporting Services （SSRS） solution. The solution contains a report named Sales Details that displays sales information of all the employees. You create an SSRS report named Sales Summary that displays the total monthly sales of each employee. Users who view the Sales Summary report occasionally require the monthly sales details for a particular employee. You need to ensure that the users can click a value in the month column of the Sales Summary report to open and render the Sales Details report. What should you do？（）

    • A、 Use a subreport.
    • B、 Use a bookmark link.
    • C、 Use the drilldown functionality.
    • D、 Use a drillthrough report link.

    正确答案:D

  • 第7题：

    单选题
    You create the sales report and run it in the live previewer. After which change would the live previewer require the data? （）
    A

    Removing column from the available list in the report wizard. 

    B

    Removing the column from the displayed list in the report wizard. 

    C

    Changing the display width of a column in the report wizard. 

    D

    Adding a column to both the available list and displayed list in the report wizard. 

    E

    Removing a column in the live previewer. 


    正确答案： E
    解析： 暂无解析

  • 第8题：

    单选题
    You created a report from the human resources department based on all the columns in the EMP table. After viewing the report users requested that the cmp_ID columns peers first in the output. How would you change the position of the column?（）
    A

    After the query. 

    B

    Enter the report and change the column's position in the field tab. 

    C

    Alter the column's position in the object navigator. 

    D

    Enter the report wizard and change the column's position in the data tab. 

    E

    Alter the column's position within its group and change the layout. 


    正确答案： B
    解析： 暂无解析

  • 第9题：

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


    正确答案： B
    解析： 暂无解析

  • 第10题：

    单选题
    You design a Business Intelligence （BI） solution by using SQL Server 2008. You create a SQL Server 2008 Reporting Services （SSRS） solution. The solution contains a report named Sales Details that displays sales information of all the employees. You create an SSRS report named Sales Summary that displays the total monthly sales of each employee. Users who view the Sales Summary report occasionally require the monthly sales details for a particular employee. You need to ensure that the users can click a value in the month column of the Sales Summary report to open and render the Sales Details report. What should you do？（）
    A

     Use a subreport.

    B

     Use a bookmark link.

    C

     Use the drilldown functionality.

    D

     Use a drillthrough report link.


    正确答案： D
    解析： 暂无解析

  • 第11题：

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


    正确答案： A
    解析： 暂无解析

  • 第12题：

    单选题
    You want to schedule a job to rebuild all indexes on the SALES table after the completion of a bulk load operation.  The bulk load operation must also be a scheduled job that executes as soon as the first file that contains data arrives on the system.  How would you create these jobs？（）
    A

     Create both jobs by using events raised by the scheduler

    B

     Create both jobs by using events raised by the application

    C

     Create a job to rebuild indexes by using events arised by the application and then create another job to perform bulk load by using events raised by the scheduler

    D

     Create a job to rebuild indexes by using events arised by the Scheduller and then create another job to perform bulk load by using events raised by the application


    正确答案： A
    解析： 暂无解析

  • 第13题：

    You create a tabular employee report and are concerned about readability because the employee records are very close together. What is the best way to increase the amount of white space between the records?（）

    • A、In the layout model increase the size of the employee record fields. 
    • B、In the report wizard increase the display width values of the employee record fields. 
    • C、In the property palette increase the size of the repeating frame surrounding the employee records. 
    • D、In the life previewer, high light a field, click on the parent frame icon and make the frame bigger verticall.

    正确答案:D

  • 第14题：

    You created a report from the human resources department based on all the columns in the EMP table. After viewing the report users requested that the cmp_ID columns peers first in the output. How would you change the position of the column?（）

    • A、After the query. 
    • B、Enter the report and change the column's position in the field tab. 
    • C、Alter the column's position in the object navigator. 
    • D、Enter the report wizard and change the column's position in the data tab. 
    • E、Alter the column's position within its group and change the layout. 

    正确答案:B

  • 第15题：

    You create the sales report and run it in the live previewer. After which change would the live previewer require the data? （）

    • A、Removing column from the available list in the report wizard. 
    • B、Removing the column from the displayed list in the report wizard. 
    • C、Changing the display width of a column in the report wizard. 
    • D、Adding a column to both the available list and displayed list in the report wizard. 
    • E、Removing a column in the live previewer. 

    正确答案:D

  • 第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.

    正确答案:A

  • 第17题：

    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.

    正确答案:B

  • 第18题：

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


    正确答案： E
    解析： 暂无解析

  • 第19题：

    单选题
    Using the report wizard you create a tabular report to display all the columns in the EMP table. The records are ordered by the deptname and job columns. You need to create a hierarchical report that breaks on the deptname and job values. Using the data model how would you create this break structure?（）
    A

    Specify the break order on the gemp group Property palette. 

    B

    Specify a break order on the dept_name and job columns property palettes. 

    C

    Click and drag the dept_name and jobs column out and above of the gemp group to create a new parent group. 

    D

    Change the position of the dept_name and the job columns within the gemp group.


    正确答案： B
    解析： 暂无解析

  • 第20题：

    单选题
    You create a financial report to be represented to board of directors. The accounting manager has asked you to change the number format to show a thousand separator. What is the best method to make this change to the report quickly?（）
    A

    Open the property palette and set the format mask for all the numeric items in the report. 

    B

    Select the data to be free formatted in the life previewer and lick on the thousand separator icon on the style bar. 

    C

    Go to the layout model and change the field attributes for the data to be changed on the report. 

    D

    Rebuild the report using the report wizard setting this format on creation.


    正确答案： C
    解析： 暂无解析

  • 第21题：

    单选题
    You want to schedule a job to rebuild all indexes on the SALES table after the completion of a bulk load operation. The bulk load operation must also be a scheduled job that executes as soon as the first file that contains data arrives on the system. How would you create these jobs?（）
    A

    Create both jobs by using events raised by the scheduler

    B

    Create both jobs by using events raised by the application

    C

    Create a job to rebuild indexes by using events arised by the application and then create another job to perform bulk load by using events raised by the scheduler

    D

    Create a job to rebuild indexes by using events arised by the Scheduller and then create another job to perform bulk load by using events raised by the application


    正确答案： C
    解析： 暂无解析

  • 第22题：

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


    正确答案： C
    解析： 暂无解析

  • 第23题：

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


    正确答案： E
    解析： 暂无解析

  • 第24题：

    单选题
    You create a tabular employee report and are concerned about readability because the employee records are very close together. What is the best way to increase the amount of white space between the records?（）
    A

    In the layout model increase the size of the employee record fields. 

    B

    In the report wizard increase the display width values of the employee record fields. 

    C

    In the property palette increase the size of the repeating frame surrounding the employee records. 

    D

    In the life previewer, high light a field, click on the parent frame icon and make the frame bigger verticall.


    正确答案： A
    解析： 暂无解析

相关内容