单选题You create a salary report to display employee salaries grouped by the dept column. You need to change the break order from ascending to descending using the model. How would you reverse the display order of the department? （）A Double click the dept co

题目
单选题
You create a salary report to display employee salaries grouped by the dept column. You need to change the break order from ascending to descending using the model. How would you reverse the display order of the department? （）
A

Double click the dept column in the group to alter the property palette and change the break out order value. 

B

Double click the dept column in the group to open the property palette and change the set break order value. 

C

Double click the g_dept group object to change the break order. 

D

Click the dept column in the group to change the break order.

相似考题

1.You are writing an application that uses SOAP to exchange data with other applications.You use a Department class that inherits from ArrayList to send objects to another application.The Department object is named dept.You need to ensure that the application serializes the Department object for transport by using SOAP.Which code should you use?（）A.B.C.D.

2.Which clause would you use in a SELECT statement to limit the display to those employees whose salary is greater then 5000? ()A. ORDER BY SALARY > 5000B. GROUP BY SALARY > 5000C. HAVING SALARY > 5000D. WHERE SALARY > 5000

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

4.Exhibit: You are developing a Web application. The Web application uses a GridView control to display data. You build your Web Forms for the Web application by dragging and dropping tables from the Data Connections tree in Server Explorer. You need to add a connection to your data by using the Add Connection dialog box as shown in the exhibit. During the process, you need to configure the .NET Data Provider that you use to create the data source objects. What should you do?（）A. Right-click the connection, and click Properties. Modify the Provider property of the data connection.B. Click the Change button, and change the data provider for the selected data source.C. Click the Advanced button, and change the Data Source property to the target provider.D. Click the Advanced button, and change the Application Name property to the target provider.

