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;<br /> 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<br /> 2013-08-27 14:15:47 9056 [warning] Slave: Can't find record in 't1' Error_code: 1032<br /> 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".<br /> We stopped at log '56_masterbin. 000003' position 684 Why did you receive this error?（）..

第1题

[] Which two statements are true when row archival management is enabled?（）

A、A. The ORA_ARCHIVE_STATE column visibility is controlled by the ROW ARCHIVAL VISIBILITY session parameter. B、B. The ORA_ARCHIVE_STATE column is updated manually or by a program that could reference activity tracking columns, to indicate that a row is no longer considered active. C、C. The ROW ARCHIVAL VISIBILITY session parameter defaults to active rows only. D、D. The ORA_ARCHIVE_STATE column is visible if referenced in the select list of a query. E、E. The ORA_ARCHIVE_STATE column is updated automatically by the Oracle Server based on activity tracking columns, to Indicate that a row is no longer considered active.

点击查看答案

第2题

[单选题] 如何将变量v_row定义为emp表的记录类型（）

A、v_row emp%type； B、v_row emp%record； C、v_row emp%tabletype； D、v_row emp%rowtype；

点击查看答案

第3题

[多选题] Which three statements about subqueries are true? （）

A、A single row subquery can retrieve only one column and one row. B、A single row subquery can retrieve only one row but many columns. C、A multiple row subquery can retrieve multiple rows and multiple columns. D、A multiple row subquery can be compared using the ">" operator. E、A single row subquery can use the IN operator. F、A multiple row subquery can use the "=" operator.

点击查看答案

第4题

[多选题] Which three statements about subqueries are true?（）

A、A single row subquery can retrieve only one column and one row. B、A single row subquery can retrieve only one row but many columns. C、A multiple row subquery can retrieve multiple rows and multiple columns. D、A multiple row subquery can be compared by using the ">" operator. E、A single row subquery can use the IN operator. F、A multiple row subquery can use the "=" operator.

点击查看答案

第5题

[] Which three statements about subqueries are true?（）

A、A. A single row subquery can retrieve only one column and one row. B、B. A single row subquery can retrieve only one row but many columns. C、C. A multiple row subquery can retrieve multiple rows and multiple columns. D、D. A multiple row subquery can be compared by using the ">" operator. E、E. A single row subquery can use the IN operator. F、F. A multiple row subquery can use the "=" operator.

点击查看答案

第6题

[] Which three statements about subqueries are true?（）

A、A. A single row subquery can retrieve only one column and one row. B、B. A single row subquery can retrieve only one row but many columns. C、C. A multiple row subquery can retrieve multiple rows and multiple columns. D、D. A multiple row subquery can be compared by using the “>” operator. E、E. A single row subquery can use the IN operator. F、F. A multiple row subquery can use the “=” operator.

点击查看答案

第7题

[单选题] Through which action are Currency Codes created？（）

A、 select New Row in Currency Codes application B、 select Action Currency Codes in the Database Configuration application C、 select an Organization in the Currency Codes application and add a new row D、 select the Base Currency lookup in the Organizations application and add a new row

点击查看答案

第8题

[] Which statement describes the effect on an index， when the indexed column for the rows is updatedin the base table（）

A、A.An update in a leaf row takes place. B、B.The index becomes invalid after the update. C、C.The leaf block containing the row to be updated is marked as invalid. D、D.A row in the leaf block of the index for the key value is logically deleted and a new leaf row is inserted

点击查看答案

第9题

[多选题] The EMP table has some discrepancy in data entry with a particular employee ID. You execute the query as shown in the Exhibit to retrieve all versions of the row that exist between two SCNs.View the Exhibit. Which two statements about the results of the query shown in the Exhibit are correct? （）(Choose two.)

A、The LAST_SCN value in the first row is NULL, which means that the versions of the row still exist at SCN 6636300. B、The LAST_SCN value in the second row in NULL, which means that the version of the row still exists at SCN 6636300. C、The LAST_SCN value in the third row is 6636280, which means that the version of row exists above SCN 6636280. D、The LAST_SCN value in the second row is NULL, which means that the version of the row no longer exists because it was deleted.

点击查看答案

请使用微信扫码支付