单选题By mistake， you ran the batch job （for updating the BILL_DETAILS table） twice. You are not sure which rows in the BILL_DETAILS table were affected. You need to identify： a） A list of changes made along with the transaction identifier of each change.

题目

单选题

By mistake， you ran the batch job （for updating the BILL_DETAILS table） twice. You are not sure which rows in the BILL_DETAILS table were affected. You need to identify： a） A list of changes made along with the transaction identifier of each change. b） The necessary SQL statements to undo the erroneous changes. Which option would you choose？（）

RMAN only.

Flashback Table only.

Flashback Version Query only.

Flashback Database and Flashback Transaction Query.

Flashback Version Query and Flashback Transaction Query.

如果没有搜索结果或未解决您的问题，请直接联系老师获取答案。

相似问题和答案

第1题：

What are you recommended to answer the question tell me about yourself, if you are seeking for your first job?

A.Speak much about how that job appeals to you and caused you to apply for it.

B.Speak much about how your enthusiasm about an area has driven you to want that job.

C.Speak much about how a book you’ve read or a person you’ve known motivated you to get that job.

D.Speak much about how your past experiences made you decide to compete for that job.

参考答案：B

第2题：

You are the administrator of a SQL Server 2000 computer. You create a Data Transformation Services (DTS) package. The package is stored as a local package on the server. The package exports data from an online transaction processing (OLTP) database system to an online analytical processing (OLAP) database system that is located on a second SQL Server 2000 computer.

You want the package to execute automatically each evening at 8:00 P.M. What should you do?

A．Use SQL Server Enterprise Manager to create a new job Create a CmdExec job step that runs the dtsrun utility Schedule the job to run each night at 8:00 P.M.

B．Use SQL Server Enterprise Manager to create a new job Create a Transact-SQL job step to query data from the OLTP database Create a second Transact-SQL job step to launch the DTS package Schedule the job to run each night at 8:00 P.M.

C．Create a batch file that runs the dtsrun utility Use the Microsoft Windows Task Scheduler to run the job each night at 8:00 P.M. Configure the Windows Task Scheduler to use the local system account

D．Move the DTS package to the repository Configure the SQLServerAgent service on the OLAP database server to update the package each night at 8:00 P.M.

正确答案：A
解析：Explanation: Transfers can be defined and stored in a DTS package, which can then be run from a command line using the dtsrun utility (DTSRUN.EXE). CmdExec job steps are operating system commands or executable programs ending with .bat, .cmd, .com, or .exe. In this scenario we create a job consisting of a single cmdexec job step which runs the DTS package using the dtsrun utility.

Incorrect answers:
B: Only one job, not two, has to be created at the OLTP database server.

C: If the Task Scheduler is running as the local system account it wouldn’t be able to access the remote OLAP database server.

D: The DTS export package should be run at the OLTP database server, not at the OLAP database server. The DTS package is exported from the OLTP server to the OLAP server.

第3题：

If you ( ) mistake, you ( ) pass the exam.

A、make a, won't

B、will make a, aren't

C、make a, mustn't

正确答案:A

第4题：

Are you positive that there's been no mistake?

A:rational
B:reasonable
C:certain
D:bound

答案：C

解析：

本句意思：你能肯定没有错误吗？rational意为“理性的”; reasonable意为 “合理的”; certain意为“肯定的”，与positive同义；bound意为“束缚，捆绑”。

第5题：

When you find you make a mistake in the chat room, what should you do?

_____________________________________________________________________________

正确答案：
I should correct myself and apologize to those that I have offended.

第6题：

下面哪些句子正确表达"你为什么辞去上一份工作?"()

A、Why did you quit your last job?

B、Why did you do your last job? C.Why did you resign from your last job?

D、Why did you give up your last job?

参考答案：ACD

第7题：

You have a server named Server1 that runs Windows Server 2003 Service Pack 2 (SP2).Server1 has a scheduled task that runs Ntbackup.exe every night. The scheduled task is configured to run by a usernamed BackupUser. BackupUser is a member of the local Backup Operators group.You apply a custom security template that modifies the user rights on Server1.You discover that the scheduled backup job does not work anymore.You use the Local Security Settings console to view the current user rights assignments. The relevant output from the console is shown in the exhibit. (Click the Exhibit button.)You need to ensure that the scheduled backup job executes successfully on Server1.Which user right should you assign to BackupUser? （）

A. Allow log on locally.

B. Log on as a service.

C. Log on as a batch job.

D. Act as part of the operating system.

参考答案：C

第8题：

We all think it most foolish ___________ that mistake .

A.for you to make

B.of you to make

C.for your making

D.of your making

参考答案：B

第9题：

If you want ___________ you have to get the fund somewhere.

A.that the job is done
B.the job done
C.to have done the job
D.the job that is done

答案：B

解析：

考查过去分词作宾语补足语。句意为“如果你想这份工作能够完成，你必须从某个地方找到资金”。job与do是承受关系，构成逻辑上的动宾关系，且done表示已经完成的状态，所以此处用过去分词作宾语补足语。want sth．done意为“想要某事被做”。故选B。

第10题：

At the end of the financial year， an accounts accumulation batch is run. This batch updates the company’s accounting records. During the batch run process， some incorrect entries were inserted into the ACCOUNT table. You identified the bug and immediately stopped the batch run process， but 3000 incorrect records were inserted into the ACCOUNT table before the batch process was stopped. You want to recover the table to the state it was at 11：50 P.M. Which flashback feature will you use？（）

A、 Flashback Drop
B、 Flashback Database
C、 Flashback Table
D、 Flashback Version Query

正确答案:C

By mistake， you ran the batch job （for updating the BILL_DET

题目

相似问题和答案

更多相关问题

相关内容