单选题Which report style would you use to create a report listing each department and including a listing of employees beneath their respective department?（）A Group left. B Form like. C Matrix W/group. D Group above. E Mailing label. F Form letter.

第1题：

You need to design an access control strategy that meets business and security requirements. Your solution must minimize forestwide replication. What should you do？（）

• A、Create a global group for each department and a global group for each location. Add users to their respective departmental groups as members. Place the departmental global groups within the location global groups. Assign the location global groups to file and printer resources in their respective domains， and then assign permissions for the file and printer resources by using the location global groups
• B、Create a global group for each department， and add the respective users as members. Create domain local groups for file and printer resources. Add the global groups to the respective domain local groups. Then， assign permissions to the file and printer resources by using the domain local groups
• C、Create a local group on each server and add the authorized users as members. Assign appropriate permissions for the file and printer resources to the local groups
• D、Create a universal group for each location， and add the respective users as members. Assign the universal groups to file and printer resources. Then， assign permissions by using the universal groups

第2题：

Click the Exhibit button and examine the data in the EMPLOYEES table. Which three subqueries work?（）

• A、SELECT * FROM employees where salary > (SELECT MIN(salary) FROM employees GROUP BY department_id);
• B、SELECT * FROM employees WHERE salary = (SELECT AVG(salary) FROM employees GROUP BY department_id);
• C、SELECT distinct department_id FROM employees WHERE salary > ANY (SELECT AVG(salary) FROM employees GROUP BY department_id);
• D、SELECT department_id FROM employees WHERE salary > ALL (SELECT AVG(salary) FROM employees GROUP BY department_id);
• E、SELECT last_name FROM employees WHERE salary > ANY (SELECT MAX(salary) FROM employees GROUP BY department_id);
• F、SELECT department_id FROM employees WHERE salary > ALL (SELECT AVG(salary) FROM employees GROUP BY AVG(SALARY));

第3题：

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.

第4题：

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.

第5题：

You are creating a new form for the Order Entry application. You define a record group that will be created when the form is executing this built in: CREATE_GROUP(rg_emplist, global_scope) Which form(s) in the application will have access to this record group?（）

• A、All forms in the application. 
• B、Any forms opened by the user who initiated the record group. 
• C、Only the form issuing the CREATE_GROUP built-in. 
• D、Any forms referenced by the form that contains the procedure.

第6题：

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.

第7题：

Your network consists of a single Active Directory domain. User accounts for engineering  department are located in an OU named Engineering.     You need to create a password policy for the engineering department that is different from your  domain password policy.     What should you do（）

• A、Create a new GPO. Link the GPO to the Engineering OU.
• B、Create a new GPO. Link the GPO to the domain. Block policy inheritance on all OUs except for the Engineering OU
• C、Create a global security group and add all the user accounts for the engineering department to the group. Create a
• D、Create a domain local security group and add all the user accounts for the engineering department to the group. Fr

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

Your network consists of a single Active Directory domain. User accounts for engineering department  are located in an OU named Engineering.    You need to create a password policy for the engineering department that is different from your domain  password policy.    What should you do（）

• A、Create a new GPO. Link the GPO to the Engineering OU.
• B、Create a new GPO. Link the GPO to the domain. Block policy inheritance on all OUs except for the  Engineering OU.
• C、Create a global security group and add all the user accounts for the engineering department to the  group. Create a new Password Policy Object （PSO） and apply it to the group.
• D、Create a domain local security group and add all the user accounts for the engineering department to  the group. From the Active Directory Users and Computer console， select the group and run the  Delegation of Control Wizard.

第14题：

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.

第15题：

The transportation department requested a shipping cost report to list the resources used by each department. A separate page should be product for each department. Which property would you modify to achieve these results?（）

• A、Minimum widow records. 
• B、Column mode. 
• C、Spacing 
• D、Print direction. 
• E、Source F maximum records per page. 
• F、Maximum records per page.

第16题：

Examine the data in the EMPLOYEES table: LAST_NAME DEPARTMENT_ID SALARY Getz 10 3000 Davis 20 1500 Bill 20 2200 Davis 30 5000 ... Which three subqueries work? （）

• A、SELECT * FROM employees where salary > (SELECT MIN(salary) FROM employees GROUP BY department _ id);
• B、SELECT * FROM employees WHERE salary = (SELECT AVG(salary) FROM employees GROUP BY department _ id);
• C、SELECT distinct department_id FROM employees Where salary > ANY (SELECT AVG(salary) FROM employees GROUP BY department _ id);
• D、SELECT department_id FROM employees WHERE SALARY > ALL (SELECT AVG(salary) FROM employees GROUP BY department _ id);
• E、SELECT last_name FROM employees Where salary > ANY (SELECT MAX(salary) FROM employees GROUP BY department _ id);
• F、SELECT department_id FROM employees WHERE salary > ALL (SELECT AVG(salary) FROM employees GROUP BY ANG (SALARY));

第17题：

You want to provide a tool that allows users quick access to form modules, by listing them in an Explorer-style interface. Which reusable component do you use?（）

• A、ActiveX controls 
• B、Calendar Class 
• C、Standard Object Library 
• D、Picklist Class 
• E、Wizard Class 
• F、Navigator Class

第18题：

Which report style would you use to create a report listing each department and including a listing of employees beneath their respective department?（）

• A、Group left. 
• B、Form like. 
• C、Matrix W/group. 
• D、Group above. 
• E、Mailing label. 
• F、Form letter.

第19题：

You work as the enterprise exchange administrator at TestKing.com. TestKing.com makes use of Microsoft Exchange Server messaging solution. The TestKing.com network consists of a single ActiveDirectory domain named testking.com. TestKing.com is configured to run an exchange 2010 environment.TestKing.com consists of different departments， where the Active Directory user objects of every department resides in a separate organizational unit （OU）. All TestKing.com employees are a menber of aseparate Exchange distribution group for their respective department.During the course of the day youreceive an instruction from the CIO to assign administrative rights to the managers in the various departments. You need to ensure that the managers are not permitted to chare the mail flow settings or e-mail address of a group. However， they should be permitted to alter the distribution group membership ofthe department in their department. What should you do？（）

• A、The best option is to assign the MyDistributionGroupMemberShip management role for each department manager.
• B、The best option is to change der Managed By settings for each department distribution group.
• C、The best option is to assign the department manager the Charge permissions for each department manager.
• D、The best option is to change the message moderation settings for each department distribution group.

第20题：

第21题：

第22题：

第23题：