当前位置:1z0-043题库

问题:

[单选] You have only two redo log groups and these groups get overwritten several times in a day. Your database operates in NOARCHIVELOG mode and user-managed consistent backups are performed every Sunday night. On Thursday morning, you find that an important table has been dropped and purged. With reference to this scenario, up to what point in time can the data be recovered?()

A .  until Thursday morning
B .  until that point in time when the database is opened
C .  until that point in time when the recovery is performed
D .  until last Sunday’s backup
E .  until that point in time when the table is dropped and purged
F .  until Wednesday evening

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?() The slave SQL thread does not have DELETE privileges to execute on test.t1 table.s。 The table definition on the slave -litters from the master。 Multi-threaded replication slaves can have temporary errors occurring for cross database updates。 The slave SQL thread attempted to remove a row from the test.t1 table, but the row did not exist。 个人跨统筹地区就业的,其基本医疗保险关系随本人转移,缴费年限重新计算。 Which are the prerequisites for performing flashback transactions on your database?()  Undo retention guarantee for the database must be configured.。  Supplemental log must be enabled for the primary key.。  Supplemental log must be enabled.。  Execute permission on the DBMS_FLASHBACK package must be granted to the user.。 关于人身安全保护令的说法正确的是()。 面临家庭暴力的现实危险,向人民法院申请人身安全保护令的,人民法院可以受理。 口头申请人身安全保护令的一律不受理。 人民法院依法作出人身安全保护令的,复议期间停止人身安全保护令的执行。 申请人身安全保护令应当以书面方式提出。 Your database has the SRV1 service configured for an application that runs on middle-tier application server. The application has multiple modules. You enable tracing at the service level by executing the following command: SQL > exec DBMS_MONITOR.SERV_MOD_ACT_TRACE_ENABLE (‘SRV1’); The possible outcome and actions to aggregate the trace files are as follows: 1. The command fails because a module name is not specified. 2. A trace file is created for each session that is running the SRV1 service. 3. An aggregated trace file is created for all the sessions that are running the SRV1 service. 4. The trace files may be aggregated by using the trcess utility. 5. The trace files be aggregated by using the tkprof utility. Identify the correct outcome and the step to aggregate by using tkprof utility?() 1。 2 and 4。 2 and 5。 3 and 4。 3 and 5。 You have only two redo log groups and these groups get overwritten several times in a day. Your database operates in NOARCHIVELOG mode and user-managed consistent backups are performed every Sunday night. On Thursday morning, you find that an important table has been dropped and purged. With reference to this scenario, up to what point in time can the data be recovered?()
参考答案:

  参考解析

本题暂无解析

相关题目:

在线 客服