You need to dump the data from the master server and import it into a new slave server. Which mysqldump option can be used when dumping data from the master server in order to include the master server's binary log information?（）A、Include-master-infoB、Ma

题目

You need to dump the data from the master server and import it into a new slave server. Which mysqldump option can be used when dumping data from the master server in order to include the master server's binary log information?（）

  • A、Include-master-info
  • B、Master-binlog
  • C、Include-log-file
  • D、Master-data
相似考题

1.You need to dump the data from the master server and import it into a new slave server.Which mysqldump option can be used when dumping data from the master server in order to include the master server‘s binary log information?（）A.Include-master-infoB.Master-binlogC.Include-log-fileD.Master-data

2.When backing up a replication slave, which three should also be backed up in addition to data?()A.The master.info and relay.info filesB.The relay log filesC.The relay index fileD.Mysql.slave_master_info tableE.Mysql.slave_relay_log_info tableF.Mysql.slave_worker_info table

3.Which three statements are true about Oracle Data Pump export and import operations?()A. You can detach from a data pump export job and reattach later.B. Data pump uses parallel execution server processes to implement parallel import.C. Data pump import requires the import file to be in a directory owned by the oracle owner.D. The master table is the last object to be exported by the data pump.E. You can detach from a data pump import job and reattach later.

4.You need to replicate a table from a master to a slave. The master and slave copies of the table will have different number of columns.Which two conditions must be true?()A.Each extra column in the copy with more columns must not have a default valueB.Columns that are common to both versions of the table must be defined in the same order on the master and the slaveC.The slave database cannot have more columns than the master. Only the master database can have more columnsD.Columns that are common to both versions of the table must come first in the table definition, before any additional columns are additional columns are defined on either serverE.The master database cannot have more columns than the slave. Only the slave deatbase can have more columns

