多选题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_wo

题目
多选题
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

如果没有搜索结果或未解决您的问题,请直接 联系老师 获取答案。
相似问题和答案

第1题:

A MySQL replication slave is set up as follows: User all InnoDB tablesReceives ROW-based binary logs Has the read-only optionThe replication slave has been found in an error state.You check the MySQL error log file and find the following entries:2013-08-27 13:55:44 9056 [ERROR] Slave SQL: Could not execute Write_rows event on table test.tl; Duplicate entry ‘3’ for key’PRIMARY’ , Error_code: 1062; handler error HA_ERR_FOUND_DUPP_KEY; the event’s master log 56_master-bin.000003, end_log_pas 653, Error_code: 10622013-08-27 13:55:44 9056 [Warning] Salve: Duplicate entry ‘3’ for key ‘PRIMARY’Error_code: 10622013-08-27 13:55:44 9056 [ERROR] Error running query, slave SQL thread aborted. Fix theproblem, and restart the slave SQL thread with SLAVE START”, We stopped at log ‘56_masterbin.000003’ position 496 What are two possible causes for this error to occur?()

A.The slave was created with mysqldump –u root –p – skip-lock-table—all-databases > /data/data.sql

B.The slave user does have INSERT, UPDATE, or DELETE permission and cannot execute the write_rows function

C.For tables with UNIQUE keys, statement-based replication must be used maintain integrity

D.The root user on the slave has executed FLUSH LOGS, causing the relay-log to doublewrite

E.The applications have the SUPER privilege, which allows them to update rows


参考答案:A, E

第2题:

Frame. Relay is simplified form. of(71),similar in principle to(72), in which synchronous, frames of data are routed to different destinations depending on header information. Packets are routed throught one or more Virtual Circuits known as(73). Most Virtual Circuits are(74),which means that the network provider sets up all DLCI connections at subscription time.(75)are also part of the Frame. Relay specification. They privide a link that only lasts only as long as the session.

A.Datagram Switching

B.Datagram Routing

C.Packet Switching

D.Packet Routing


正确答案:C

第3题:

The Oracle Database 11g database is running in the ARCHIVELOG mode. The archived redo log files are stored on three locations. The Flash Recovery Area is one of the locations. The details are given below:Which statement is true regarding what this command accomplishes?()

A. All archived redo log files backed up at least twice to tape are deleted.

B. All archived redo log files backed up at least once to tape are eligible for deletion.

C. All archived redo log files backed up at least twice to tape are deleted from the flash recovery area.

D. All archived redo log files in local archiving destinations and the flash recovery area backed up at least twice to tape are eligible for deletion.


参考答案:D

第4题:

An existing master-slave setup is currently using a delayed replication of one hour. The master has crashed and the slave must be "rolled forward" to provide all the latest data. The SHOW SLAVE STATUS indicates the following values: RELAY_LOG_FILE =hostname-relay-bin.00004 RELAY_LOG_POS = 1383 Which command set would make the slave current?()

  • A、Gtid_mode must be set to AUTO during point in time recoveries
  • B、Mysqlbinlog ignores arguments to – exclude-gtids-it means ignore all events with GTIDs
  • C、The server keeps track of which GTIDs have already been executed and skips those
  • D、Enforce_gtid_consistency is set to ON

正确答案:C

第5题:

Which of the following backup methodologies is MOST time efficient for backing up data?()

  • A、Incremental
  • B、Snapshot
  • C、Differential
  • D、GFS

正确答案:A

第6题:

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


参考答案:A, B, C

第7题:

Frame. Relay is simplified form. of(71), similar in principle to(72), in which synchronous, frames of data are routed to different destinations depending on header information . Packets are routed throught one or more Virtual Circuits known as(73). Most Virtual Circuits are(74),which means that the network provider sets up all DLCI connections at subscription time.(75)are also part of the Frame. Relay specification . They privide a link that only lasts only as long as the session.

A.Datagram Switching

B.Datagram Routing

C.Packet Switching

D.packet Routing


正确答案:C

第8题:

You issued the following RMAN command to back up the database:Which two statements are true regarding the backup performed?()

A. Archived redo log files are backed up along with data files.

B. Only data files are backed up and a restore point named FY06Q4 is created.

C. Archived log files are backed up along with data files, and the archived log files are deleted.

D. The command creates a restore point named FY06Q4 to match the SCN at which this backup is consistent.


参考答案:A, D

第9题:

What does the minimize load database parameter mean when backing up a database?()

  • A、RMAN will attempt to make the backup run as fast as possible without any IO limitations. 
  • B、RMAN will automatically restrict the number of channels in use to one. 
  • C、RMAN will spread the backup IO over the total duration stated in the backup command.
  • D、RMAN will skip any datafile that currently is involved in an IO operation. RMAN will retry backing up the datafile later and an error will be raised at the end of the backup if the datafile cannot be backed up. 
  • E、Datafiles will be backed up; those having the lowest current number of IO operations will be backed up first. 

正确答案:C

第10题:

An existing master-slave setup is currently using a delayed replication of one hour. The master has crashed and the slave must be "rolled forward" to provide all the latest data. The SHOW SLAVE STATUS indicates the following values: RELAY_LOG_FILE =hostname-relay-bin.00004 RELAY_LOG_POS = 1383 Which command set would make the slave current?()

  • A、STOP SLAVE; CHANGE MASTER TO MASTER_DELAY =0, RELAY_LOG_FILE = 'hostnamerelay- bin.00004' , RELAY_LOG_POS= 1383
  • B、STOP SLAVE; CHANGE MASTER TO RELAY_LOG_FILE = 'hostname-relay-bin.00004', RELAY_LOG_POS = 1383
  • C、STOP SLAVE; CHANGE MASTER TO MASTER_DELAY=0; START SLAVE
  • D、STOP SLAVE; SET GLOBAL master_delay =0; START SLAVE

正确答案:C

更多相关问题