单选题You are a database administrator for your company. The company’s financial forecasting application uses a SQL Server 2005 database that enables business users to run both ad hoc and predefined queries. You suspect that some queries consume an excessive

题目
单选题
You are a database administrator for your company. The company’s financial forecasting application uses a SQL Server 2005 database that enables business users to run both ad hoc and predefined queries. You suspect that some queries consume an excessive amount of server resources. You need to identify which queries consume the most resources. You want to achieve this goal as quickly as possible. What should you do？（）
A

Use the DBCC INPUTBUFFER command.

B

Use the sys.dm_exec_query_stats dynamic management view （DMV）.

C

Use the sqldiag utility.

D

Use the SHOWPLAN session option.

相似考题

1.You work as a database administrator for Supportcenter.cn. You have been asked to use a centralized administrative tool to administer your database servers and application servers. In order to achieve the objective， which component would you configure on each database server？（）A、Database ControlB、Management ServerC、Management RepositoryD、Application Server ControlE、Oracle Management Agent

2.You work as a database administrator for Certkiller .com. Your database is in NOARCHIVELOG mode and you want to perform a backup. Which type of backup would be appropriate in this case？ （）A、Hot backupB、Online backupC、consistent backupD、incremental backupE、inconsistent backup

3. 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.

4.The database administrator of your company created a public synonym called HR for the HUMAN_RESOURCES table of the GENERAL schema, because many users frequently use this table. As a user of the database, you created a table called HR in your schema. What happens when you execute this query? SELECT * FROM HR; （）A、You obtain the results retrieved from the public synonym HR created by the database administrator.B、You obtain the results retrieved from the HR table that belongs to your schema.C、You get an error message because you cannot retrieve from a table that has the same name as a public synonym.D、You obtain the results retrieved from both the public synonym HR and the HR table that belongs to your schema, as a Cartesian product.E、You obtain the results retrieved from both the public synonym HR and the HR table that belongs to your schema, as a FULL JOIN.

