[单项选择]You need to create a view EMP_VU. The view should allow the users to manipulate the records of only the employees that are working for departments 10 or 20. Which SQL statement would you use to create the view EMP_VU? （）
A. CREATE VIEW emp_vu AS SELECT * FROM employees WHERE department _ id IN (10,20);
B. CREATE VIEW emp_vu AS SELECT * FROM employees WHERE department_id IN (10,20) WITH READ ONLY;
C. CREATE VIEW emp_vu AS SELECT * FROM employees WHERE department_id IN (10,20) WITH CHECK OPTION;
D. CREATE FORCE VIEW emp_vu AS SELECT * FROM employees WITH department_id IN (10,20);
E. CREATE FORCE VIEW emp_vu AS SELECT * FROM employees WHERE department_id IN (10,20) NO UPDATE;

[单项选择] You need to create a view EMP_VU. The view should allow the users to manipulate the records of only the employees that are working for departments 10 or 20. Which SQL statement would you use to create the view EMP_VU?（）
A. CREATE VIEW emp_vu AS   SELECT *   FROM employees   WHERE department_id IN (10,20);
B. CREATE VIEW emp_vu AS   SELECT *   FROM employees   WHERE department_id IN (10,20)   WITH READ ONLY;
C. CREATE VIEW emp_vu AS   SELECT *   FROM employees   WHERE department_id IN (10,20)   WITH CHECK OPTION;
D. CREATE FORCE VIEW emp_vu AS   SELECT *   FROM employees   WHERE department_id IN (10,20);
E. CREATE FORCE VIEW emp_vu AS   SELECT *   FROM employees   WHERE department_id IN (10,20)   NO UPDATE;

[多项选择]You create a Web application. You need to turn on Tracing for a page that is not performing well. You must store the trace information in a database for reporting and trending. Which two actions should you perform?（）
A. Add a TraceContextEventHandler to the Trace.TraceFinished event to add the trace records into the database.
B. Add a system.diagnostics section to the Web.config file. Then add a listener to the new section.
C. Use the System.Diagnostics.Trace object to connect to a database. Then insert the trace records.
D. In the Page_Load for the page, place the Trace.Write call into a SQL INSERT statement.

[单项选择]What should you do when you need to answer a phone call during a performance
A. Call back after the performance.
B. Answer it near the exit door.
C. Talk outside the exit door.
D. Speak in a low voice.

[多项选择]You create a Web Form. You need to add controls that use adaptive rendering to display content. The type of content rendered must depend on the device that is requesting the page. What are two possible ways to achieve this goal? （）
A. Add custom controls that emit XHTML to the Web Form.
B. Add custom controls that emit WML to the Web Form.
C. Add mobile controls to the Web Form.
D. Add Web server controls to the Web Form.

[多项选择] You create a mobile Web application. You need to use a Command control to post user input from the UI elements back to the server. What are two possible ways to achieve this goal?（）
A. Place the Command control within an instance of the System.Web.UI.MobileControls.SelectionList control.
B. Place the Command control within an instance of the System.Web.UI.MobileControls.ObjectList control.
C. Place the Command control within an instance of the System.Web.UI.MobileControls.Form control.
D. Place the Command control within an instance of the System.Web.UI.MobileControls.Panel control.

[多项选择]When should you create a role?（）
A. To simplify the process of creating new users using the CREATE USER xxx IDENTIFIED by yyy statement.
B. To grant a group of relate privileges to a user.
C. When the number of people using the database is very high.
D. To simplify the process of granting and revoking privileges.
E. To simplify profile maintenance for a user who is constantly traveling.

[单项选择]You create a Web site for a customer. You need to deploy the Web site to the customers server without any of the source files for the Web site. You do not want the customer to be able to update any of the static pages on the Web site. Which tool should you use? （）
A. aspnet_compiler.exe
B. InstallUtil.exe
C. CSC.exe
D. aspnet_wp.exe

[单项选择] You create a Data Collector Set (DCS).You need prevent the DCS from logging data if the server has less than 1 GB of available disk space. What should you do？（）
A. Create a passive file screen.
B. Create an active file screen.
C. Modify the Data Manager settings of the DCS.
D. Modify the Stop Conditions settings of the DCS.