单选题At 10：30 A.M.， you ran a batch job by mistake， which executed a transaction in the database. The transaction identifier of the transaction that made to the changes in the database is 0500A00627B000. At 11：10 A.M.， you stopped the batch job. Now， you wa

题目

单选题

At 10：30 A.M.， you ran a batch job by mistake， which executed a transaction in the database. The transaction identifier of the transaction that made to the changes in the database is 0500A00627B000. At 11：10 A.M.， you stopped the batch job. Now， you want to identify the changes made to the database tables by the batch job. Which view will you query？（）

DBA_PENDING_TRANSACTIONS

DBA_AUDIT_STATEMENT

V$FLASHBACK_DATABASE_STATS

FLASHBACK_TRANSACTION_QUERY

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

相似问题和答案

第1题：

You need to install Windows 2000 Professional on 35 new computers on the company LAN.

First, you create a distribution folder on the network server. Then you create a network boot disk to install Windows 2000 Professional from the distribution folder.

Now you need to create a batch file, which the network boot disk will execute to start the installation. You must specify a source path and temporary drive for the installation files.

You also need to install the accessibility options within the batch file. The batch file must execute a hardware-specific application to run after the GUI-mode Setup has completed.

Which command must you specify in the batch file?

A．Z:\i386\winnt /s:z:\i386 /t:d: /a /e:z:\hardware\setup.exe

B．Z:\i386\winnt /s:z:\i386 /rwinnt.tmp /a /e:z:\hardware\setup.exe

C．Z:\i386\winnt32 /s:z:\i386 /tempdrive:d /cmd:z\hardware\setup.exe

D．Z:\i386\winnt32 /s:z:\i386 /cmdcons:z:\hardware\setup /makelocalsource

正确答案：A
解析：Explanation:Winntmustbeusedtostarttheinstallationprocessfromabootdiskette.The/t:dswitchspecifiesthattheDdriveshouldbeusedtocontaintemporarysetupfiles;the/aswitchspecifiesaninstallationwithaccessibilityoptions;andthe/e[:command]switchspecifiesacommandtobeexecutedattheendofSetup'sGUImode.Incorrectanswers:B:Thiscommanddoesnotspecifywhatdriveshouldbeusedtocontaintemporarysetupfiles.Tospecifyatempdrivethe/tswitchmustbeused.The/rswitchspecifiesanoptionalfolderthatmustbeinstalledontheharddrive.C:Winnt32isa32-bitapplicationandcanonlybeusedfrominsideaWindowsenvironmentandnotafterstartingthecomputerbymeansofabootdiskette.AcomputercanonlybebootedintoDOSmodefromabootdisk,andDOSmodecannotuse32-bitapplications.D:Winnt32isa32-bitapplicationandcanonlybeusedfrominsideaWindowsenvironmentandnotafterstartingthecomputerbymeansofabootdiskette.AcomputercanonlybebootedintoDOSmodefromabootdisk,andDOSmodecannotuse32-bitapplications.

第2题：

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

第3题：

Part A

51. Directions:

You have just received a letter from a company, which replied your application for a job and asked you to go to the interview on August 30. Please write a reply which is about 100 words on ANSWER SHEET II. Do not sign your own name at the end of the letter. You do not need to write the address. ( 10 points)

正确答案：
Dear Mr．Wang，
    Thank you for your reply of August 20 about my application for a position．It came to hand this morning as a pleasant surprise． I am glad to tell you that I will attend the interview at the time you set for the morning of August 30．I will bring along full details of my testimonials as you suggested，
    I Would like to introduce myself to the company and hope to be a member of it．I would certainly spare no effort to acquit myself to your satisfaction．
                                  Yours respectfully，
                                              X X X

第4题：

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？（）

A、 RMAN only.
B、 Flashback Table only.
C、 Flashback Version Query only.
D、 Flashback Database and Flashback Transaction Query.
E、 Flashback Version Query and Flashback Transaction Query.

正确答案:E

第5题：

You dropped a schema of a user in an Oracle 10g by mistake. You decide to flash the database back to its previous state to restore the deleted schema. Which process writes the before images of the physical database blocks to the flashback database logs？（）

A、 LGWR
B、 DBWR
C、 MMON
D、 RVWR

正确答案:D

第6题：

You want to purge job entries older than 5 days from the job log. You do not want to purge window log entries. Which command will you use to accomplish this task？（）

A、 EXECUTE DBMS_SCHEDULER.PURGE_LOG（log_history => 5， job_name => ’JOB1’）；
B、 EXECUTE DBMS_SCHEDULER.PURGE_LOG（ log_history => 5， job_name => ’JOB_LOG’）；
C、 EXECUTE DBMS_SCHEDULER.PURGE_LOG（ log_history => 5， which_log => ’JOB1’）；
D、 EXECUTE DBMS_SCHEDULER.PURGE_LOG（ log_history => 5， which_log =>’JOB_LOG’）；

正确答案:D

第7题：

Your system performs heavy transaction processing between 8：00 A.M. and 5：00 P.M. but runs batch processing and reports after that. You decide to create a separate resource plan to govern resource allocation for each time period. Which scheduler object will you use to switch automatically between the two resource plans？（）

A、 Window
B、 Program
C、 Job_Class
D、 Window group

正确答案:A

第8题：

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.

第9题：

Identify four uses of the Oracle Scheduler.（）

A、 enables Oracle database to schedule which processes execute on which processors in a multiple CPU environment
B、 enables Oracle database to do patches according to a DBA-defined schedule
C、 enables you to schedule the execution of jobs based on time
D、 enables you to execute jobs in a clustered environment
E、 enables you to periodically execute operating systemscript files located on the same server as the database
F、 enables you to create a job that makes use of saved programs and schedules
G、 enables you to automate the management of the jobs that are created using the DBMS_JOB package

正确答案:C,D,E,F

第10题：

You took the DATA1 tablespace offline at 10：00 A.M. At 12：30 P.M.， a schema of a user is dropped and purged from the Recycle Bin. You noticed this at 2：00 P.M. and decided to perform an incomplete recovery. Which datafiles will you recover？（）

A、 all the datafiles in the database
B、 the datafiles associated with the SYSTEM tablespace
C、 the datafiles associated with the DATA1 tablespace
D、 all the datafiles in the database except those associated with the DATA1 tablespace

正确答案:D

At 10：30 A.M.， you ran a batch job by mistake， which execute

题目

相似问题和答案

更多相关问题

相关内容