当前位置:1z0-043题库

问题:

[单选] You work as a database administrator at Certkiller .com. You are working in an online transaction processing (OLTP) environment. You realize that the salary for an employee, John, has been accidentally modified in the EMPLOYEEStable. Two days ago, the data was in the correct state. Flashback logs generated during last two days are available in the flash recovery area. Which option would you choose to bring the data to the correct state while ensuring that no other data in the same table is affected?()

A .  perform point-in-time recovery
B .  perform a Flashback Table operation to restore the table to the state it was in two days ago
C .  perform a Flashback Database operation to restore the database to the state it was in two days ago
D .  perform Flashback Versions Query and Flashback Transaction Query to determine all the necessary undo SQL statements, and then use them for recovery

Examine the following query output: You issue the following command to import tables into the hr schema: $ > impdp hr/hr directory = dumpdir dumpfile = hr_new.dmp schemas=hr TRANSFORM=DISABLE_ARCHIVE_LOGGING: Y Which statement is true?() All database operations performed by the impdp command are logged.。 Only CREATE INDEX and CREATE TABLE statements generated by the import are logged.。 Only CREATE TABLE and ALTER TABLE statements generated by the import are logged.。 None of the operations against the master table used by Oracle Data Pump to coordinate its activities are logged.。 简述轴与孔的冷缩配合法。 ListBox、ComboBox和RadioGroup 三个组件都有一个Items属性,请说出该属性对三个组件的用途各是什么? 为什么说五六十年代农村题材小说创作具有得天独厚的优越条件? 婴儿游戏活动的最基本表现形式是() 智力游戏。 活动性游戏。 音乐及娱乐游戏。 发展语言的游戏。 You work as a database administrator at Certkiller .com. You are working in an online transaction processing (OLTP) environment. You realize that the salary for an employee, John, has been accidentally modified in the EMPLOYEEStable. Two days ago, the data was in the correct state. Flashback logs generated during last two days are available in the flash recovery area. Which option would you choose to bring the data to the correct state while ensuring that no other data in the same table is affected?()
参考答案:

  参考解析

本题暂无解析

在线 客服