搜题
用户您好, 请在下方输入框内搜索其它题目:
搜题
题目内容 (请给出正确答案)
提问人:网友 发布时间:
【单项选择题】

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 administrator of a SQL Server 2005 computer, and the computer is called SQL01. The users complain the slow response of all client applications which connect to SQL01. You find that the CPU and memory utilization of SQ

A、A.System Monitor should be utilized to have SQL1s cache hit ratio examined.

B、B.The sys.dm_db_index_physical_stats dynamic management function (DMF) should be examined.

C、C.The sys.dm_db_partition_stats dynamic management view (DMV) should be examined.

D、D.Task Manager should be utilized to have utilization of SQL1s network adapter examined.

更多“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 administrator of a SQL Server 2005 computer, and the computer is called SQL01. The users complain the slow response of all client applications which connect to SQL01. You find that the CPU and memory utilization of SQ”相关的问题
第1题

AYou are working on a database where downtime is not tolerated.  B、You are working on a database where downtime can be tolerated.  C、You are working on a database that operates in ARCHIVELOG mode.  D、You are working on a database that operates in NOARCHIVELOG mode.  E、You are working on a database where all the tablespaces are locally managed.  F、You are working on a database where control files and redo log files are multiplexed.  H、You are working on a database where control files and redo log files are not multiplexed.  

点击查看答案
第2题

A、Flashback logs are not deleted.  B、Flashback logs are deleted automatically.  C、Flashback logs are deleted only if you are using Recovery Manager (RMAN).  D、Flashback logs are deleted only if you are using Oracle Managed Files (OMF).  E、Flashback logs are deleted only if you are using Automatic Storage Management (ASM).  

点击查看答案
第3题

A、 Flashback logs are not deleted.  B、 Flashback logs are deleted automatically.  C、 Flashback logs are deleted only if you are using Recovery Manager (RMAN)  D、 Flashback logs are deleted only if you are using Oracle Manager Files (OFM)  E、 Flashback logs are deleted only if you are using Automatic Storage Management (ASM)  

点击查看答案
客服
TOP

请使用微信扫码支付

订单号:
遇到问题请联系在线客服