更多“You are a database administrator for your company. The compa”相关问题

  • 第1题：

    You are a database administrator for your company. The company’s financial forecasting application uses a SQL Server 2005 database that enables business users to run both ad hoc and predefined queries. You suspect that some queries consume an excessive amount of server resources. You need to identify which queries consume the most resources. You want to achieve this goal as quickly as possible. What should you do？（）

    • A、Use the DBCC INPUTBUFFER command.
    • B、Use the sys.dm_exec_query_stats dynamic management view （DMV）.
    • C、Use the sqldiag utility.
    • D、Use the SHOWPLAN session option.

    正确答案:B

  • 第2题：

    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. You utilize the SP：Recompile event class to run SQL Server Profiler. You find that a great amount of recompiles occurring. The possible causes of the large number of recompiles should be identified.  From the flowing four options， which one is the most possible cause of the problem？（）

    • A、The sp_executesql batches are not being recovered from the procedure cache.
    • B、A database administrator executed UPDATE STATISTICS statements on all tables， and the most common stored procedures reference all the tables.
    • C、One new stored procedure is created by a database administrator.
    • D、Ad hoc batches are not being recovered from the procedure cache.

    正确答案:B

  • 第3题：

    You are a database administrator for your company. You are configuring a new SQL Server 2005 computer named SQL1. SQL1 will run Reporting Services. It will also be configured to automatically perform database backups and other maintenance tasks. There are no other SQL Server computers in the network environment. All access to SQL1 will be made by using SQL1s DNS name. You need to disable any unnecessary services on SQL1. Which service or services should you disable？（）

    • A、Internet Information Services
    • B、SQL Server Browser
    • C、SQL Server Agent
    • D、Microsoft Distributed Transaction Coordinator

    正确答案:B,D

  • 第4题：

    单选题
    You are a database administrator for your company. The company uses a SQL Server 2005 database. A full backup of the database is made each night. Transaction log backups are made each morning and each afternoon. You notice that the database transaction log file grows very large throughout the day. You need to minimize the size of the transaction log file. You also need to minimize data loss in the event of a failure. What should you do？（）
    A

    Decrease the amount of time between transaction log backups.

    B

    Configure the database to use the simple recovery model.

    C

    Configure the RECOVERY INTERVAL option to be a smaller value.

    D

    Run DBCC SHRINKFILE on the transaction log file.


    正确答案： B
    解析： 暂无解析

  • 第5题：

    单选题
    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. Your job is to manage a SQL Server 2005 database， and there are several indexes in the SQL Server 2005. A stored procedure should be written， and the procedure should be utilized to check the indexes for fragmentation.  From the following four Transact-SQL statements， which one should be utilized achieve the goal？（）
    A

    To achieve the goal， DBCC DBREINDEX should be utilized.

    B

    To achieve the goal， SELECT * FROM sys.indexes should be utilized.

    C

    To achieve the goal， SELECT * FROM sys.dm_db_index_physical_stats should be utilized.

    D

    To achieve the goal， DBCC INDEXDEFRAG should be utilized.


    正确答案： A
    解析： 暂无解析

  • 第6题：

    单选题
    You are the administrator of your company’s network. Using Windows Installer packages， you want to install customized versions of Microsoft Excel on different departments in the company. Which type of file should you apply to the installation database？（）
    A

    msi

    B

    mst

    C

    zap

    D

    zip


    正确答案： B
    解析： 暂无解析

  • 第7题：

    单选题
    You are a database administrator for your company. Each night， you perform full backups of your SQL Server 2005 computer. During business hours， you perform hourly transaction log backups. You rebuild database indexes each night. You need to modify your backup strategy. You must ensure that the database recovers to a new server as quickly as possible. What should you do？（）
    A

    Schedule the full backups to run after the nightly index is rebuilt.

    B

    Schedule the full backup to run before the nightly index is rebuilt. Schedule a differential backup to run after the nightly index is rebuilt.

    C

    Schedule an additional transaction log backup to run after the nightly index is rebuilt.

    D

    Schedule a marker to be added to the transaction log before the nightly index is rebuilt.


    正确答案： A
    解析： 暂无解析

  • 第8题：

    多选题
    You work as a database administrator for Supportcenter.cn. You want to administer your database servers， which are running on different host machines， using the Web-enabled grid control interface. You have configured the agent on the host machines. You have started the Oracle Database 10g Grid Control utility on your machine. Which two additional components would you configure to achieve this objective？（）
    A

    Application Server Control

    B

    Oracle Management Service

    C

    Oracle Enterprise Manager Repository

    D

    Oracle Enterprise Manager Database Control


    正确答案： A,D
    解析： 暂无解析

  • 第9题：

    单选题
    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.indexes


    正确答案： A
    解析： 暂无解析

  • 第10题：

    单选题
    You work as a database administrator for Certkiller .com. Your database is in NOARCHIVELOG mode and you want to perform a backup. Which type of backup would be appropriate in this case？ （）
    A

    Hot backup

    B

    Online backup

    C

    consistent backup

    D

    incremental backup

    E

    inconsistent backup


    正确答案： D
    解析： 暂无解析

  • 第11题：

    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 user database named Products is included by your SQL Server 2005 computer. SQL Server Integration Services （SSIS） packages are utilized to export data from the Products database to a text file. You deliver the text file to your company’s trading partners by utilizing FTP. You are required to make sure that your SSIS packages can be recovered from the occurrence of a disaster.  Which action should be performed to finish the task？（）

    • A、To finish the task，the Products database should be backed up.
    • B、To finish the task，your server should be set to utilize the full recovery model.
    • C、To finish the task，your server should be set to utilize the bulk-logged recovery model.
    • D、To finish the task， the msdb database should be backed up.

    正确答案:D

  • 第12题：

    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 the database administrator for your company. You find a problem that there are three reports which are running slowly. And through detailed analysis， you conclude that no error messages are generated from these reports. Not only the indexing strategy but also the status of the current indexes is tested by you. You confirm that the slow performance of the financial reports is not caused by it. Since you are the technical support， you are required to find out which statement is causing the slow performance. Which action should be performed first？（）

    • A、SQL Server Profiler should be run with the Lock：Deadlock event class.
    • B、The Database Engine Tuning Advisor （DTA） f should be run or at least one hour.
    • C、SQL Server Profiler should be run with the TSQL_Duration template.
    • D、The Database Engine Tuning Advisor （DTA） should be run with the default options.

    正确答案:C

  • 第13题：

    单选题
    You are a database administrator for your company. The company uses a SQL Server 2005 computer that runs Reporting Services. Reporting Services is used to produce hundreds of reports each day. You discover that the ReportServerTempDB database is growing. You need to minimize the size of the ReportServerTempDB database. What should you do？（）
    A

    Decrease the time between transaction log backups of the database.

    B

    Delete report snapshot history each week.

    C

    Minimize the use of session caching in the reports.

    D

    Minimize the use of report snapshots in the reports.


    正确答案： C
    解析： 暂无解析

  • 第14题：

    单选题
    You work as a database administrator for Supportcenter.cn. You have been asked to use a centralized administrative tool to administer your database servers and application servers. In order to achieve the objective， which component would you configure on each database server？（）
    A

    Database Control

    B

    Management Server

    C

    Management Repository

    D

    Application Server Control

    E

    Oracle Management Agent


    正确答案： C
    解析： 暂无解析

  • 第15题：

    单选题
    You work as a database administrator for Certkiller .com. You enabled tracing while creating a listener to your database.  What additional information is available to you when you enable tracing？（）
    A

    Information about each Oracle Net connection.

    B

    Information about each entry in theLinstener.orafile

    C

    Information about the changed done in the database

    D

    Information about the different listeners in your system

    E

    Information about all thenondatabasefiles required to operate the database


    正确答案： B
    解析： 暂无解析

  • 第16题：

    单选题
    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.


    正确答案： B
    解析： 暂无解析

  • 第17题：

    多选题
    You work as a database administrator for Certkiller .com. Your database is opened in NOARCHIVEKLOG mode. You decide to place the database in ARCHIVELOG mode.  How would you do this？（）
    A

    Execute the ALTER DATABASE ARCHIVELOG statement

    B

    Select ARCHIVELOG option in the database control and restart the database to apply the changes.

    C

    Shut down and start the instance, and in the NOMOUNT state execute the ALTER DATABASE ARCHIVELOG statement.

    D

    Shut down and start the instance, mount the database, then execute the ALTER DATABASE ARCHIVELOG statement.


    正确答案： C,D
    解析： 暂无解析

  • 第18题：

    单选题
    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. You utilize the SP：Recompile event class to run SQL Server Profiler. You find that a great amount of recompiles occurring. The possible causes of the large number of recompiles should be identified.  From the flowing four options， which one is the most possible cause of the problem？（）
    A

    The sp_executesql batches are not being recovered from the procedure cache.

    B

    A database administrator executed UPDATE STATISTICS statements on all tables， and the most common stored procedures reference all the tables.

    C

    One new stored procedure is created by a database administrator.

    D

    Ad hoc batches are not being recovered from the procedure cache.


    正确答案： A
    解析： 暂无解析

  • 第19题：

    单选题
    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 SQL Server 2005 database is utilized in your company. And a table named Inventory is contained by the database. A column named Price is included by the table. According to the company policy， you cannot reduce more than 10 percent the value in the Price column in any single database operation. Through many kinds of method， the company makes updates to the Price column. For instance， the utilization of ad hoc queries is one of the methods. Since you are the database administrator， you should confirm that this company policy takes its effect. Which action should be performed？（）
    A

    A stored procedure should be created， and changes are disallowed by the procedure to the Price column that violates company policy.

    B

    On the Price column， a check constraint should be created， and a specified minimum value is required by the check constraint.

    C

    A trigger should be created， and changes are rolled back by the trigger to the Price column that violates company policy.

    D

    On the Price column， a foreign key constraint is created to a table that valid prices are included.


    正确答案： D
    解析： 暂无解析

相关内容