单选题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 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
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？（）A、Add the ID attribute to the Label control. B、Add the ID attribute to the TextBox control. C、Use the Bind function for the Label control instead of the Eval function. D、Use the Eval function for the TextBox control instead of the Bind function.
You are a professional level SQL Server 2005 database administrator in an international corporation named Wiikigo. You are experienced in implementing high-availability solutions， monitoring the database server， and design deployment. In the company， you major job is the deployment， maintenance and support of Microsoft SQL Server 2005. You work as a database administrator for your company. A vendor company’s application is utilized， and the application is based on a proprietary database. Data is queried from the application database and the data is imported into a SQL Server 2005 database. A new OLE DB driver is offered by the application vendor， and the new OLE DB driver will be utilized when the application database is queried. According the company requirements， the connections between the SQL Server database and the application database is prohibited， except when this data is queried. You should think out a method to have data queried from the application database. Which action should be performed to achieve the goal？（）A、To achieve the goal， a Linked Server connection should be configured to the application database.B、To achieve the goal， a query should be written， and an OPENQUERY command is utilized by the query.C、To achieve the goal， a Remote Server connection to the application database should be configured.D、To achieve the goal， a query should be written， and an OPENDATASOURCE command is utilized by the query.
单选题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. 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 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 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.
单选题You are a professional level SQL Server 2005 database administrator in an international corporation named Wiikigo. You are experienced in implementing high-availability solutions， monitoring the database server， and design deployment. In the company， you major job is the deployment， maintenance and support of Microsoft SQL Server 2005. You work as a database administrator for your company. A vendor company’s application is utilized， and the application is based on a proprietary database. Data is queried from the application database and the data is imported into a SQL Server 2005 database. A new OLE DB driver is offered by the application vendor， and the new OLE DB driver will be utilized when the application database is queried. According the company requirements， the connections between the SQL Server database and the application database is prohibited， except when this data is queried. You should think out a method to have data queried from the application database. Which action should be performed to achieve the goal？（）ATo achieve the goal， a Linked Server connection should be configured to the application database.BTo achieve the goal， a query should be written， and an OPENQUERY command is utilized by the query.CTo achieve the goal， a Remote Server connection to the application database should be configured.DTo achieve the goal， a query should be written， and an OPENDATASOURCE command is utilized by the query.
单选题You work as an application developer at Certkiller .com. You have recently created a multithreaded application to manage Certkiller .com’s inventory system. The fulfillment task has to be executed on a regular basis， while other tasks are performed in the application. The task does not need any input to start. You are required to create and start the fulfillment thread using the appropriate code.What code should you use？（）A AB BC CD D