You have a server that has very limited memory but has a very large table. You will use mysqldump to back up this table. Which option will ensure mysqldump will process a row at a time instead of buffering a set of rows?（）A、— quickB、— skip-bufferC、— sing

题目

You have a server that has very limited memory but has a very large table. You will use mysqldump to back up this table. Which option will ensure mysqldump will process a row at a time instead of buffering a set of rows?（）

  • A、— quick
  • B、— skip-buffer
  • C、— single-transaction
  • D、— tab
相似考题

1.You look very tire You must ( ) to bed very late last night.A、have goneB、have been goneC、be goneD、be going

2.—David has made great progress recently. —_______， and _______. A. So he has；so you have B. So he has；so have you C. So he has；so do you D. So has he；so you have

3.You have an Exchange Server 2010 server that has a single mailbox database named DB1.You need to move the transaction log files of DB1.Which cmdlet should you run？（）A、Move-DatabasePathB、Move-MailboxC、Set-ExchangeServerD、Set-MailboxDatabase

4.Your network contains a database server that runs Windows Server 2003 Standard Edition Service Pack 2(SP2). The server has 1 GB of RAM and a single hard disk.Queries against the databases on the server are very slow. You discover that the hard disk on the server is very active.You are evaluating whether to add RAM to the server.You need to use System Monitor to find out whether adding RAM will decrease disk activity.Which performance counter should you monitor? （）A. LogicalDisk : % Free SpaceB. Memory : Pages Faults/secC. Memory : Free System Page Table EntriesD. Server Work Queues : Queue Length

