-
You are designing a forest structure to meet the business and technical requirements. How many forests should you create?（）
A . One
B . Two
C . Three
D . Four
-
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 are developing a custom-collection class.You need to create a method in your class. You need to ensure that the method you create in your class returns a type that is compatible with the Foreach statement. Which criterion should the method meet？（）
A . The method must return a type of either IEnumerator or IEnumerable.
B . The method must return a type of IComparable.
C . The method must explicitly contain a collection.
D . The method must be the only iterator in the class.
-
You plan to use SQL Performance Analyzer to analyze the SQL workload. You created a SQL Tuning Set as a part of the workload capturing. What information is captured as part of this process？（）
A . the SQL text
B . the execution plan
C . the execution context
D . the execution frequency
E . the system change number （SCN）
-
You are creating a form that will access an Oracle8 database. On which three sources can you base a data block?（）
A . BFILE
B . REF column
C . Object table
D . Column object
E . INSTEAD-OF trigger
-
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 are managing an Oracle Database 11g instance.You want to create a duplicate database for testing purpose. What are the prerequisites for performing the active database duplication?（）
A . The source database backup must be copied over the net for test database.
B . The source database must be run in ARCHIVELOG mode if the database is open.
C . The source database must be shut down cleanly if the database is in mounted state.
D . A net service name should be set up and a listener configured with the target as well as the source database.
-
You are designing a migration strategy to create user IDs for all company users in the new environment. What should you do?（）
A . Create a script that uses Active Directory Services Interfaces (ADSI) to import all user account into the new environment.
B . Create new accounts for all users. Create a trust relationship between the existing environment and the new environment to enable access to resources in the existing environment.
C . Import all user accounts into the new environment by using the Active Directory Migration Tool (ADMT).
D . Import all user accounts into the new environment. Instruct users to no change their passwords during the migration phase so that they can access resources in the existing environment.
-
You are designing a Windows Azure application that will use a worker role. The worker role will create temporary files. You need to recommend an approach for creating the temporary files that minimizes storage transactions. What should you recommend？（）
A . Create the files on a Windows Azure Drive.
B . Create the files in Windows Azure local storage.
C . Create the files in Windows Azure Storage page blobs.
D . Create the files in Windows Azure Storage block blobs.
-
You are designing a forest structure to meet the business and technical requirements. How many forests should you create？（）
A . One
B . Two
C . Three
D . Four
-
You use Microsoft .Net Framework 4 to create a Windows Form application. You created a new application, you then wrote the code below: Thread.CurrentThread.CurrentUICulture = Thread.CurrentThread.CurrentCulture Which of the following options are TRUE? （）
A . The user interface will make use of the currently configured culture settings in the Control Panel at present.
B . The user interface will make use of new culture settings.
C . The user interface will make use of the culture settings that were installed with the operating system.
-
You are building a client for a Windows Communication Foundation (WCF) service. You need to create a proxy to consume this service. Which class should you use?（）
A . ChannelFactory
B .
-
You executed the following command to create a tablespace called SALES_DATA： SQL> CREATE TABLESPACE sales_data DATAFILE SIZE 100M SEGMENT SPACE MANAGEMENT AUTO； Which two statements are true about the SALES_DATA tablespace（）
A . The database automatically determines the extent-sizing policy for the tablespace.
B . The segments are automatically shrunk when the contents are removed from them.
C . The allocation of extents within the tablespace is managed through the dictionary tables.
D . The space utilization description of the data blocks in segments is recorded in bitmap blocks.
E . The space utilization description of the data blocks in segments is managed through free lists.
-
You plan to use SQL Performance Analyzer to analyze the SQL workload. You created a SQL Tuning Set as a part of the workload capturing. What information is captured as part of this process?（）
A . the SQL text SQL
B . the execution plan
C . the execution context
D . the execution frequency
E . the system change number (SCN)
-
You are a database administrator for your company. You are responsible for a SQL Server 2005 database that has several indexes. You need to write a stored procedure that checks the indexes for fragmentation. Which Transact-SQL statement should you use？（）
A . DBCC DBREINDEX
B . SELECT * FROM sys.dm_db_index_physical_stats
C . DBCC INDEXDEFRAG
D . SELECT * FROM sys.indexe
-
You need to perform these tasks: 1. Create and assign a MANAGER role to Blake and Clark 2. Grant CREATE TABLE and CREATE VIEW privileges to Blake and Clark Which set of SQL statements achieves the desired results? （）
A . CREATE ROLE manager; GRANT create table, create view TO manager; GRANT manager TO BLACK, CLARK;
B . CREATE ROLE manager; GRANT create table, create voew TO manager; GRANT manager ROLE TO BLACK, CLARK;
C . GRANT manager ROLE TO BLACK, CLARK; GRANT create table, create voew TO BLACK CLARK; ***MISSING***
-
You are creating a Windows Communication Foundation （WCF) service. The service endpoints c
You are creating a Windows Communication Foundation (WCF) service. The service endpoints change frequently. On the service, you add a new ServiceDiscoveryBehavior to the Behaviors collection of the ServiceHost Description property. You need to ensure that client applications can communicate with the service and discover changes to the service endpoints.What should you do？（）
A. Add a new ServiceDiscoveryBehavior to the Behaviors collection in the client application.
B. Add a new AnnouncementClient to the Behaviors collection in the client application.
C. Use the FindCriteria class and the UdpDiscoveryEndpoint class to set up the binding in the client application.
D. Use the DiscoveryProxy class and the EndpointDiscoveryMetadata class to set up the binding in the client application.
-
You are creating a Windows Communication Foundation （WCF) service based on WSHttpBinding.
You are creating a Windows Communication Foundation (WCF) service based on WSHttpBinding. New audit requirements dictate that callers must be authenticated on every call to ensure that their credentials have not been revoked.You need to ensure that the service will not cache the security request token. What should you do？（）
A. Apply a ServiceBehavior attribute to the service implementation class with the lnstanceContextMode property set to Single.
B. In the message security configuration, change clientCredentialType from lssuedToken to UserName
C. In the message security configuration, set establishSecurityContext to false.
D. At the end of every operation, call the SessionStateUtility.RaiseSessionEnd method.
-
You are the administrator of a SQL Server 2000 computer. Each evening after business hours, you perform. database maintenance tasks. You create a Data Transformation Services package to populate the data warehouse. MAPI is not installed on the server.
You want to schedule the DTS package to run each night. You want to attend to other duties while the DTS package is executing. You also want to be notified if the DTS package fails.
What should you do？
A．Select the DTS packages log package execution to SQL server check box. Create a SQL server event alert to notify you if the package fails.
B．Select the DTS packages write completion status to event log check box. Create a SQL server event alert to notify you if the package fails.
C．Configure the DTS package to include an on failure precedence constraint and a send mail task. Configure the send mail task to notify you if the package fails.
D．Configure the DTS package to include an on failure precedence constraint and a send mail task. Configure the execute process task to execute a not send command that will notify you if the package fails.
-
You are the network administrator for All servers run Windows Server 2003.You are creating a backup schedule for the main file server.You need to create a schedule so that backup jobs are completed in the shortestamount of time possible.What should you do？（）
A. Schedule a normal backup every Sunday. Schedule incremental backups every Monday through Saturday.
B. Schedule a normal backup every Sunday. Schedule differential backups every Monday through Saturday.
C. Schedule a copy backup every day.
D. Schedule a normal backup every day.
-
You are creating a Windows Communication Foundation （WCF) service that is implemented as f
You are creating a Windows Communication Foundation (WCF) service that is implemented as follows.(Line numbers are included for reference only.)01 [ServiceContract]02 [ServiceBehavior(IncludeExceptionDetailsInFaults = true)]03 public class OrderService04 {05 [OperationContract]06 public void SubmitOrder(Order anOrder)07 {08 try09 {10 ...11 }12 catch(DivideByZeroException ex)13 {14 ...15 }16 }17 }You need to ensure that the stack trace details of the exception are not included in the error information sent to the client.What should you do？（）
A. Replace line 14 with the following line: throw;
B. Replace line 14 with the following line: throw new FaultException<order>(anOrder, ex.ToString());
C. After line 05, add the following line: [FaultContract(typeof(FaultException<order>))] Replace line 14 with the following line: throw ex;
D. Alter line 05, add the following line: [FaultContract(typeof(FaultException<order>))] Replace line 14 with the following line: throw new FaultException<order>(anOrder, "Divide by zero exception");</order></order></order></order>
-
How can you initiate the source determination when you create a purchase requisition manually? There are 2 correct answers to this question.()
A.Use the button Assign Source of Supply in the header of the purchase requisition
B.Set the indicator for automatic source determination in the respective item of the purchase requisition
C.Set the indicator for automatic source determination in the header of the purchase requisition before you enter purchase requisition items
D.Use the button Assign Source of Supply in the respective item of the purchase requisition
此题为多项选择题。
-
You are the administrator on a Linux network.You have created and are ready to impleme
A．Chmod-M30
B．Chgrp-d30
C．Chage-M30
D．Useradd-D30
