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

2.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.sqlB.The slave user does have INSERT, UPDATE, or DELETE permission and cannot execute the write_rows functionC.For tables with UNIQUE keys, statement-based replication must be used maintain integrityD.The root user on the slave has executed FLUSH LOGS, causing the relay-log to doublewriteE.The applications have the SUPER privilege, which allows them to update rows

3.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

4.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.

更多“多选题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”相关问题

  • 第1题：

    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

  • 第2题：

    Which of the following backup methodologies is MOST time efficient for backing up data？（）

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

    正确答案:A

  • 第3题：

    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

  • 第4题：

    When performing a backup using Recovery Manager （RMAN）， which four types of files can be backed up with the RMAN BACKUPcommand？ （）

    • A、 data file
    • B、 password file
    • C、 archivelog file
    • D、 temporary file
    • E、 online redo log file
    • F、 the current control file
    • G、 the tnsnames.ora file
    • H、 current server parameter file

    正确答案:A,C,F,H

  • 第5题：

    When performing a backup using Recovery Manager （RMAN）， which four types of files can be backed up with the RMAN BACKUP command？（）

    • A、data file
    • B、password file
    • C、archivelog file
    • D、temporary file
    • E、online redo log file
    • F、the current control file
    • G、the tnsnames.ora file
    • H、current server parameter file

    正确答案:A,C,F,H

  • 第6题：

    多选题
    View the Exhibit.You executed the following command to perform a backup of the USERS tablespace： RMAN> BACKUP TABLESPACE USERS；  Which three types of files are backed up？ （）
    A

    all the data files belonging to the USERS tablespace

    B

    password file

    C

    online redo log files

    D

    the current control file

    E

    archived redo log files

    F

    the current server parameter file

    G

    data files belonging to the USERS tablespace and all the default tablespaces


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

  • 第7题：

    多选题
    In a design situation, there are multiple character sets that can properly encode your data. Which three should influence your choice of character set?（）
    A

    Syntax when writing queries involving JOINS

    B

    Memory usage when working with the data 

    C

    Character set mapping index hash size

    D

    Disk usage when storing data


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

  • 第8题：

    多选题
    Which two data link layers are supported by cisco ios software for IPv6？（）
    A

    PPP

    B

    FDDI

    C

    Frame Relay PVC

    D

    NBMA

    E

    Frame Relay SVC


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

  • 第9题：

    多选题
    Which of the following should be backed up before a Samba version upgrade？（）
    A

    Libraries

    B

    TDB files

    C

    Configuration files

    D

    Binaries

    E

    winbindd_privileged directory


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

  • 第10题：

    多选题
    Which two statements about Recovery Manager （RMAN） backups are true？ （）
    A

    Online redo log files can be backed up.

    B

    Archived redo log files are backed up.

    C

    Only used data blocks can be backed up as backup sets.

    D

    Only consistent database backups can be performed.

    E

    RMAN backup can be taken only if the database is configured in ARCHIVELOG mode.


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

  • 第11题：

    多选题
    A new frame relay connection is being brought up. Which of the following are frame relay LMI type options that can be configured on this new link?（）
    A

    EIA/TIA

    B

    Q.932

    C

    Q.933A

    D

    IEEE

    E

    Cisco

    F

    Annex D


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

  • 第12题：

    单选题
    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：   LOG_ARCHIVE_DEST_1 = ’LOCATION = /disk1/archive’ LOG_ARCHIVE_DEST_2 = ’SERVICE = stdb1’ DB_RECOVERY_FILE_DEST = ’/u01/oradata’   Examine the following RMAN command issued to set the deletion policy for archived log files：   RMAN> CONFIGURE ARCHIVELOG DELETION POLICY TO BACKED UP 2 TIMES TO sbt； 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.


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

  • 第13题：

    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

  • 第14题：

    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

  • 第15题：

    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

  • 第16题：

    Which two events will cause a slave server to create a new relay log file?（）

    • A、Execution of the FLUSH LOGS statement
    • B、Starting of the SQL thread
    • C、Reaching the slave_pendign _jobs_size_max limit
    • D、Execution of FULSH TABLES WITH READ LOCK
    • E、Starting of the I/O thread

    正确答案:A,E

  • 第17题：

    View the Exhibit.You executed the following command to perform a backup of the USERS tablespace： RMAN> BACKUP TABLESPACE USERS；  Which three types of files are backed up？ （）

    • A、 all the data files belonging to the USERS tablespace
    • B、 password file
    • C、 online redo log files
    • D、 the current control file
    • E、 archived redo log files
    • F、 the current server parameter file
    • G、 data files belonging to the USERS tablespace and all the default tablespaces

    正确答案:A,D,F

  • 第18题：

    单选题
    You are implementing a new frame relay network to provide connectivity between you offices. To do this, you set up the frame relay network using point-to-point subinterfaces.Which of the following does NOT need to be configured?（）
    A

    The Frame Relay encapsulation on the physical interface.

    B

    The local DLCI on each subinterface.

    C

    An IP address on the physical interface.

    D

    The subinterface type as point-to-point.


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

  • 第19题：

    多选题
    Which two events will cause a slave server to create a new relay log file?（）
    A

    Execution of the FLUSH LOGS statement

    B

    Starting of the SQL thread

    C

    Reaching the slave_pendign _jobs_size_max limit

    D

    Execution of FULSH TABLES WITH READ LOCK

    E

    Starting of the I/O thread


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

  • 第20题：

    单选题
    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
    解析： 暂无解析

  • 第21题：

    多选题
    A MySQL replication slave is set up as follows: User all InnoDB tables Receives ROW-based binary logs Has the read-only option The 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: 1062 2013-08-27 13:55:44 9056 [Warning] Salve: Duplicate entry ‘3’ for key ‘PRIMARY’ Error_code: 1062 2013-08-27 13:55:44 9056 [ERROR] Error running query, slave SQL thread aborted. Fix the problem, 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,D
    解析： 暂无解析

  • 第22题：

    多选题
    You have enabled backup optimization for the RMAN environment. Identify two criteria on which RMAN will skip the file, if it has already been backed up.（） (Choose two.)
    A

    The data file backup is done with multiple channels

    B

    The data files is in the read-write mode after being backed up in the read only mode

    C

    The backup was taken after the data files was taken offline-normal or is in the read only mode

    D

    The data file backup complies with the back retention policy and the backup duplexing feature


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

  • 第23题：

    多选题
    You have enabled backup optimization for the RMAN environment. Identify two criteria on which RMAN will skip the file， if it has already been backed up.（）
    A

    The data file backup is done with multiple channels

    B

    The data files is in the read-write mode after being backed up in the read only mode

    C

    The backup was taken after the data files was taken offline-normal or is in the read only mode

    D

    The data file backup complies with the back retention policy and the backup duplexing fe ture


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

相关内容