更多“单选题You create a salary report to display employee salaries grouped by the dept column. You need to change the break order from ascending to descending using the model. How would you reverse the display order of the department? （）A Double click the dept co”相关问题

  • 第1题：

    In the data model you created this query: SELECT ID_no, description, price, quantity, manufacturer_ID FROM inventory Next you click and drag the manufacturer_ID column out of and above the default group. You needed to sort the child group by ID_number. How could you accomplish this task? （）

    • A、Add an order by clause to the query. 
    • B、In the data model double click the ID_number column and alter the break order. 
    • C、In the layout model double click the ID_number filed and later the print direction. 
    • D、Default the layout, choose a master/detail report style and select ID_number as the break order.

    正确答案:A

  • 第2题：

    On Monday， you dropped the DEPT table from your schema and then you re-created the DEPT table in your schema. On Wednesday， you have a requirement to restore the DEPT table from the recycle bin. Which statement is correct？（）

    • A、 You cannot restore the DEPT table by using the Oracle Flashback Drop feature because a table with the name DEPT already exists in your schema.
    • B、 You can restore the DEPT table by using the Oracle Flashback Drop feature， provided you use the RENAME TO clause.
    • C、 You cannot restore the DEPT table by using the Oracle Flashback Drop feature because the contents of the recycle bin are purged every 12 hours by default.
    • D、 You can restore the DEPT table by using the Oracle Flashback Drop feature and a system-generated name will be assigned to the restored table.

    正确答案:B

  • 第3题：

    You created a view called EMP_DEPT_VU that contains three columns from the EMPLOYEES and DEPARTMENTS tables: EMPLOYEE_ID, EMPLOYEE_NAME AND DEPARTMENT_NAME. The DEPARTMENT_ID column of the EMPLOYEES table is the foreign key to the primary key DEPARTMENT_ID column of the DEPARTMENTS table. You want to modify the view by adding a fourth column, MANAGER_ID of NUMBER data type from the EMPLOYEES tables. How can you accomplish this task?（）

    • A、ALTER VIEW EMP_dept_vu (ADD manger_id NUMBER);
    • B、MODIFY VIEW EMP_dept_vu (ADD manger_id NUMBER);
    • C、ALTER VIEW emp_dept_vu AS SELECT employee_id, employee_name, department_name, manager_id FROM employee e, departments d WHERE e.department _ id = d.department_id;
    • D、MODIFY VIEW emp_dept_vu AS SELECT employee_id, employee_name, department_name, manager_id FROM employees e, departments d WHERE e.department _ id = d.department_id;
    • E、CREATE OR REPLACE VIEW emp_dept_vu AS SELECT employee_id, employee_name, department_name, manager_id FROM employees e, departments d WHERE e.department _ id = d.department_id;
    • F、You must remove the existing view first, and then run the CREATE VIEW command with a new column list to modify a view.

    正确答案:E

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

    正确答案:B

  • 第5题：

    You are managing a database for which incremental backups can be very time consuming. In order to perform optimized incremental backups you enable the block change tracking feature.How would you instruct RMAN to use the block change tracking feature when performing incremental backups？（）

    • A、 You need to mention it with every BACKUP command.
    • B、 The block change tracking feature is used automatically by RMAN.
    • C、 You need to configure it using the CONFIGURE command.
    • D、 You need to set the necessary initialization parameters to direct RMAN to use the feature.

    正确答案:B

  • 第6题：

    You work as an application developer at Certkiller .com. You have been given the responsibility of creating a class named CalcSalary that will determine the salaries of Certkiller .com’s staff. The CalcSalary class includes methods to increment and decrement staff salaries. The following code is included in the CalcSalary class： public class CalcSalary { // for promotions public static bool IncrementSalary （Employee Emp， double Amount） { if （Emp.Status == QuarterlyReview.AboveGoals） Emp.Salary += Amount； return true； } else return false； } //for demotions public static bool DecrementSalary （Employee Emp， double Amount） { if （Emp.Status == QuarterlyReview.AboveGoals） Emp.Salary -= Amount； return true； } else return false； } } You would like to invoke the IncrementSalary and DecrementSalary methods dynamically at runtime from the sales manager application， and decide to create a delegate named SalaryDelegate to invoke them. You need to ensure that you use the appropriate code to declare the SalaryDelegate delegate.What is the correct line of code？（）

    • A、 public delegate bool Salary （Employee Emp， double Amount）；
    • B、 public bool Salary （Employee Emp， double Amount）；
    • C、 public event bool Salary （Employee Emp， double Amount）；
    • D、 public delegate void Salary （Employee Emp， double Amount）；

    正确答案:A

  • 第7题：

    单选题
    You created a tabular report for the sales department to display each customer and the sales person assign to the customer. The data is sorted by customer using the order by clause in this query. This is department manager asks you to alter the report so that data is sorted by sales person rather than by customer. What is the best way to make the needed change?（）
    A

    Recreate the query and default the layout. 

    B

    Alter the query, default the layout and redo the boiler plates. 

    C

    Query and manually change the layout to save the boiler plate. 

    D

    Alter the query and make no further change.


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

  • 第8题：

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


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

  • 第9题：

    单选题
    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
    解析： 暂无解析

  • 第10题：

    单选题
    On Monday， you dropped the DEPT table from your schema and then you re-created the DEPT table in your schema. On Wednesday， you have a requirement to restore the DEPT table from the recycle bin. Which statement is correct？（）
    A

     You cannot restore the DEPT table by using the Oracle Flashback Drop feature because a table with the name DEPT already exists in your schema.

    B

     You can restore the DEPT table by using the Oracle Flashback Drop feature， provided you use the RENAME TO clause.

    C

     You cannot restore the DEPT table by using the Oracle Flashback Drop feature because the contents of the recycle bin are purged every 12 hours by default.

    D

     You can restore the DEPT table by using the Oracle Flashback Drop feature and a system-generated name will be assigned to the restored table.


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

  • 第11题：

    单选题
    You work as an application developer at Certkiller .com. You have been given the responsibility of creating a class named CalcSalary that will determine the salaries of Certkiller .com’s staff. The CalcSalary class includes methods to increment and decrement staff salaries. The following code is included in the CalcSalary class： public class CalcSalary { // for promotions public static bool IncrementSalary （Employee Emp， double Amount） { if （Emp.Status == QuarterlyReview.AboveGoals） Emp.Salary += Amount； return true； } else return false； } //for demotions public static bool DecrementSalary （Employee Emp， double Amount） { if （Emp.Status == QuarterlyReview.AboveGoals） Emp.Salary -= Amount； return true； } else return false； } } You would like to invoke the IncrementSalary and DecrementSalary methods dynamically at runtime from the sales manager application， and decide to create a delegate named SalaryDelegate to invoke them. You need to ensure that you use the appropriate code to declare the SalaryDelegate delegate.What is the correct line of code？（）
    A

     public delegate bool Salary （Employee Emp， double Amount）；

    B

     public bool Salary （Employee Emp， double Amount）；

    C

     public event bool Salary （Employee Emp， double Amount）；

    D

     public delegate void Salary （Employee Emp， double Amount）；


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

  • 第12题：

    单选题
    You work as an application developer at Certkiller .com. You have been given the responsibility of creating a class named CalcSalary that will determine the salaries of Certkiller .com’s staff.The CalcSalary class includes methods to increment and decrement staff salaries.You would like to invoke the IncrementSalary and  DecrementSalary methods dynamically at runtime from the sales manager application when needed. After viewing the information displayed in the exhibit， you decide to use the Salary delegate to invoke these methods.  using System；  public delegate boolSalary （Employee Emp， double Amount）； public class CalcSalary {  // for promotions  public static bool IncrementSalary （Employee Emp， double Amount） {  // implementation details }  // for demotions  public static bool DecrementSalary （Employee Emp， double Amount） {  // implementation details }  What code should you use？（）
    A

    A

    B

    B

    C

    C

    D

    D


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

  • 第13题：

     You create a salary report to display employee salaries grouped by the dept column. You need to change the break order from ascending to descending using the model. How would you reverse the display order of the department? （）

    • A、Double click the dept column in the group to alter the property palette and change the break out order value. 
    • B、Double click the dept column in the group to open the property palette and change the set break order value. 
    • C、Double click the g_dept group object to change the break order. 
    • D、Click the dept column in the group to change the break order.

    正确答案:A

  • 第14题：

    Which clause would you use in a SELECT statement to limit the display to those employees whose salary is greater then 5000?（）

    • A、ORDER BY SALARY > 5000
    • B、GROUP BY SALARY > 5000
    • C、HAVING SALARY > 5000
    • D、WHERE SALARY > 5000

    正确答案:D

  • 第15题：

    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

  • 第16题：

    The order entry department requested a report to display the average time to enter an order from each order entry clerk sorted by supervisor with a group average after viewing the report users requested to bold the value for each supervisors group average. Where would you make this change?（）

    • A、In the template used. 
    • B、In the data model. 
    • C、In the life previewer. 
    • D、In the field property palette.

    正确答案:C

  • 第17题：

    You created a view called EMP_DEPT_VU that contains three columns from the EMPLOYEES and DEPARTMENTS tables: EMPLOYEE_ID, EMPLOYEE_NAME AND DEPARTMENT_NAME. The DEPARTMENT_ID column of the EMPLOYEES table is the foreign key to the primary key DEPARTMENT_ID column of the DEPARTMENTS table. You want to modify the view by adding a fourth column, MANAGER_ID of NUMBER data type from the EMPLOYEES tables. How can you accomplish this task? （）

    • A、ALTER VIEW EMP_dept_vu (ADD manger_id NUMBER);
    • B、MODIFY VIEW EMP_dept_vu (ADD manger_id NUMBER);
    • C、ALTER VIEW emp_dept_vu AS SELECT employee_id, employee_name, department_name, manager_id FROM employee e, departments d WHERE e.department _ id = d.department_id;
    • D、MODIFY VIEW emp_dept_vu AS SELECT employee_id, employee_name, department_name, manager_id FROM employees e, departments d WHERE e.department _ id = d.department_id;
    • E、CREATE OR REPLACE VIEW emp_dept_vu AS SELECT employee_id, employee_name, department_name, manager_id FROM employees e, departments d WHERE e.department _ id = d.department_id;
    • F、You must remove the existing view first, and then run the CREATE VIEW command with a new column list to modify a view.

    正确答案:E

  • 第18题：

    单选题
    You created a view called EMP_DEPT_VU that contains three columns from the EMPLOYEES and DEPARTMENTS tables: EMPLOYEE_ID, EMPLOYEE_NAME AND DEPARTMENT_NAME. The DEPARTMENT_ID column of the EMPLOYEES table is the foreign key to the primary key DEPARTMENT_ID column of the DEPARTMENTS table. You want to modify the view by adding a fourth column, MANAGER_ID of NUMBER data type from the EMPLOYEES tables. How can you accomplish this task?（）
    A

    ALTER VIEW emp_dept_vu (ADD manager_id NUMBER);

    B

    MODIFY VIEW emp_dept_vu (ADD manager_id NUMBER);

    C

    ALTER VIEW emp_dept_vu AS   SELECT employee_id, employee_name,   department_name, manager_id   FROM employee e, departments d   WHERE e.department_id = d.department_id;

    D

    MODIFY VIEW emp_dept_vu AS   SELECT employee_id, employee_name,   department_name, manager_id   FROM employees e, departments d   WHERE e.department_id = d.department_id;

    E

    CREATE OR REPLACE VIEW emp_dept_vu AS   SELECT employee_id, employee_name,   department_name, manager_id   FROM employees e, departments d   WHERE e.department_id = d.department_id;

    F

    You must remove the existing view first, and then run the CREATE VIEW command   with a new column list to modify a view.


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

  • 第19题：

    单选题
    You are managing a database for which incremental backups can be very time consuming. In order to perform optimized incremental backups you enable the block change tracking feature.How would you instruct RMAN to use the block change tracking feature when performing incremental backups？（）
    A

     You need to mention it with every BACKUP command.

    B

     The block change tracking feature is used automatically by RMAN.

    C

     You need to configure it using the CONFIGURE command.

    D

     You need to set the necessary initialization parameters to direct RMAN to use the feature.


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

  • 第20题：

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


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

  • 第21题：

    单选题
    In the data model you created this query: SELECT ID_no, description, price, quantity, manufacturer_ID FROM inventory Next you click and drag the manufacturer_ID column out of and above the default group. You needed to sort the child group by ID_number. How could you accomplish this task? （）
    A

    Add an order by clause to the query. 

    B

    In the data model double click the ID_number column and alter the break order. 

    C

    In the layout model double click the ID_number filed and later the print direction. 

    D

    Default the layout, choose a master/detail report style and select ID_number as the break order.


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

  • 第22题：

    单选题
    You created a view called EMP_DEPT_VU that contains three columns from the EMPLOYEES and DEPARTMENTS tables: EMPLOYEE_ID, EMPLOYEE_NAME AND DEPARTMENT_NAME. The DEPARTMENT_ID column of the EMPLOYEES table is the foreign key to the primary key DEPARTMENT_ID column of the DEPARTMENTS table. You want to modify the view by adding a fourth column, MANAGER_ID of NUMBER data type from the EMPLOYEES tables. How can you accomplish this task? （）
    A

    ALTER VIEW EMP_dept_vu (ADD manger_id NUMBER);

    B

    MODIFY VIEW EMP_dept_vu (ADD manger_id NUMBER);

    C

    ALTER VIEW emp_dept_vu AS SELECT employee_id, employee_name, department_name, manager_id FROM employee e, departments d WHERE e.department _ id = d.department_id;

    D

    MODIFY VIEW emp_dept_vu AS SELECT employee_id, employee_name, department_name, manager_id FROM employees e, departments d WHERE e.department _ id = d.department_id;

    E

    CREATE OR REPLACE VIEW emp_dept_vu AS SELECT employee_id, employee_name, department_name, manager_id FROM employees e, departments d WHERE e.department _ id = d.department_id;

    F

    You must remove the existing view first, and then run the CREATE VIEW command with a new column list to modify a view.


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

  • 第23题：

    单选题
    The order entry department requested a report to display the average time to enter an order from each order entry clerk sorted by supervisor with a group average after viewing the report users requested to bold the value for each supervisors group average. Where would you make this change?（）
    A

    In the template used. 

    B

    In the data model. 

    C

    In the life previewer. 

    D

    In the field property palette.


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

相关内容