网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
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.
参考答案
参考解析
解析：
暂无解析
更多 “单选题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.” 相关考题
考题
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
考题
Examine the structures of the EMPLOYEES and TAX tables.EMPLOYEESEMPLOYEE_ID NUMBER NOT NULL, PrimaryKeyEMP_NAME VARCHAR2 (30)JOB_ID VARCHAR2 (20)SALARY NUMBERReferencesMGR_ID NUMBEREMPLOYEE_IDcolumnDEPARTMENT_ID NUMBER Foreign key toDEPARTMENT _IDcolumn of theDEPARTMENT tableTAXMIN_SALARY NUMBERMAX_SALARY NUMBERTAX_PERCENT NUMBERPercentage tax for givensalary rangeYou need to find the percentage tax applicable for each employee. Which SQL statement would you use?（）A. SELECT employee_id, salary, tax_percent FROM employees e, tax t WHERE e.salary BETWEEN t.min _ salary AND t.max_salaryB. SELECT employee_id, salary, tax_percent FROM employees e, tax t WHERE e.salary t.min_salary, tax_percentC. SELECT employee_id, salary, tax_percent FROM employees e, tax t WHERE MIN(e.salary) = t.min_salary AND MAX(e.salary) = t.max_salaryD. You cannot find the information because there is no common column between the two tables.
考题
Evaluate the SQL statement:What is the result of the statement?()
A. The statement produces an error at line 1.B. The statement produces an error at line 3.C. The statement produces an error at line 6.D. The statement returns the employee name, salary, department ID, and maximum salary earned in the department of the employee for all departments that pay less salary then the maximum salary paid in the company.E. The statement returns the employee name, salary, department ID, and maximum salary earned in the department of the employee for all employees who earn less than the maximum salary in their department.
考题
在Oracle中,你需要创建索引提高薪水审查的性能,该审查要对员工薪水提高12个百分点后进行分析处理,下面哪个createindex命令能解决此问题()。
A.CREATE INDEX my_idx_1 ON employee（salary*1.12）B.CREATE UNIQUE INDEX my_idx_1 ON employee（salary）C.CREATE BITMAP INDEX my_idx_1 ON employee（salary）D.CREATE INDEX my_idx_1 ON employee（salary）REVERSE
考题
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.
考题
在Oracle中，你需要创建索引提高薪水审查的性能，该审查要对员工薪水提高12个百分点后进行分析处理，下面哪个createindex命令能解决此问题（）。A、CREATE INDEX my_idx_1 ON employee（salary*1.12）B、CREATE UNIQUE INDEX my_idx_1 ON employee（salary）C、CREATE BITMAP INDEX my_idx_1 ON employee（salary）D、CREATE INDEX my_idx_1 ON employee（salary）REVERSE
考题
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.
考题
You are developing a bonus report for the payroll application to calculate and display the bonus issue to each envelope. Employees with a salary of less than 50000$ earn a bonus of 15% and the employees who earn 50000$ or more earn out 10% bonus. Which type of trigger would you use to conditionally assign a bonus percentage?（）A、Report level trigger. B、Group filter. C、Format trigger. D、None of the above.
考题
The human resources department requested an employee report to high light those employees who are due for 30 days 6 months and 1 year evaluation. The higher_data field should display blue text for 30 days employee, a red text for 6 months employees and a green text for one year employees. You created a format trigger on the higher_data field to handle this task. What will happen if the format trigger returns a false value? （）A、The report execution will be halted. B、The higher_data file will not be displayed. C、The record will not be displayed. D、Nothing will happen.
考题
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 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）；
考题
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.
考题
单选题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.
考题
单选题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.
考题
单选题您在公司的数据库中成功创建了名为SALARY的表。您现在要通过向引用EMPLOYEES表的匹配列的SALARY表添加FOREIGNKEY约束条件来建立EMPLOYEES表与SALARY表之间的父/子关系。尚未向SALARY表添加任何数据。应执行以下哪条语句（）A
ALTER TABLE salary ADD CONSTRAINT fk_employee_id_01 FOREIGN KEY（employee_id）REFERENCES employees（employee_id）B
ALTER TABLE salary ADD CONSTRAINT fk_employee_id_ FOREIGN KEY BETWEEN salary（employee_id）AND employees（employee_id）C
ALTER TABLE salary FOREIGN KEY CONSTRAINT fk_employee_id_REFERENCES employees（employee_id）D
ALTER TABLE salary ADD CONSTRAINT fk_employee_id_FOREIGN KEY salary（employee_id）=employees（employee_id）
考题
单选题Examine the structures of the EMPLOYEES and TAX tables. EMPLOYEES EMPLOYEE_ID NUMBER NOT NULL, Primary Key EMP_NAME VARCHAR2 (30) JOB_ID VARCHAR2 (20) SALARY NUMBER References MGR_ID NUMBER EMPLOYEE_ID column DEPARTMENT_ID NUMBER Foreign key to DEPARTMENT _ID column of the DEPARTMENT table TAX MIN_SALARY NUMBER MAX_SALARY NUMBER TAX_PERCENT NUMBER Percentage tax for given salary range You need to find the percentage tax applicable for each employee. Which SQL statement would you use?（）A
SELECT employee_id, salary, tax_percent FROM employees e, tax t WHERE e.salary BETWEEN t.min _ salary AND t.max_salaryB
SELECT employee_id, salary, tax_percent FROM employees e, tax t WHERE e.salary t.min_salary, tax_percentC
SELECT employee_id, salary, tax_percent FROM employees e, tax t WHERE MIN(e.salary) = t.min_salary AND MAX(e.salary) = t.max_salaryD
You cannot find the information because there is no common column between the two tables.
考题
单选题You are developing a tax report for the payroll application. You created a before parameter form report trigger to create three temporary tables to store text that are need while the report is executed. Which report trigger would you use to delete these temporary tables?（）A
Before parameter form. B
After parameter form. C
Before report. D
After report.
考题
单选题You are developing a bonus report for the payroll application to calculate and display the bonus issue to each envelope. Employees with a salary of less than 50000$ earn a bonus of 15% and the employees who earn 50000$ or more earn out 10% bonus. Which type of trigger would you use to conditionally assign a bonus percentage?（）A
Report level trigger. B
Group filter. C
Format trigger. D
None of the above.
考题
单选题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
考题
单选题The human resources department requested an employee report to high light those employees who are due for 30 days 6 months and 1 year evaluation. The higher_data field should display blue text for 30 days employee, a red text for 6 months employees and a green text for one year employees. You created a format trigger on the higher_data field to handle this task. What will happen if the format trigger returns a false value? （）A
The report execution will be halted. B
The higher_data file will not be displayed. C
The record will not be displayed. D
Nothing will happen.
考题
单选题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.
考题
单选题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 working as a DBA at NetFx Corporation. A user， Scott， is maintaining the records of all the employees in the EMPLOYEEtable. Initially， the salary of the employee， ’E0025’， was $1800. On 1 May 2004， the salary of the employee， ’E0025’， was increased by $200. The user， Scott， issued the following statement to modify the record of the employee， ’E0025’： SQLUPDATE EMPLOYEE SET SALARY = 2000 WHERE EMPNO = ’E0025’； SQLCOMMIT； On December 1， 2004， the salary of the employee， ’E0025’， was increased by $400. The user， Scott， issued the following statement to modify the record of the employee， ’E0025’： SQLUPDATE EMPLOYEE SET SALARY = 2400 WHERE EMPNO = ’E0025’； SQLCOMMIT； On July 1， 2005， the salary of the employee， ’E0025’， was increased by $500. The user， Scott， issued the following statement to modify the record of the employee， ’E0025’ SQLUPDATE EMPLOYEE SET SALARY = 2900 WHERE EMPNO = ’E0025’； SQLCOMMIT； On July 5， 2005， the HR manager asked you to generate the increment report of the employee， ’E0025’， for the period between 1 May 2004 and 1 July 2005. Which flashback feature will you use to generate the increment report？（）A
Flashback DropB
Flashback TableC
Flashback DatabaseD
Flashback Version Query
考题
单选题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.
考题
单选题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.
考题
多选题You need to create a trigger to locate the Product report in the Rpt_Server, run the report, and test the status of the report. Which three built-ins would you use to accomplish this task?（）ARUN_PRODUCTBSET_REPORT_OBJECT_PROPERTYCRUN_REPORT_OBJECTDFIND_REPORT_OBJECTEREPORT_OBJECT_STATUSFCOPY_REPORT_OBJECT_OUTPUT
考题
单选题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
AB
BC
CD
D
热门标签
最新试卷