当前位置:1Z0-053题库

问题:

[多选] Which two statements are correct about database transportation?() (Choose two.)

A . The source and target platforms must be the same
B . Redo logs, control files and temp files are also transported
C . The transported database must have the same database identifier (DBID) as the source database and cannot be changed
D . The COMPATIBLE parameter must be set to 10.0.0.0 or higher and the database must be opened in readonly mode before being transported
E . Recovery Manager (RMAN) is used to convert the necessary data files of the database if the target platform is different and has different endian format

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?() The slave was created with mysqldump –u root –p – skip-lock-table—all-databases > /data/data.sql。 The slave user does have INSERT, UPDATE, or DELETE permission and cannot execute the write_rows function。 For tables with UNIQUE keys, statement-based replication must be used maintain integrity。 The root user on the slave has executed FLUSH LOGS, causing the relay-log to doublewrite。 The applications have the SUPER privilege, which allows them to update row。 村民自治决策权 Which of the following commands is used to restore the VIO server from a backup image?() dd。 tar。 restore。 installio。 水利工程建设监理工程师注册后,成为国家公务员或依照公务员管理的现职工作人员的,由水利部注销其注册证书,收回《水利工程建设监理工程师注册证书》和执业印章。 空气中微生物种类数量最多的()。 Which two statements are correct about database transportation?() (Choose two.)
参考答案:

  参考解析

本题暂无解析

在线 客服