单选题You work with a newly created database. Presently， there is no application load on the database instance. You want to create a baseline for tuning the application， so you decide to collect recommendations that can be implemented to improve application 

第1题：

You have created an Oracle 10g database named SALES， which will be used by an application named SalesOrders. Users of the SalesOrders application complain that application response time is slow when they generate reports. The SalesOrders application accesses a table that contains 10 million rows. You decide to create an index on this table using the NOLOGGING option so that the index creation process is completed in the least amount of time. Which of the following is NOT true about an index created with the NOLOGGING option？（）

• A、 The index can be changed from NOLOGGING to LOGGING
• B、 The index cannot be recovered even in the ARCHIVELOG mode.
• C、 The index can only be created if the base table is created with the NOLOGGING option.
• D、 The index can be recovered if you perform a backup after the CREATE INDEX statement.

第2题：

You are a database administrator for your company. The company uses a vendor company’s application that is based on a proprietary database. You query data from the application database and import the data into a SQL Server 2005 database. The application vendor provides you with a new OLE DB driver to be used when querying the application database. Company policy prohibits connections between the SQL Server database and the application database， except when querying this data. You need to provide a way to query data from the application database. What should you？（）

• A、Configure a Linked Server connection to the application database.
• B、Write a query that uses an OPENDATASOURCE command.
• C、Write a query that uses an OPENQUERY command.
• D、Configure a Remote Server connection to the application database.

第3题：

第4题：

You work as an application developer at Contoso.com. You use Microsoft .NET Framework 3.5 and Microsoft ADO.NET to develop an application. You want to make sure that the application is operative to any type of database.   What should you do？（）

• A、 Set the database driver name in the connection string of the application， and then the connection object as follows： DbConnection connection = new OdbcConnection（connectionString）；
• B、 Create the connection object as follows： DbProviderFactory factoryDbProviderFactories.GetFactory（databaseProviderName）； DbConnection connection =factory.CreateConnection（）；
• C、 Create the connection object as follows： DbProviderFactory factory = DbProviderFactories.GetFactory（"System.Data.Odbc"）； DbConnection connection = factory.CreateConnection（）；
• D、 Set the database driver name in the connection string of the application， and then the connection object as follows：DbConnection connection = new OleDbConnection（connectionString）；

第5题：

You work as an ASP.NET Web Application Developer for SomeCompany. The company uses Visual Studio .NET 2010 as its application development platform. You create an ASP.NET Web application using .NET Framework 4.0. The Web application connects to a SQL Server database. You use the ADO.NET Entity Framework to handle persistence-ignorant entities. You create an ObjectContext object named ObjContext. Subsequently， you change properties on numerous entities. You are required to save the changed entity values in the SQL Server database. Which of the following code segments will you use？（）

• A、ObjContext.SaveChanges（SaveOptions.DetectChangesBeforeSave）；
• B、ObjContext.SaveChanges（SaveOptions.AcceptAllChangesAfterSave）；
• C、ObjContext.SaveChanges（SaveOptions.All）；
• D、ObjContext.SaveChanges（SaveOptions.None）；

第6题：

You work with a newly created database. Presently， there is no application load on the database instance. You want to create a baseline for tuning the application， so you decide to collect recommendations that can be implemented to improve application performance.  What action must you take to achieve this？（）  

• A、 Run Segment Advisor
• B、 Run the SQL Tuning Advisor （STA）
• C、 Run the Automatic Workload Repository （AWR） report
• D、 Run the SQL Access Advisor with a hypothetical workload

第7题：

You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. The instance has databases for a finance application and a manufacturing application. You want to put some limitation on the maximum CPU query time allowed by the applications, so you configure the Resource Governor to achieve this. But you notice that certain reports do not execute successfully any longer on the manufacturing application. You have to allow the manufacturing application to consume more CPU time, so you have to change the Resource Governor configuration.  Which Resource Governor component should you configure?（）  

• A、The workload group which is used by default 
• B、The workload group which is used by the finance application 
• C、The classifier function which identifies the finance application 
• D、The workload group which is used by the manufacturing application 

第8题：

You work with a newly created database. Presently, there is no application load on the database instance.You want to create a baseline for tuning the application, so you decide to collect recommendations that can be implemented to improve application performance.What action must you take to achieve this?（）

• A、Run Segment Advisor
• B、Run the SQL Tuning Advisor (STA)
• C、Run the Automatic Workload Repository (AWR) report
• D、Run the SQL Access Advisor with a hypothetical workload

第9题：

You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a database named DB01 in the instance. The company CIO wants all the application developers can capture traces to troubleshoot the application that uses the database DB1， and they can perform this by using SQL Server Profiler. But they have to be given as little permission as possible. The company CIO assigns this task to you.  So what action should you perform to achieve this goal？（）  

• A、All the SQL Server logins of the application developers have to be added to a fixed server role. 
• B、All the database users of the application developers have to be added to a fixed database role 
• C、All SQL Server logins of the application developers should be given the appropriate server-level permissions. 
• D、All database users of the application developers should be given the appropriate database-level permissions. 

第10题：

You work as an application developer at Certkiller .com. You are required to dynamically load assemblies into an application domain. You are using the Load method of the AppDomain class. What types of files can you this use method for？（）

• A、 Library application files （.dll）.
• B、 All assembly files， no matter what there file extensions are.
• C、 Application configuration files （.config）.
• D、 Standalone application files （.exe）.