The master.info and relay.info files
The relay log files
The relay index file
Mysql.slave_master_info table
Mysql.slave_relay_log_info table
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
第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
第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.
第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?()
第5题:
Which of the following backup methodologies is MOST time efficient for backing up data?()
第6题:
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
第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
第8题:
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.
第9题:
What does the minimize load database parameter mean when backing up a database?()
第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?()