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

第1题：

You are responsible for maintaining a SQL Server 2005 database. Business analysts in the company routinely use a view named v CustomerSales to join the Customers and Sales tables in the database. They use the view to aggregate total sales by customer by month. You need to increase the performance of the view. What should you do？（）

• A、Update the view to use an outer join between the Customers and Sales tables.
• B、Create a clustered index on the v CustomerSales view.
• C、Create two separate views that do not contain any joinsone view named Customers for the Customers table and another one named v Sales for the Sales table.
• D、Create a stored procedure for the business analysts that uses the v CustomerSales view.

第2题：

Examine the structure if the EMPLOYEES table: Column name Data Type Remarks EMPLOYEE_ID NUMBER NOT NULL, Primary Key EMP_NAME VARCHAR2(30) JOB_ID VARCHAR2(20) NOT NULL SAL NUMBER MGR_ID NUMBER References EMPLOYEE_ID column DEPARTMENT_ID NUMBER Foreign key to DEPARTMENT_ID column of the DEPARTMENTS table You need to create a view called EMP_VU that allows the user to insert rows through the view. Which SQL statement, when used to create the EMP_VU view, allows the user to insert rows? （）

• A、CREATE VIEW emp_Vu AS SELECT employee_id, emp_name, department_id FROM employees WHERE mgr_id IN (102, 120);
• B、CREATE VIEW emp_Vu AS SELECT employee_id, emp_name, job_id department_id FROM employees WHERE mgr_id IN (102, 120);
• C、CREATE VIEW emp_Vu AS SELECT department_id, SUM(sal) TOTALSAL FROM employees WHERE mgr_id IN (102, 120) GROUP BY department_ id;
• D、CREATE VIEW emp_Vu AS SELECT employee_id, emp_name, job_id, DISTINCT department_id FROM employees;

第3题：

You are granted the CREATE VIEW privilege. What does this allow you to do?（）

• A、Create a table view.
• B、Create a view in any schema.
• C、Create a view in your schema.
• D、Create a sequence view in any schema.
• E、Create a view that is accessible by everyone.
• F、Create a view only of it is based on tables that you created.

第4题：

Your company uses SQL Server 2005. You are implementing a series of views that are used in ad hoc queries. The views are used to enforce your companys security policy of abstracting data.  Some of these views perform slowly. You create indexes on those views to increase performance, while still maintaining the companys security policy. One of the views returns the current date as one of the columns. The view returns the current date by using the GETDATE（　） function. This view does not allow you to create an index. You need to create an index on the view.  Which two actions should you perform?（）

• A、 Remove all deterministic function calls from within the view. 
• B、 Remove all nondeterministic function calls from within the view. 
• C、 Schema-bind all functions that are called from within the view. 
• D、 Create the view and specify the WITH CHECK OPTION clause.

第5题：

You need to use the Event Viewer window to review the event logs for only critical and error events. You also need the maximum amount of detail for each of these events. What should you do？ （）

• A、Edit the filter for the Administrative Events view.
• B、Create a custom view. Enable the Critical， Error， and Information level events. Select all logs.
• C、Create a custom view. Select the Critical checkbox， Error checkbox， and Verbose checkbox. Select all logs.
• D、Search for the Critical or Error string by using the Find option of the Administrative Events view.

第6题：

You are creating a view to join the Customers and Orders tables in a SQL Server 2005 database. You need to ensure that the view cannot be affected by modifications to underlying table schemas. You want to accomplish this goal by using the least possible amount of overhead. What should you do?（）

• A、Create CHECK constraints on the tables. 
• B、Create a DDL trigger to roll back any changes to the tables if the changes affect the columns in the view. 
• C、Create the view, specifying the WITH SCHEMABINDING option. 
• D、Create the view, specifying the WITH CHECK option. 

第7题：

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

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;

第14题：

You need to perform certain data manipulation operations through a view called EMP_DEPT_VU, which you previously created.You want to look at the definition of the view (the SELECT statement on which the view was create.) How do you obtain the definition of the view?（）

• A、Use the DESCRIBE command in the EMP_DEPT VU view.
• B、Use the DEFINE VIEW command on the EMP_DEPT VU view.
• C、Use the DESCRIBE VIEW command on the EMP_DEPT VU view.
• D、Query the USER_VIEWS data dictionary view to search for the EMP_DEPT_VU view.
• E、Query the USER_SOURCE data dictionary view to search for the EMP_DEPT_VU view.
• F、Query the USER_OBJECTS data dictionary view to search for the EMP_DEPT_VU view.

第15题：

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;

第16题：

You are implementing an ASP. NET MVC 2 Web application. You add a controller named Company Controller. You need to modify the application to handle the URL path /company/info. Which two actions should you perform？（）

• A、Add the following method to the CompanyController class. Function Info（） As ActionResult   Return View（） End Function
• B、Add the following method to the CompanyController class. Function Company_Info（） As ActionResult  Return View（） End Function
• C、Right-click the Views folder， and select View from the Add submenu to create the view for the action.
• D、Right-click inside the action method in the CompanyController class， and select Add View to create a view for the action

第17题：

TestKing.com uses SQL Server 2005. You are implementing a series of views that are used in ad hoc queries. The views are used to enforce TestKing.coms security policy of abstracting data. Some of these views perform slowly. You create indexes on those views to increase performance， while still maintaining the company’s security policy. One of the views returns the current date as one of the columns. The view returns the current date by using the GETDATE（） function. This view does not allow you to create an index. You need to create an index on the view. Which two actions should you perform？（）

• A、Remove all deterministic function calls from within the view.
• B、Remove all nondeterministic function calls from within the view.
• C、Schema-bind all functions that are called from within the view.
• D、Create the view and specify the WITH CHECK OPTION clause.

第18题：

第19题：

第20题：

第21题：

第22题：

第23题：

第24题：