多选题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
多选题
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
参考解析
解析：
暂无解析
相关考题：
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.
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 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
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
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 SwitchingB．Datagram RoutingC．Packet SwitchingD．Packet Routing
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 SwitchingB．Datagram RoutingC．Packet SwitchingD．packet Routing
Which of the following backup methodologies is MOST time efficient for backing up data？（）A、IncrementalB、SnapshotC、DifferentialD、GFS
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.
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 recoveriesB、Mysqlbinlog ignores arguments to – exclude-gtids-it means ignore all events with GTIDsC、The server keeps track of which GTIDs have already been executed and skips thoseD、Enforce_gtid_consistency is set to ON
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= 1383B、STOP SLAVE; CHANGE MASTER TO RELAY_LOG_FILE = 'hostname-relay-bin.00004', RELAY_LOG_POS = 1383C、STOP SLAVE; CHANGE MASTER TO MASTER_DELAY=0; START SLAVED、STOP SLAVE; SET GLOBAL master_delay =0; START SLAVE
When performing a backup using Recovery Manager （RMAN）， which four types of files can be backed up with the RMAN BACKUPcommand？ （）A、 data fileB、 password fileC、 archivelog fileD、 temporary fileE、 online redo log fileF、 the current control fileG、 the tnsnames.ora fileH、 current server parameter file
Which two events will cause a slave server to create a new relay log file?（）A、Execution of the FLUSH LOGS statementB、Starting of the SQL threadC、Reaching the slave_pendign _jobs_size_max limitD、Execution of FULSH TABLES WITH READ LOCKE、Starting of the I/O thread
When performing a backup using Recovery Manager （RMAN）， which four types of files can be backed up with the RMAN BACKUP command？（）A、data fileB、password fileC、archivelog fileD、temporary fileE、online redo log fileF、the current control fileG、the tnsnames.ora fileH、current server parameter file
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 tablespaceB、 password fileC、 online redo log filesD、 the current control fileE、 archived redo log filesF、 the current server parameter fileG、 data files belonging to the USERS tablespace and all the default tablespaces
多选题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？ （）Aall the data files belonging to the USERS tablespaceBpassword fileConline redo log filesDthe current control fileEarchived redo log filesFthe current server parameter fileGdata files belonging to the USERS tablespace and all the default tablespaces
单选题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?（）AThe Frame Relay encapsulation on the physical interface.BThe local DLCI on each subinterface.CAn IP address on the physical interface.DThe subinterface type as point-to-point.
多选题In a design situation, there are multiple character sets that can properly encode your data. Which three should influence your choice of character set?（）ASyntax when writing queries involving JOINSBMemory usage when working with the dataCCharacter set mapping index hash sizeDDisk usage when storing data
多选题Which two events will cause a slave server to create a new relay log file?（）AExecution of the FLUSH LOGS statementBStarting of the SQL threadCReaching the slave_pendign _jobs_size_max limitDExecution of FULSH TABLES WITH READ LOCKEStarting of the I/O thread
多选题Which two data link layers are supported by cisco ios software for IPv6？（）APPPBFDDICFrame Relay PVCDNBMAEFrame Relay SVC
单选题What does the minimize load database parameter mean when backing up a database?（）ARMAN will attempt to make the backup run as fast as possible without any IO limitations. BRMAN will automatically restrict the number of channels in use to one. CRMAN will spread the backup IO over the total duration stated in the backup command.DRMAN 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. EDatafiles will be backed up; those having the lowest current number of IO operations will be backed up first.
多选题Which of the following should be backed up before a Samba version upgrade？（）ALibrariesBTDB filesCConfiguration filesDBinariesEwinbindd_privileged directory
多选题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?（）AThe slave was created with mysqldump –u root –p – skip-lock-table—all-databases /data/data.sqlBThe slave user does have INSERT, UPDATE, or DELETE permission and cannot execute the write_rows functionCFor tables with UNIQUE keys, statement-based replication must be used maintain integrityDThe root user on the slave has executed FLUSH LOGS, causing the relay-log to doublewriteEThe applications have the SUPER privilege, which allows them to update rows
多选题Which two statements about Recovery Manager （RMAN） backups are true？ （）AOnline redo log files can be backed up.BArchived redo log files are backed up.COnly used data blocks can be backed up as backup sets.DOnly consistent database backups can be performed.ERMAN backup can be taken only if the database is configured in ARCHIVELOG mode.
多选题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.)AThe data file backup is done with multiple channelsBThe data files is in the read-write mode after being backed up in the read only modeCThe backup was taken after the data files was taken offline-normal or is in the read only modeDThe data file backup complies with the back retention policy and the backup duplexing feature
多选题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?（）AEIA/TIABQ.932CQ.933ADIEEEECiscoFAnnex D
多选题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.（）AThe data file backup is done with multiple channelsBThe data files is in the read-write mode after being backed up in the read only modeCThe backup was taken after the data files was taken offline-normal or is in the read only modeDThe data file backup complies with the back retention policy and the backup duplexing fe ture
单选题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.