更多“You have a server that has very”相关问题

  • 第1题：

    Your network contains a database server that runs Windows Server 2003 Standard Edition Service Pack 2 (SP2). The server has 1 GB of RAM and a single hard disk. Queries against the databases on the server are very slow. You discover that the hard disk on the server is very active. You are evaluating whether to add RAM to the server. You need to use System Monitor to find out whether adding RAM will decrease disk activity. Which performance counter should you monitor? （）

    • A、LogicalDisk : % Free Space
    • B、Memory : Pages Faults/sec
    • C、Memory : Free System Page Table Entries
    • D、Server Work Queues : Queue Length

    正确答案:B

  • 第2题：

    You work as an Exchange Administrator for TechWorld Inc.The company has a Windows 2008 Active Directory-based contains an Exchange Server 2010 organization.You have deployed Hub Transport server， Client Access server， Unti Mailbox server in the messaging organization.You have not deployed any Edge Transport server in the messaging c following servers can be used to receive and send mail traffic to the Internet？（）

    • A、Server configured with the Client Access server role.
    • B、Server configured with the Hub Transport role.
    • C、Server configured with the Mailbox role.
    • D、Server configured with the Unified Messaging server role.

    正确答案:B

  • 第3题：

    You have a server that runs Windows Server 2003 Service Pack 2 （SP2）.You discover that the server has a large number of open connections that originate from the IP address 192.168.1.121. You need to identify the host name of the computer that uses the IP address 192.168.1.121. Which command should you run？（）

    • A、Arp–a
    • B、Netstat-r
    • C、Net view//192.168.1.121
    • D、Ping–a 192.168.1.121

    正确答案:D

  • 第4题：

    You have a Windows Server 2008 server that has the Web Server （IIS） server role installed. The server contains a Web site.  You need to ensure that the cookies sent from the Web site are encrypted on users computers.  Which Web site feature should you configure？（）

    • A、Authorization Rules
    • B、Machine Key
    • C、Pages And Controls
    • D、SSL Settings

    正确答案:B

  • 第5题：

    You need to design a strategy for identifying the number of instances that any one SQL Server 2005 computer will support. What should you do？（）

    • A、Specify that each server must have one instance for each customer.
    • B、Specify that each server must each have only one instance.
    • C、Specify that each server must have one instance for each database that is hosted on that server.
    • D、Specify that each server must have one instance for each customer who has one or more databases that are hosted on that server.

    正确答案:D

  • 第6题：

    单选题
    You have a Windows Server 2008 R2 computer that has an IP address of 172.16.45.9/21.The server is configured to use IPv6 addressing.You need to test IPv6 communication to a server that has an IP address of 172.16.40.18/21. What should you do from a command prompt？（）
    A

    Type ping 172.16.45.9:::::.

    B

    Type ping ::9.45.16.172.

    C

    Type ping followed by the Link-local address of the server.

    D

    Type ping followed by the Site-local address of the server.


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

  • 第7题：

    单选题
    You have a file server named Server1 that runs Windows Server 2003 Service Pack 2 (SP2). Server1 has one basic disk that contains one partition. You monitor the PhysicalDisk : Avg. Disk Bytes/Read counter for one year and discover that the value has decreased by 25 percent. You need to increase the disk performance of Server1. What should you do? （）
    A

    Compress the volume.

    B

    Defragment the volume.

    C

    Convert the disk to a dynamic disk.

    D

    Enable Shadow Copies on the volume.


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

  • 第8题：

    单选题
    Cer-tech .com has a server that runs Windows Server 2008. You have installed Windows Share Point Services （WSS） role on the Windows Server 2008 server. You want to configure WSS to supportSMTP. What should you do to achieve this task？（）
    A

    Reinstall the WSS role

    B

    Open the Server Manager console and install Application Server

    C

    Configure port 25 for WSS role

    D

    Open the Server Manager console and install the SMTP Server feature


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

  • 第9题：

    单选题
    You have a server that has very limited memory but has a very large table. You will use mysqldump to back up this table. Which option will ensure mysqldump will process a row at a time instead of buffering a set of rows?（）
    A

    — quick

    B

    — skip-buffer

    C

    — single-transaction

    D

    — tab


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

  • 第10题：

    单选题
    You have a new server named Server1 that runs Windows Server 2012 R2. Server1 has two dualcore processors and 32 GB of RAM.You install the Hyper-V server role on Server1.You create two virtual machines on Server1 that each have 8 GB of memory.You need to minimize the amount of time it takes for both virtual machines to access memory. What should you configure on each virtual machine？（）
    A

    Resource control

    B

    Dynamic Memory

    C

    NUMA topology

    D

    Memory weight


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

  • 第11题：

    单选题
    You have an Exchange Server 2010 server that has a single mailbox database named DB1.You need to move the transaction log files of DB1.Which cmdlet should you run？（）
    A

    Move-DatabasePath

    B

    Move-Mailbox

    C

    Set-ExchangeServer

    D

    Set-MailboxDatabase


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

  • 第12题：

    Your company has a server that runs Windows Server 2008 R2. The server is configured as a remoteaccess server. The external firewall has TCP port 80 and TCP port 443 open for remoteconnections. You have a home computer that runs Windows 7. You need to establish secure remote accessconnection from the home computer to the remote access server.  Which type of connection should you configure? （）

    • A、IPSEC
    • B、L2TP
    • C、PPTP
    • D、SSTP

    正确答案:D

  • 第13题：

    Your network contains a database server that runs Windows Server 2003 Standard Edition Service Pack 2 (SP2). The server has 1 GB of RAM and a single hard disk. Queries against the databases on the server are very slow. You discover that the hard disk on the server is very active. You are evaluating whether to add RAM to the server. You need to use System Monitor to find out whether adding RAM will decrease disk activity. Which performance counter should you monitor? （）

    • A、LogicalDisk : % Free Space
    • B、Memory : Pages Faults/sec
    • C、Memory : Free System Page Table Entries
    • D、Server Work Queues : Queue Length

    正确答案:B

  • 第14题：

    You have a server that runs Windows Server 2008. The server has the Web Server （IIS） server role installed and all the Web Server role services installed.  You need to provide a user the ability to administer a Web site. Which feature should you configure？（）

    • A、Net Roles
    • B、Net Users
    • C、Authentication
    • D、IIS Manager Permissions

    正确答案:D

  • 第15题：

    You have a server that runs Windows Server 2008. The server has the Windows Server virtualization role service installed.   You need to merge a differencing disk and a parent disk. What should you do？（）

    • A、Edit the parent disk.
    • B、Inspect the parent disk.
    • C、Edit the differencing disk.
    • D、Inspect the differencing disk.

    正确答案:C

  • 第16题：

    You have a windows server 2008 compute that has an IP address of 172.16.45.9/21. The server is configured to use ipv6 addressing. You need to test IPv6 communication to a server that has an ip address of 172.16.40.18/21, what should you do from a command prompt?（）

    • A、Type ping 172.16.45.9::::.
    • B、Type ping ::9.45.16.172.
    • C、Type ping followed by the link-local address of the server.
    • D、Type ping followed by the site-local address of the server.

    正确答案:C

  • 第17题：

    单选题
    You have a server that runs Windows Server 2003 Service Pack 2 (SP2). The server has Terminal Server installed. You have a new multi-user application that you plan to install on the server. The setup program for the application is named setup.exe. You need to install the application on the server. You must ensure that the application can be used by all users. What should you do? （）
    A

    From the command prompt, run setup.exe.

    B

    From Add or Remove Programs, add a new program.

    C

    In Windows Explorer, use the Run As option to run setup.exe.

    D

    In Windows Explorer, use Compatibility mode to run setup.exe.


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

  • 第18题：

    单选题
    You have a Windows Server 2008 server that has the Web Server （IIS） server role installed. The servercontains a Web site. You need to ensure that the cookies sent from the Web site are encrypted on userscomputers. Which Web site feature should you configure？（）
    A

    Authorization Rules

    B

    Machine Key

    C

    Pages And Controls

    D

    SSL Settings


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

  • 第19题：

    单选题
    You have a server that runs Windows Server 2003 Service Pack 2 (SP2). The server has Terminal Server installed. You have a new multi-user application that you plan to install on the server. The setup program for the application is named setup.exe. You need to install the application on the server. You must ensure that the application can be used by all users. What should you do? （）
    A

    From the command prompt, run setup.exe.

    B

    From Add or Remove Programs, add a new program.

    C

    In Windows Explorer, use the Run As option to run setup.exe.

    D

    In Windows Explorer, use Compatibility mode to run setup.exe.


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

  • 第20题：

    单选题
    You have a server that runs Windows Server 2008. The server has the Web Server （IIS） server role installed.   The server contains a Web site that is configured to use only Windows Authentication. You have a security group named Group1 that contains several user accounts.  You need to prevent the members of Group1 from accessing a Web site. You must not prevent other users from accessing the Web site.  Which Web site feature should you configure？（）
    A

    Authentication

    B

    Authorization Rules

    C

    IIS Manager Permissions

    D

    SSL Settings


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

  • 第21题：

    单选题
    Your network contains a database server that runs Windows Server 2003 Standard Edition Service Pack 2 (SP2). The server has 1 GB of RAM and a single hard disk. Queries against the databases on the server are very slow. You discover that the hard disk on the server is very active. You are evaluating whether to add RAM to the server. You need to use System Monitor to find out whether adding RAM will decrease disk activity. Which performance counter should you monitor? （）
    A

    LogicalDisk : % Free Space

    B

    Memory : Pages Faults/sec

    C

    Memory : Free System Page Table Entries

    D

    Server Work Queues : Queue Length


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

  • 第22题：

    单选题
    You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. The server has a very large database named DB1. An application which is constantly available uses DB1. Now you get a report from users, in the report users complain that server has a poor performance. As the technical support, you have to improve the performance of the application by using the Database Engine Tuning Advisor. Besides this, you must make sure that the action of analyzing the workload will not affect the performance of the production server.So what should you do?（）
    A

    On the local server, enable the XP_MSVER stored procedure 

    B

    On the remote server, enable the XP_MSVER stored procedure. 

    C

    On the production server, use the dta.exe utility along with an XML input file. 

    D

    You should configure a test server that has a similar hardware configuration. Use the dta.exe utility on the test server along with an XML input file


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

相关内容