单选题ROW-based replication has stopped working. You investigate the error log file and find the following entries: 2013-08-27 14:15:47 9056 [ERROR] Slave SQL: Could not execute Delete_rows event on table test.t1; Can't find record in 't1', Error_code: 1032;

题目
单选题
ROW-based replication has stopped working. You investigate the error log file and find the following entries: 2013-08-27 14:15:47 9056 [ERROR] Slave SQL: Could not execute Delete_rows event on table test.t1; Can't find record in 't1', Error_code: 1032; handler error HA_ERR_KEY_NOT_FOUND; the event's master log 56_master-bin. 000003, end_log_pos 851, Error_code: 1032 2013-08-27 14:15:47 9056 [warning] Slave: Can't find record in 't1' Error_code: 1032 2013-08-27 14:15:47 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 684 Why did you receive this error?（）
A

The slave SQL thread does not have DELETE privileges to execute on test.t1 table.s

B

The table definition on the slave -litters from the master

C

Multi-threaded replication slaves can have temporary errors occurring for cross database updates

D

The slave SQL thread attempted to remove a row from the test.t1 table, but the row did not exist

相似考题

1.You plan to use Flashback Drop feature to recover a dropped table SALES_EMP. No other table with the same name exists in the schema.You query RECYCLEBIN and find multiple entries for the SALES_EMP table as follows, You then issue the following statement to recover the table:SQL> FLASHBACK TABLE sales_emp TO BEFORE DROP;What would be the outcome of the precedent statement?（）A. It retrieves the latest version of the table from the recycle binB. It retrieves the oldest version of the table from the recycle binC. It retrieves the version of the table for which undo information is availableD. It returns an error because the table name is not specified as per the names in the OBJECT_NAME column

2.Consider the MySQL Enterprise Audit plugin.On attempting to start the MySQL service after a crash, notice the following error: [ERROR] Plugin ‘audit_log’ init function returned error.In the audit log file, you notice the final entry:…What action should you take to fix the error and allow the service to start?（）A.Re-install the audit pluginB.Execute the command FLUSH LOGSC.Execute the command SET GLOBAL audit_log_fiush= OND.Move or rename the existing audit.log file

3.ROW-based replication has stopped working. You investigate the error log file and find the following entries: 2013-08-27 14:15:47 9056 [ERROR] Slave SQL: Could not execute Delete_rows event on table test.t1;Can‘t find record in ‘t1‘, Error_code: 1032; handler error HA_ERR_KEY_NOT_FOUND; the event‘s master log 56_master-bin. 000003, end_log_pos 851, Error_code: 10322013-08-27 14:15:47 9056 [warning] Slave: Can‘t find record in ‘t1‘ Error_code: 10322013-08-27 14:15:47 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 684 Why did you receive this error?（）A.The slave SQL thread does not have DELETE privileges to execute on test.t1 table.sB.The table definition on the slave -litters from the masterC.Multi-threaded replication slaves can have temporary errors occurring for cross database updatesD.The slave SQL thread attempted to remove a row from the test.t1 table, but the row did not exist

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

