网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
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
参考答案
参考解析
解析：
暂无解析
更多 “单选题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.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” 相关考题
考题
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
考题
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
考题
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
考题
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
考题
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 ManagerB、Control PanelC、Start MenuD、Event Viewer
考题
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.
考题
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.
考题
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 optionC、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
考题
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 trailB、alert log fileC、user trace fileD、online trace fileE、background trace fileF、operating system event viewer
考题
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.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
考题
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 filesB、 the redo log filesC、 the control fileD、 the change tracking file
考题
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
考题
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 trailB、alert log fileC、user trace fileD、online trace fileE、background trace fileF、operating system event viewer
考题
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.
考题
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
考题
You need to record package and task outcome in the ETLAudit table. Which components of SSIS should you use?（）A、Custom event handlersB、Data flow error outputC、SSIS log provider for SQL ServerD、Execute SQL tasks with failure precedence constraints
考题
单选题You need to record package and task outcome in the ETLAudit table. Which components of SSIS should you use?（）A
Custom event handlersB
Data flow error outputC
SSIS log provider for SQL ServerD
Execute SQL tasks with failure precedence constraints
考题
单选题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
考题
单选题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 trailB
alert log fileC
user trace fileD
online trace fileE
background trace fileF
operating system event viewer
考题
单选题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 trailB
alert log fileC
user trace fileD
online trace fileE
background trace fileF
operating system event viewer
考题
单选题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
考题
单选题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.
考题
单选题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
考题
多选题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
考题
单选题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.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
考题
单选题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 optionC
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
考题
单选题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.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
考题
单选题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.
热门标签
最新试卷
