单选题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?（）AInclude-master-infoBMaster-binlogCInclude-log-fileDMaster-data
单选题
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
参考解析
解析：
暂无解析
相关考题：
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
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
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
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.
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.
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.
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.
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 syntaxB、The server's SQL mode determines whether the server should be read-only or should accept commands such as INSERT and UPDATEC、The server's SQL mode can be changed at the session level with a SET SESSION sql_mode="new_value" commandD、The server's SQL mode, when globally set on a slave server, applies to events sent from the master
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
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 databaseC、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.
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.
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 speedsB、It ensures that unique indexes have no conflicts when the data is dumpedC、It orders by primary key to assist in speeding up importing to InnoDB tablesD、It must be specified so index data is dumped correctly when –on-create-info is used
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.
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
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.
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.
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.
单选题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?（）AOn Server2, select Reload in the DNS zone. BOn Server2, select Reload from Master in the DNS zone. COn Server1, select Update Server Data File in the DNS zone. DOn Server1, deselect the Fail on load if bad zone data option.
单选题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 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？（）AAttach a new task to the Application event log.BModify the properties of the mailbox database objects.CCreate a new Data Collector Set.DCreate a new Event Viewer Subscription.
多选题Which three statements are true about Oracle Data Pump export and import operations?（）AYou can detach from a data pump export job and reattach later.BData pump uses parallel execution server processes to implement parallel import.CData pump import requires the import file to be in a directory owned by the oracle owner.DThe master table is the last object to be exported by the data pump.EYou can detach from a data pump import job and reattach later.
多选题When backing up a replication slave, which three should also be backed up in addition to data?（）AThe master.info and relay.info filesBThe relay log filesCThe relay index fileDMysql.slave_master_info tableEMysql.slave_relay_log_info tableFMysql.slave_worker_info table
多选题Which two statements describe the behavior of the server's SQL mode?（）AThe server's SQL mode determines how the server should behave when performing data validation check and interpreting different forms of syntaxBThe server's SQL mode determines whether the server should be read-only or should accept commands such as INSERT and UPDATECThe server's SQL mode can be changed at the session level with a SET SESSION sql_mode=new_value commandDThe server's SQL mode, when globally set on a slave server, applies to events sent from the master
单选题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?（）AOn Server2， select Reload in the DNS zone.BOn Server2， select Reload from Master in the DNS zone.COn Server1， select Update Server Data File in the DNS zone.DOn Server1， deselect the Fail on load if bad zone data option.
单选题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?（）AIt exports tables with the most indexes first to assist with import speedsBIt ensures that unique indexes have no conflicts when the data is dumpedCIt orders by primary key to assist in speeding up importing to InnoDB tablesDIt must be specified so index data is dumped correctly when –on-create-info is used
单选题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?（）AInclude-master-infoBMaster-binlogCInclude-log-fileDMaster-data
单选题Which of the following is a feature of a unit of work?（）AIt applies to a single data server.BIt is a recoverable sequence of operations.CIts value can be queried from the system catalog tables.DIt begins when the application connects to the data server.