You create a Visual Studio 2010 solution that includes a WCF service project and an ASP.NET project. The service includes a method named GetPeople that takes no arguments and returns an array of Person objects. The ASP.NET application uses a proxy class t

第1题：

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.

第2题：

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.

第3题：

第4题：

You have a Windows Server 2008 R2 Hyper-V server. You need to ensure that you are prompted to specify a custom snapshot name when you create a snapshot. What should you use to create the snapshot？（）

• A、Hyper-V Manager
• B、Windows Server Backup
• C、the Virtual Machine Connection window
• D、the Backup command-line tool （also known as wbadmin.exe）

第5题：

The HR user creates a stand-alone procedure as follows and grants the EXECUTE privilege on theprocedure to many database users：  CREATE OR REPLACE PROCEDURE create_dept （ v_deptno NUMBER， v_dname VARCHAR2， v_mgr NUMBER， v_loc NUMBER） BEGIN  INSERT INTO hr.departments VALUES （v_deptno， v_dname， v_mgr， v_loc）； END；  The users having permission to execute the procedure are able to insert records into the  DEPARTMENTStable even though they do not have the INSERT privilege on the table. You want only those users whohave privileges on the DEPARTMENTS table to be able to execute the procedure successfully.  What would you suggest to the PL/SQL developers to achieve this（）

• A、Create the procedure with definer’s right.
• B、Create the procedure with invoker’s right.
• C、Grant the EXECUTE privilege with GRANT OPTION on the procedure to selected users.
• D、Create the procedure as part of a PL/SQL package and grant the EXECUTE privilege on the package to selected users

第6题：

You are evaluating the use of pass-through disks for the database servers. You need to recommend a backup solution for the database servers that meets the following requirements： - Minimizes costs. - Provides for the recovery of the databases if a hardware failure occurs. What should you include in the recommendation？（）

• A、Create full backups of the Hyper-V host by using Windows Server Backup
• B、Create snapshots of the VMs from Hyper-V Manager
• C、Create full backups of the Hyper-V host by using Microsoft System Center Data Protection Manager
• D、Create full backups of the VMs by using Windows Server Backup from within the VMs

第7题：

The HR user creates a stand-alone procedure as follows and grants the EXECUTE privilege on the procedureto many database users： CREATE OR REPLACE PROCEDURE create_dept （ v_deptno NUMBER， v_dname VARCHAR2， v_mgrNUMBER， v_loc NUMBER）BEGIN INSERT INTO hr.departments VALUES （v_deptno， v_dname， v_mgr， v_loc）； END； The users having permission to execute the procedure are able to insert records into the DEPARTMENTS tableeven though they do not have the INSERT privilege on the table. You want only those users who haveprivileges on the DEPARTMENTS table to be able to execute the procedure successfully.  What would yousuggest to the PL/SQL developers to achieve this（）

• A、Create the procedure with definer’s right.
• B、Create the procedure with invoker’s right.
• C、Grant the EXECUTE privilege with GRANT OPTION on the procedure to selected users.
• D、Create the procedure as part of a PL/SQL package and grant the EXECUTE privilege on the package toselected users

第8题：

You are evaluating the implementation of Microsoft Application Virtualization （App-V） to deploy App2. What is the minimum number of application packages you should create？（）

• A、2
• B、3
• C、4
• D、1

第9题：

In your multitenant container database (CDB) containing pluggable database (PDBs), the HR user executes the following commands to create and grant privileges on a procedure: CREATE OR REPLACE PROCEDURE create_test_v (v_emp_id NUMBER, v_ename VARCHAR2,v_SALARY NUMBER, v_dept_id NUMBER) BEGIN INSERT INTO hr.test VALUES (V_emp_id, V_ename, V_salary, V_dept_id); END; / GRANT EXECUTE ON CREATE_TEST TO john, jim, smith, king; How can you prevent users having the EXECUTE privilege on the CREATE_TEST procedure from inserting values into tables on which they do not have any privileges?（）

• A、Create the CREATE_TEST procedure with definer’s rights.
• B、Grant the EXECUTE privilege to users with GRANT OPTION on the CREATE_TEST procedure.
• C、Create the CREATE_TEST procedure with invoker’s rights.
• D、Create the CREATE_TEST procedure as part of a package and grant users the EXECUTE privilege the package.

第10题：

You work as the IT professional in an international company which is named Wiikigo. You are experiencedin implementing and administering a network operating system. You are specialized in deploying servers，configuring Windows Server 2008 Terminal services and network application services，and configuring aweb services infrastructure. You have the Windows Deployment Services （WDS） role installed on a serverthat runs Windows Server 2008. You plan to install Windows Vista on a computer that does not supportPreboot Execution Environment （PXE）. You have a Windows Vista image that is stored on the WDS server. You have to start the computer and install the image that is stored on the WDS server. What should you create？（）

• A、You should create a discover image
• B、You should create an install image
• C、You should create a capture image
• D、You should create a CD-ROM that contains PXE drivers