更多“单选题ROW-based replication has stopped working. You investigate the error log file and find the following entries: 2013-08-27 14:15:47 9056 [ERROR] Slave SQL: Could not execute Delete_rows event on table test.t1; Can't find record in 't1', Error_code: 1032;”相关问题

  • 第1题：

    After Microsoft Windows boots, a message appears stating that a service failed to start. Which of the following can be used to find more information about this error?（）

    • A、Disk Manager
    • B、Control Panel
    • C、Start Menu
    • D、Event Viewer

    正确答案:D

  • 第2题：

    The session of user SCOTT receives the following error after executing an UPDATE command onthe EMP table：  ERROR at line 1：  ORA-00060： deadlock detected while waiting for resource  On investigation， you find that a session opened by user JIM has a transaction that caused the deadlock.  two statements are true regarding the session of SCOTT in this scenario（）

    • A、The session is terminated after receiving the error and JIM can continue with his transaction.
    • B、SCOTT should perform a COMMIT or ROLLBACK to allow JIM to continue with his transaction.
    • C、The session is rolled back after receiving the error and JIM can continue with his transaction.
    • D、SCOTT has to reexecute the last command in the transaction after he commits the transaction.

    正确答案:B,D

  • 第3题：

    When you try to open your database， you receive the following error：  ORA-00205： error in identifying control file   Where would you find the details required to resolve this error？（）

    • A、audit trail
    • B、alert log file
    • C、user trace file
    • D、online trace file
    • E、background trace file
    • F、operating system event viewer

    正确答案:B

  • 第4题：

    You received the following error：   ORA-01578： ORACLE data block corrupted   （file # %s， block # %s）   Which file will you check to view additional information regarding the cause of this error？（）

    • A、the alert log file and the trace files
    • B、 the redo log files
    • C、 the control file
    • D、 the change tracking file

    正确答案:A

  • 第5题：

    When you try to open your database， you receive the following error：  ORA-00205： error in identifying controlfile  Where would you find the details required to resolve this error？（）

    • A、audit trail
    • B、alert log file
    • C、user trace file
    • D、online trace file
    • E、background trace file
    • F、operating system event viewer

    正确答案:B

  • 第6题：

    You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. A SQL Server Agent job is failing. You find that the job history information is incomplete and seems to be truncated after you review it. All information produced by a job must be available for viewing.  So what action should you perform to achieve this goal? （） 

    • A、You should enable notifications to the Windows application event log when the job completes. 
    • B、You should enable write OEM file 
    • C、You should enable all job steps, making them send the output to a file 
    • D、You should include execution trace messages in the SQL Agent Error log

    正确答案:C

  • 第7题：

    单选题
    You need to record package and task outcome in the ETLAudit table. Which components of SSIS should you use?（）
    A

    Custom event handlers

    B

    Data flow error output

    C

    SSIS log provider for SQL Server

    D

    Execute SQL tasks with failure precedence constraints


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

  • 第8题：

    单选题
    When you try to open your database， you receive the following error：  ORA-00205： error in identifying controlfile  Where would you find the details required to resolve this error？（）
    A

    audit trail

    B

    alert log file

    C

    user trace file

    D

    online trace file

    E

    background trace file

    F

    operating system event viewer


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

  • 第9题：

    单选题
    You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. A SQL Server Agent job is failing. You find that the job history information is incomplete and seems to be truncated after you review it. All information produced by a job must be available for viewing.  So what action should you perform to achieve this goal? （）
    A

    You should enable notifications to the Windows application event log when the job completes. 

    B

    You should enable write OEM file 

    C

    You should enable all job steps, making them send the output to a file 

    D

    You should include execution trace messages in the SQL Agent Error log


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

  • 第10题：

    单选题
    Consider the MySQL Enterprise Audit plugin. On attempting to start the MySQL service after a crash, notice the following error: [ERROR] Plugin ‘audit_log’ init function returned error. In the audit log file, you notice the final entry: … What action should you take to fix the error and allow the service to start?（）
    A

    Re-install the audit plugin

    B

    Execute the command FLUSH LOGS

    C

    Execute the command SET GLOBAL audit_log_fiush= ON

    D

    Move or rename the existing audit.log file


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

  • 第11题：

    单选题
    ROW-based replication has stopped working. You investigate the error log file and find the following entries: 2013-08-27 14:15:47 9056 [ERROR] Slave SQL: Could not execute Delete_rows event on table test.t1; Can't find record in 't1', Error_code: 1032; handler error HA_ERR_KEY_NOT_FOUND; the event's master log 56_master-bin. 000003, end_log_pos 851, Error_code: 1032 2013-08-27 14:15:47 9056 [warning] Slave: Can't find record in 't1' Error_code: 1032 2013-08-27 14:15:47 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 684 Why did you receive this error?（）
    A

    The slave SQL thread does not have DELETE privileges to execute on test.t1 table.s

    B

    The table definition on the slave -litters from the master

    C

    Multi-threaded replication slaves can have temporary errors occurring for cross database updates

    D

    The slave SQL thread attempted to remove a row from the test.t1 table, but the row did not exist


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

  • 第12题：

    单选题
    ROW-based replication has stopped working. You investigate the error log file and find the following entries: 2013-08-27 14:15:47 9056 [ERROR] Slave SQL: Could not execute Delete_rows event on table test.t1; Can't find record in 't1', Error_code: 1032; handler error HA_ERR_KEY_NOT_FOUND; the event's master log 56_master-bin. 000003, end_log_pos 851, Error_code: 1032 2013-08-27 14:15:47 9056 [warning] Slave: Can't find record in 't1' Error_code: 1032 2013-08-27 14:15:47 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 684 Why did you receive this error?（）
    A

    The slave SQL thread does not have DELETE privileges to execute on test.t1 table.s

    B

    The table definition on the slave -litters from the master

    C

    Multi-threaded replication slaves can have temporary errors occurring for cross database updates

    D

    The slave SQL thread attempted to remove a row from the test.t1 table, but the row did not exist


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

  • 第13题：

    Which of the following statements best describes error logging?（）

    • A、Syslogd creates error log entries in the system error log. 
    • B、The default error log is stored in /var/adm/ras/error.log. 
    • C、All entries in the error log are related to software problems. 
    • D、Error logging is automatically enabled during system initialization.

    正确答案:D

  • 第14题：

    You execute the following command in your Certkiller .com production database to change the width of the CUST_NAME column of the CUSTOMERS table： ALTER TABLE customers  MODIFY （cust_nameVARCHAR2 （40）） /  When you execute the command， it displays the following error message：  ERROR at line 1：  ORA-00054： resource busy and acquire with NOWAIT specified  What could be the reason for the error message？（）

    • A、The database instance is not available.
    • B、The ALTER TABLE command does not have WAIT option
    • C、The table or a row in the table is currently locked by another user session.
    • D、The database instance is busy processing other user sessions commands.
    • E、The CUSTOMERS table has no long running query active at the time when this request is made.
    • F、The server process executing the ALTER TABLE command is busy with another command execution

    正确答案:C

  • 第15题：

    ROW-based replication has stopped working. You investigate the error log file and find the following entries: 2013-08-27 14:15:47 9056 [ERROR] Slave SQL: Could not execute Delete_rows event on table test.t1; Can't find record in 't1', Error_code: 1032; handler error HA_ERR_KEY_NOT_FOUND; the event's master log 56_master-bin. 000003, end_log_pos 851, Error_code: 1032 2013-08-27 14:15:47 9056 [warning] Slave: Can't find record in 't1' Error_code: 1032 2013-08-27 14:15:47 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 684 Why did you receive this error?（）

    • A、The slave SQL thread does not have DELETE privileges to execute on test.t1 table.s
    • B、The table definition on the slave -litters from the master
    • C、Multi-threaded replication slaves can have temporary errors occurring for cross database updates
    • D、The slave SQL thread attempted to remove a row from the test.t1 table, but the row did not exist

    正确答案:D

  • 第16题：

    If you wanted to find the name and location of your control files, you could find that information in each of the following locations except one. Which is it?（）

    • A、V_CONTROLFILE_RECORD_SECTION 
    • B、V_CONTROLFILE 
    • C、V$PARAMETER 
    • D、init.ora file

    正确答案:A

  • 第17题：

    You are the network administrator for The network consists of a single Active Directory domain named All network servers run Windows Server 2003. A member server named Testking1 runs IIS and hosts all content for company Web sites. One Web site is redesigned. When you browse the redesigned site, you select a hyperlink and receive the following error message: "HTTP Error 404 - File or directory not found." You verify that a necessary content file is missing from Testking1. You need to discover whether the same error was generated by any other Web server requests. What should you do?（）

    • A、Open the most recent file in C:/windows/system32/inetsrv/History. Search for error entries of type 404.
    • B、Open the most recent file in C:/windows/system32/LogFiles/W3SVC1. Search for error entries of type 404.
    • C、Open Event Viewer and connect to Testking1. Filter the system event log to display only events from the IISLOG event source with event ID 404.
    • D、Open Event Viewer and connect to Testking1. Filter the application event log to display only events from the WebClient event source with event ID 404.

    正确答案:B

  • 第18题：

    You need to record package and task outcome in the ETLAudit table. Which components of SSIS should you use?（）

    • A、Custom event handlers
    • B、Data flow error output
    • C、SSIS log provider for SQL Server
    • D、Execute SQL tasks with failure precedence constraints

    正确答案:A

  • 第19题：

    单选题
    If you wanted to find the name and location of your control files, you could find that information in each of the following locations except one. Which is it?（）
    A

    V_CONTROLFILE_RECORD_SECTION 

    B

    V_CONTROLFILE 

    C

    V$PARAMETER 

    D

    init.ora file


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

  • 第20题：

    单选题
    When you try to open your database， you receive the following error：  ORA-00205： error in identifying control file   Where would you find the details required to resolve this error？（）
    A

    audit trail

    B

    alert log file

    C

    user trace file

    D

    online trace file

    E

    background trace file

    F

    operating system event viewer


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

  • 第21题：

    单选题
    You are the network administrator for The network consists of a single Active Directory domain named All network servers run Windows Server 2003. A member server named Testking1 runs IIS and hosts all content for company Web sites. One Web site is redesigned. When you browse the redesigned site, you select a hyperlink and receive the following error message: "HTTP Error 404 - File or directory not found." You verify that a necessary content file is missing from Testking1. You need to discover whether the same error was generated by any other Web server requests. What should you do?（）
    A

    Open the most recent file in C:/windows/system32/inetsrv/History. Search for error entries of type 404.

    B

    Open the most recent file in C:/windows/system32/LogFiles/W3SVC1. Search for error entries of type 404.

    C

    Open Event Viewer and connect to Testking1. Filter the system event log to display only events from the IISLOG event source with event ID 404.

    D

    Open Event Viewer and connect to Testking1. Filter the application event log to display only events from the WebClient event source with event ID 404.


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

  • 第22题：

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

  • 第23题：

    单选题
    You execute the following command in your Certkiller .com production database to change the width of the CUST_NAME column of the CUSTOMERS table： ALTER TABLE customers  MODIFY （cust_nameVARCHAR2 （40）） /  When you execute the command， it displays the following error message：  ERROR at line 1：  ORA-00054： resource busy and acquire with NOWAIT specified  What could be the reason for the error message？（）
    A

    The database instance is not available.

    B

    The ALTER TABLE command does not have WAIT option

    C

    The table or a row in the table is currently locked by another user session.

    D

    The database instance is busy processing other user sessions commands.

    E

    The CUSTOMERS table has no long running query active at the time when this request is made.

    F

    The server process executing the ALTER TABLE command is busy with another command execution


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

  • 第24题：

    单选题
    Which of the following statements best describes error logging?（）
    A

    Syslogd creates error log entries in the system error log. 

    B

    The default error log is stored in /var/adm/ras/error.log. 

    C

    All entries in the error log are related to software problems. 

    D

    Error logging is automatically enabled during system initialization.


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

相关内容