参考答案和解析
正确答案:D
更多“You need to dump the data from the master server and import it into a new slave server. Which mysqldump option can be used when dumping data from the master server in order to include the master server's binary log information?（）A、Include-master-infoB、Mas”相关问题

  • 第1题：

    You are the administrator of two SQL Server 2000 computers. One of these servers contains a 4-GB database named marketing. You want to remove the marketing database from one server and add it to the other as quickly as possible.

    What should you do?

    A．Detach the database from the original server by using the sp_detach_db stored procedure. Copy the database and the transaction log files to the new server, and attach them by using the sp_attach_db stored procedure.

    B．Use the DTS export wizard to transfer all database objects from the original server to the new server. Drop the database from the original server.

    C．Run a full backup of the database on the original server. Create a new database named marketing on the new server. Restore the backup in the new marketing database. Drop the database from the original server.

    D．Shut down the original server. Copy the database and the transaction log files to the new server. Use the DISK INIT and DISK REFIT statements to attach the data file to the new server. Drop the database from the original server.


    正确答案：A
    解析：Explanation:Detachingandattachingdatabasesissometimesausefultechniqueforquicklymovingadatabasefromonecomputertoanother.Tomoveadatabase,ordatabasefile,toanotherserverordiskthedatabasemustfirstbedetachedfromtheoriginalserverordisk;movedtotheotherserverordiskandthenattachedontheserverordisk.Inadditionthenewlocationofthemovedfile(s)mustbespecified.Thesp_detach_dbstoredprocedureisusedtodetachthedatabaseandcanrunUPDATESTATISTICSonalltablesbeforedetachingthedatabasewhilethesp_attach_dbstoredprocedureisusedtoattachthedatabaseinitsnewlocation.IncorrectAnswers:B:DTScanimportdatafromatextfileorfromanOLEDBdatasourcesuchasaMicrosoftAccess2000databaseintoSQLServer.ItcanalsoexportdatafromSQLServertoanOLEDBdatadestination.Itprovidesforhigh-speeddataloadingfromtextfilesintoSQLServertables.However,itisnotthefastestwaytomoveawholedatabasefromoneservertoanother.C:Beforeadatabasecanberestoredfromabackuptoanewlocation;thedatabasemustfirstberecreatedinthedestinationasthebackupholdsonlythedatafilesthatbelonginthevarioustables.Itdoesnotholdthetabledefinitions.Thisisnotthefastestmethodtomoveadatabase.D:TheDISKINITandDISKREFITcommandscannotbeusedtomoveadatabasefromoneservertoanother.Note:DISKINITandDISKREINITarefeaturesthatareusedinaSQLServer6.x.inSQLServer6.x,DISKINITisusedtocreatedatabaseortransactionlogdevicestostorethespecifieddatabaseortransactionlogwhenDISKINITfollowedeitheraCREATEDATABASEorALTERDATABASEstatementwhileDISKREINITisusedtorestoredeviceentriestoappropriatesystemtableswhenthedeviceentrywasmissingfromsysdevices.InSQLServer2000theCREATEDATABASEandALTERDATABASEstatementsallowforthecreationofseparatedataandlogfiles.BothCREATEDATABASEandALTERDATABASEcreateoperatingsystemfilesanddatabasesinasinglestep.ItisthusrecommendedthatallreferencestoDISKINITshouldberemovedinSQLServer2000andreplacedwithreferencestoeitherCREATEDATABASEorALTERDATABASE.

  • 第2题：

    You are the administrator of a 12 SQL Server 2000 computers. These servers are located in company offices throughout the world.

    You configure a multiserver job on the server in your company's New York City office. You configure this server as a master server, and designate the remaining 11 servers as target servers.

    After the job completes successfully, you decide to set up a new SQL Server 2000 computer as the master server. The new server will be named JobMaster and the other 12 servers will be target servers.

    You need to make the New York City server a target server instead of a master server. What should you do?

    A．On the New York City server, defect all 11 target servers. On the JobMaster server, enlist the 12 servers as target servers.

    B．On the JobMaster server, enlist all other servers as target servers.

    C．On the New York City server enlist the JobMaster server as a target server. Transfer the multiserver jobs from the New York City server to the JobMaster server.

    D．On the JobMaster server, enlist the New York City server as a target server. On the JobMaster server, enlist the other 11 servers as target servers. On the JobMaster server, defect the New York City server.


    正确答案：A
    解析：Explanation:Whensettingupanewmasterserver,theoldmasterservermustdefectallitstargetservers.Whenanewlydesignatedmasterserverreplacesanexistingmasterserver,thetargetserversmustbedefectedfromtheexistingmasterserver.Thetargetserverscanthenbeenlistedonthenewmasterserver.Thiscanincludetheexistingtargetserver.Note:InSQLServer2000EnterpriseEdition,multiserveradministrationisusedtoautomatetheadministrationofmultipleinstancesofSQLServer2000.Itcanbeusedtomanagetwoormoreserversandtoscheduleinformationflowsbetweenenterpriseserversfordatawarehousing.Withmultiserveradministration,theremustbeatleastonemasterserverandatleastonetargetserver.Amasterserverdistributesjobstoandreceiveseventsfromtargetservers.Amasterserverstoresthecentralcopyofjobdefinitionsforjobsrunontargetservers.Targetserversconnectperiodicallytotheirmasterservertoupdatetheirlistofjobstoperform.Ifanewjobexists,thetargetserverdownloadsthejobanddisconnectsfromthemasterserver.Afterthetargetservercompletesthejob,itreconnectstothemasterserverandreportsthestatusofthejob.WithSQLServer2000EnterpriseEdition,masterserverscanenlisttargetserversandcandefecttargetservers.IncorrectAnswers:B:ThissolutiondoesnotaddresstheneedtodemotetheNewYorkCityserver.Itisthusstillamasterserver.C:InthissolutiontheJobMasterserverisenlistedasatargetserveroftheNewYorkCityserver.ThissolutionalsodoesnotaddresstheneedtodemotetheNewYorkCityserver.Itisthusstillamasterserver.D:InthissolutiontheNewYorkCityserverisnotatargetserveroftheJobMasterserverasithasbeendefectedfromtheJobMasterserver.

  • 第3题：

    Which two statements describe the behavior of the server's SQL mode?（）

    • A、The server's SQL mode determines how the server should behave when performing data validation check and interpreting different forms of syntax
    • B、The server's SQL mode determines whether the server should be read-only or should accept commands such as INSERT and UPDATE
    • C、The server's SQL mode can be changed at the session level with a SET SESSION sql_mode="new_value" command
    • D、The server's SQL mode, when globally set on a slave server, applies to events sent from the master

    正确答案:A,C

  • 第4题：

    When a staging server is used as an environment for testing new data in a default WebSphere Commerce installation， which of the following are true about the staging server？（）

    • A、The database has a subset of the tables in the production server database.
    • B、The database has a copy of selected data from the production database
    • C、The database logs changes for later propagation.
    • D、The database is accessed as read-only to prevent data corruption.
    • E、The database includes all user and order data for offline processing.

    正确答案:B,C

  • 第5题：

    You have table 'apps','userdata' on server that uses MyISAM storage engine. You want to transfer this data to server but use InnoDB engine instead. You execute the following commands: ServerB commands: Shell＞ mysqldump –u root –h server –no-data apps userdata | mysql –u root –p apps Shell＞ mysql –u root –p –h server –e 'ALTER TABLE 'apps','userdata' ENGINE=InnoDB;' Shell＞ mysqldump –u root –p –h server –no-create-info –order-by-primary apps userdata | mysql –u root –p apps What effect does the – order-by-primary argument have on the mysqldump command?（）

    • A、It exports tables with the most indexes first to assist with import speeds
    • B、It ensures that unique indexes have no conflicts when the data is dumped
    • C、It orders by primary key to assist in speeding up importing to InnoDB tables
    • D、It must be specified so index data is dumped correctly when  –on-create-info is used

    正确答案:C

  • 第6题：

    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.

    正确答案:B

  • 第7题：

    Your network consists of a single Active Directory domain. All servers run Windows Server 2003 Service Pack 2 （SP2）. You have a DNS server named Server1 that hosts a primary zone for the domain. You have a DNS server named Server 2 that hosts a secondary zone for the domain.  You discover that the resource records on Server2 are different from the resource records on Server1. You need to ensure that the resource records are the same on Server1 and Server2.  What should you do？（）

    • A、On Server2， select Reload in the DNS zone.
    • B、On Server2， select Reload from Master in the DNS zone.
    • C、On Server1， select Update Server Data File in the DNS zone.
    • D、On Server1， deselect the Fail on load if bad zone data option.

    正确答案:B

  • 第8题：

    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

  • 第9题：

    多选题
    Which three statements are true about Oracle Data Pump export and import operations?（）
    A

    You can detach from a data pump export job and reattach later.

    B

    Data pump uses parallel execution server processes to implement parallel import.

    C

    Data pump import requires the import file to be in a directory owned by the oracle owner.

    D

    The master table is the last object to be exported by the data pump.

    E

    You can detach from a data pump import job and reattach later.


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

  • 第10题：

    多选题
    Which two statements describe the behavior of the server's SQL mode?（）
    A

    The server's SQL mode determines how the server should behave when performing data validation check and interpreting different forms of syntax

    B

    The server's SQL mode determines whether the server should be read-only or should accept commands such as INSERT and UPDATE

    C

    The server's SQL mode can be changed at the session level with a SET SESSION sql_mode=new_value command

    D

    The server's SQL mode, when globally set on a slave server, applies to events sent from the master


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

  • 第11题：

    单选题
    You need to dump the data from the master server and import it into a new slave server. Which mysqldump option can be used when dumping data from the master server in order to include the master server's binary log information?（）
    A

    Include-master-info

    B

    Master-binlog

    C

    Include-log-file

    D

    Master-data


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

  • 第12题：

    单选题
    Which of the following is a feature of a unit of work?（）
    A

    It applies to a single data server.

    B

    It is a recoverable sequence of operations.

    C

    Its value can be queried from the system catalog tables.

    D

    It begins when the application connects to the data server.


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

  • 第13题：

    You are the administrator of a Windows 2000 network. The network includes a Windows 2000 Server computer that is used as a file server. More than 800 of Ezonexam.com's client computers are connected to this server.

    A shared folder named Data on the server is on an NTFS partition. The data folder contains more than 200 files. The permissions for the data folder are shown in the following table.

    Type of permission Account Permission

    Share Users Change

    NTFS Users Full Control

    You discover that users are connected to the Data folder. You have an immediate need to prevent 10 of the files in the Data folder from being modified. You want your actions to have the smallest possible effects on the users who are using other files on the server.

    What two actions should you take? (Choose Two)

    A．Modify the NTFS permissions for the 10 files.

    B．Modify the NTFS permissions for the Data folder.

    C．Modify the shared permissions for the Data folder.

    D．Log off the users from the network.

    E．Disconnect the users from the Data folder.


    正确答案：AE
    解析：Explanation: In this scenario our guideline would be to cause the network users as little disruption as possible. We would do this by only modifying the NTFS permissions on the 10 specific files. Then all users must be disconnected from the Data folder.

    Incorrect answers:
    B: Permissions only need to be changed on the files, not on the whole folder.

    C: Permissions only need to be changed on the files, not on the whole folder.

    D: It is not necessary to log off the users from the network. They only have to be disconnected from the folder.

  • 第14题：

    Which of the following is a feature of a unit of work?()

    A.It applies to a single data server.

    B.It is a recoverable sequence of operations.

    C.Its value can be queried from the system catalog tables.

    D.It begins when the application connects to the data server.


    参考答案：B

  • 第15题：

    You need to replicate a table from a master to a slave. The master and slave copies of the table will have different number of columns. Which two conditions must be true?（）

    • A、Each extra column in the copy with more columns must not have a default value
    • B、Columns that are common to both versions of the table must be defined in the same order on the master and the slave
    • C、The slave database cannot have more columns than the master. Only the master database can have more columns
    • D、Columns that are common to both versions of the table must come first in the table definition, before any additional columns are additional columns are defined on either server
    • E、The master database cannot have more columns than the slave. Only the slave deatbase can have more columns

    正确答案:B,D

  • 第16题：

    Which of the following is a feature of a unit of work?（）

    • A、It applies to a single data server.
    • B、It is a recoverable sequence of operations.
    • C、Its value can be queried from the system catalog tables.
    • D、It begins when the application connects to the data server.

    正确答案:B

  • 第17题：

    Which three statements are true about Oracle Data Pump export and import operations?（）

    • A、You can detach from a data pump export job and reattach later.
    • B、Data pump uses parallel execution server processes to implement parallel import.
    • C、Data pump import requires the import file to be in a directory owned by the oracle owner.
    • D、The master table is the last object to be exported by the data pump.
    • E、You can detach from a data pump import job and reattach later.

    正确答案:A,B,D

  • 第18题：

    You have an Exchange Server 2010 Service Pack 1 （SP1） Mailbox server that contains multiple mailbox databases. You need to ensure that you are notified when deleted mailboxes are purged from the server.What should you do？（）

    • A、Attach a new task to the Application event log.
    • B、Modify the properties of the mailbox database objects.
    • C、Create a new Data Collector Set.
    • D、Create a new Event Viewer Subscription.

    正确答案:A

  • 第19题：

    You have a DNS server named Server1 that hosts a primary zone for the domain. You have a DNS server named Server 2 that hosts a secondary zone for the domain.You discover that the resource records on Server2 are different from the resource records on Server1. You need to ensure that the resource records are the same on Server1 and Server2. What should you do?（）

    • A、On Server2, select Reload in the DNS zone. 
    • B、On Server2, select Reload from Master in the DNS zone. 
    • C、On Server1, select Update Server Data File in the DNS zone. 
    • D、On Server1, deselect the Fail on load if bad zone data option. 

    正确答案:B

  • 第20题：

    多选题
    When a staging server is used as an environment for testing new data in a default WebSphere Commerce installation， which of the following are true about the staging server？（）
    A

    The database has a subset of the tables in the production server database.

    B

    The database has a copy of selected data from the production database

    C

    The database logs changes for later propagation.

    D

    The database is accessed as read-only to prevent data corruption.

    E

    The database includes all user and order data for offline processing.


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

  • 第21题：

    多选题
    When backing up a replication slave, which three should also be backed up in addition to data?（）
    A

    The master.info and relay.info files

    B

    The relay log files

    C

    The relay index file

    D

    Mysql.slave_master_info table

    E

    Mysql.slave_relay_log_info table

    F

    Mysql.slave_worker_info table


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

  • 第22题：

    单选题
    Your network consists of a single Active Directory domain. All servers run Windows Server 2003 Service Pack 2 (SP2). You have a DNS server named Server1 that hosts a primary zone for the domain. You have a DNS server named Server 2 that hosts a secondary zone for the domain. You discover that the resource records on Server2 are different from the resource records on Server1. You need to ensure that the resource records are the same on Server1 and Server2.  What should you do?（）
    A

    On Server2， select Reload in the DNS zone.

    B

    On Server2， select Reload from Master in the DNS zone.

    C

    On Server1， select Update Server Data File in the DNS zone.

    D

    On Server1， deselect the Fail on load if bad zone data option.


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

  • 第23题：

    单选题
    You need to dump the data from the master server and import it into a new slave server. Which mysqldump option can be used when dumping data from the master server in order to include the master server's binary log information?（）
    A

    Include-master-info

    B

    Master-binlog

    C

    Include-log-file

    D

    Master-data


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

相关内容