单选题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 AdvisorB Run the SQL Tuning Advisor （STA）C Run the Automatic Workload Repository （AWR） reportD Run the SQL Access Advisor with a hypothetical workload
单选题
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
参考解析
解析：
暂无解析
相关考题：
You create a Web application. The Web application enables users to change fields in their personal profiles. Some of the changes are not persisting in the database. You need to raise a custom event to track each change that is made to a user profile so that you can locate the error.Which event should you use? （）A. WebAuditEventB. WebEventManagerC. WebBaseEventD. WebRequestEvent
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 AdvisorB、Run the SQL Tuning Advisor (STA)C、Run the Automatic Workload Repository (AWR) reportD、Run the SQL Access Advisor with a hypothetical workload
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 LOGGINGB、 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.
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 AdvisorB、 Run the SQL Tuning Advisor （STA）C、 Run the Automatic Workload Repository （AWR） reportD、 Run the SQL Access Advisor with a hypothetical workload
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.
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
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）；
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.
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）；
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）.
You create a Web application. The Web application enables users to change fields in their personal profiles. Some of the changes are not persisting in the database. You need to raise a custom event to track each change that is made to a user profile so that you can locate the error. Which event should you use?（）A、WebAuditEventB、WebEventManagerC、WebBaseEventD、WebRequestEvent
ou work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now for a new application, a SQL Server 2008 instance has to be installed on an existing server. The server contains a default SQL Server 2005 instance. Your company CIO wants their corresponding certified third-party applications can access to both database instances. The company assigns this task to you. You must achieve this by using as little database administrative effort as possible, and never change the existing application environments. What should you do? （） A、You should install SQL Server 2008 as the default instance, and configure the new application to use the default instance B、You should upgrade the SQL Server 2005 application to use SQL Server 2008 C、You should upgrade the SQL Server 2005 instance to a SQL Server 2008 instance D、You should install SQL Server 2008 as a named instance, and make the new application use the new instance.
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 contains a database named DB1. An application which is continuously connected uses DB1. The application extensively uses the INSERT command and triggers the population of multiple tables. Now you notice that the application has a poor performance. You doubt that this problem has something to do with blocking. You have to monitor the state of the instance at regular intervals while not affecting the application performance further. Which tool should you use? （） A、You should use Dynamic Management Views B、You should use SQL Server Resource Governor C、You should use SQL Server Profiler D、You should use Windows System Monitor
You work in a company which uses SQL Server 2008. You are the administrator of the company database. In your company there is a server which contains a default SQL Server 2005 instance. For a new application, you have to install a SQL Server 2008 instance on the server. Your company CIO assigns a task to you. You must make sure that the respective certified third-party applications have access to both database instances. You have to achieve this goal without changing the existing application environments. So what should you do to achieve this by using as little database administrative effort as possible?（）A、You should install SQL Server 2008 as a named instance, and make the new application to use the new instance. B、You should install SQL Server 2008 as the default instance, and make the new application to use the default instance. C、You should upgrade the SQL Server 2005 application to use SQL Server 2008. D、You should upgrade the SQL Server 2005 instance to a SQL Server 2008 instance.
单选题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？（）AConfigure a Linked Server connection to the application database.BWrite a query that uses an OPENDATASOURCE command.CWrite a query that uses an OPENQUERY command.DConfigure a Remote Server connection to the application database.
单选题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？（）AObjContext.SaveChanges（SaveOptions.DetectChangesBeforeSave）；BObjContext.SaveChanges（SaveOptions.AcceptAllChangesAfterSave）；CObjContext.SaveChanges（SaveOptions.All）；DObjContext.SaveChanges（SaveOptions.None）；
单选题You work as an application developer at Certkiller .com. You are currently in the process of developing a business logic component that requires long calculations. You have identified numerous tasks within this application that can be done asynchronously. You notice that these tasks are mutually dependent and require complex synchronization techniques so that it can manage efficiently. You decide to use Microsoft .NET 2.0 to take advantage of its new thread management features. You need to create and start the application threads. What should you do？（）A AB BC CD D
单选题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?（）ARun Segment AdvisorBRun the SQL Tuning Advisor (STA)CRun the Automatic Workload Repository (AWR) reportDRun the SQL Access Advisor with a hypothetical workload
单选题You create a Web application. The Web application enables users to change fields in their personal profiles. Some of the changes are not persisting in the database. You need to raise a custom event to track each change that is made to a user profile so that you can locate the error. Which event should you use? （）AWebAuditEventBWebEventManagerCWebBaseEventDWebRequestEvent
单选题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）；
单选题You work in a company which uses SQL Server 2008. You are the administrator of the company database. In your company there is a server which contains a default SQL Server 2005 instance. For a new application, you have to install a SQL Server 2008 instance on the server. Your company CIO assigns a task to you. You must make sure that the respective certified third-party applications have access to both database instances. You have to achieve this goal without changing the existing application environments. So what should you do to achieve this by using as little database administrative effort as possible?（）AYou should install SQL Server 2008 as a named instance, and make the new application to use the new instance. BYou should install SQL Server 2008 as the default instance, and make the new application to use the default instance. CYou should upgrade the SQL Server 2005 application to use SQL Server 2008. DYou should upgrade the SQL Server 2005 instance to a SQL Server 2008 instance.
单选题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？（）AAll the SQL Server logins of the application developers have to be added to a fixed server role. BAll the database users of the application developers have to be added to a fixed database role CAll SQL Server logins of the application developers should be given the appropriate server-level permissions. DAll database users of the application developers should be given the appropriate database-level permissions.
单选题You create a Microsoft ASP.NET application by using the Microsoft .NET Framework version 3.5. You create a Web page to display photos and captions. The caption of each photo in the database can be modified by using the application. You write the following code fragment： ’ runat="server"/ ’ runat="server" / When you access the Web page， the application throws an error. You need to ensure that the application successfully updates each caption and stores it in the database. What should you do？（）AAdd the ID attribute to the Label control. BAdd the ID attribute to the TextBox control. CUse the Bind function for the Label control instead of the Eval function. DUse the Eval function for the TextBox control instead of the Bind function.
单选题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）.
单选题You work as an application developer at Certkiller .com. You have created a Windows service application for the purpose of monitoring the number of active service requests running on Certkiller .com’s server. You want to configure this Windows service application to produce a report every ten minutes. You start by placing the reporting logic in the GenerateReport method of this Windows service.You want to create a Timer object that invokes this method every ten minutes.What should you do？ （）A AB BC CD D
单选题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?（）AThe workload group which is used by default BThe workload group which is used by the finance application CThe classifier function which identifies the finance application DThe workload group which is used by the manufacturing application
单选题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 LOGGINGB 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.