网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
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？（）
A
DBA_PENDING_TRANSACTIONS
B
DBA_AUDIT_STATEMENT
C
V$FLASHBACK_DATABASE_STATS
D
FLASHBACK_TRANSACTION_QUERY
参考答案
参考解析
解析：
暂无解析
更多 “单选题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？（）A DBA_PENDING_TRANSACTIONSB DBA_AUDIT_STATEMENTC V$FLASHBACK_DATABASE_STATSD FLASHBACK_TRANSACTION_QUERY” 相关考题
考题
Part A51. 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)
考题
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 accountD．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.
考题
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.exeB．Z:\i386\winnt /s:z:\i386 /rwinnt.tmp /a /e:z:\hardware\setup.exeC．Z:\i386\winnt32 /s:z:\i386 /tempdrive:d /cmd:z\hardware\setup.exeD．Z:\i386\winnt32 /s:z:\i386 /cmdcons:z:\hardware\setup /makelocalsource
考题
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’）；
考题
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 DropB、 Flashback DatabaseC、 Flashback TableD、 Flashback Version Query
考题
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、 WindowB、 ProgramC、 Job_ClassD、 Window group
考题
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、 LGWRB、 DBWRC、 MMOND、 RVWR
考题
Identify four uses of the Oracle Scheduler.（）A、 enables Oracle database to schedule which processes execute on which processors in a multiple CPU environmentB、 enables Oracle database to do patches according to a DBA-defined scheduleC、 enables you to schedule the execution of jobs based on timeD、 enables you to execute jobs in a clustered environmentE、 enables you to periodically execute operating systemscript files located on the same server as the databaseF、 enables you to create a job that makes use of saved programs and schedulesG、 enables you to automate the management of the jobs that are created using the DBMS_JOB package
考题
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.
考题
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 databaseB、 the datafiles associated with the SYSTEM tablespaceC、 the datafiles associated with the DATA1 tablespaceD、 all the datafiles in the database except those associated with the DATA1 tablespace
考题
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？（）A、 DBA_PENDING_TRANSACTIONSB、 DBA_AUDIT_STATEMENTC、 V$FLASHBACK_DATABASE_STATSD、 FLASHBACK_TRANSACTION_QUERY
考题
You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. You create a SQL Server Agent job that execute every 2 minutes. There istext file named SQL.log On the E://drive. The job logs information to the text file. You get a report from users saying that the server doesn'；t make response. You check and find that the SQL Server Agent service does not run and the Agent job doesn'；t function any loner. As the IT support， you have to identify the reason for the failure of the SQL Server Agent service. Which log should you check？ （）A、You should check ERRORLOGB、You should check QL1.logC、You should check SQLAGENT.OUTD、You should check log_xx.trc
考题
You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a stored procedure. The stored procedure implements a database maintenance process. A SQL Server Agent job should be created to that runs the stored procedure. Besides this， you must make sure that after it is completed successfully， the job is removed. What should you do？ （）A、You should create a job which is assigned to the Database Maintenance categoryB、You should create an Alert which will run another to delete the maintenance job.C、You should create a job. You schedule the job to run only once.D、You should create a job. The job uses the Automatically delete job option
考题
单选题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 DropB
Flashback DatabaseC
Flashback TableD
Flashback Version Query
考题
单选题You are the network administrator for All network servers run Windows Server 2003. A member server named TESTKING1 hosts several hundred folders, which reside in various locations on the server. TESTKING1 is configured to run a normal backup of the folder every Saturday at 1:00 A.M. You discover that users edit the contents of the folders on Saturday and Sunday. You need to use the Backup utility to reschedule the backup job so that it runs every Monday at 1:00 A.M. instead of every Saturday at 1:00 A.M. You must achieve this goal by using the minimum amount of administrative effort. What should you do?（）A
Specify Monday as the start date of the job.B
Reconfigure the job schedule to run the backup every Monday at 1:00 a.m.C
Add an additional schedule to the job. Configure the additional schedule to run the backup on Monday at 1:00 a.m.D
Use the Repeat Task option to configure the existing job to repeat every 48 hours until an interval of 336 hours passes.
考题
单选题There is more than one way to set the server to detect and affect long running operations automatically. What is the best choice of you want to reduce the impact of long running operations on other users without aborting the long running operations？（）A
Define user profiles and set the CPU_PER_CALL limit. B
Define a SWITCH_TIME for a plan in the Resource Manager. C
Create a batch job that checks V$SESSION_LONGOPS；the batch job alters the session priority of the long running operations. D
Create a user defined event in the Oracle Enterprise Manager， which monitors V$SESSION_LONGOPS.
考题
单选题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’）；
考题
单选题You manage a database named DB1， which is located on a SQL Server 2005 computer. You receive a warning that the drive on which the DB1 log file is located is near capacity.Although the transaction log is backed up every five minutes， you observe that it is steadily growing. You think that an uncommitted transaction might be the cause and you want to investigate. You need to identify both the server process ID and the start time of the oldest active transaction in DB1. What should you do？（）A
Connect to the DB1 database. Execute DBCC OPENTRAN. View the SPID and Starttime rows.B
Connect to the master database. Execute DBCC OPENTRAN. View the SPID andStart time rows.C
In SQL Server Management Studio,open the Activity Monitor. Select the Process Info page and apply the following filter settings, Database=DB1 Open Transactions=YesView the Process ID and Last Batch columns.D
Open a query window. Connect to the master database.Execute the following statement.SELECT TOP 1 spid.last batch FROM sys.sysprocesses WHERE dbid = db id（’DB1’）AND open tran0 ORDER BY last batch
考题
单选题You are the network administrator for Your network consists of a single Active Directory domain named All network servers run Windows Server 2003. A server named TK1 hosts user home folders, which occupy 12 GB of disk space. You install a backup tape device on TK1. You create a batch file that will automatically back up TK1 by running Ntbackup.exe every day at 1:00 A.M. One week later, you test your restoration procedure for home folders on TK1. You notice that your backup data occupies only 9 MB of disk space. You review the backup batch file: REM "Backup Batch File" NTBACKUP.EXE BACKUP D://m daily /1:s /v:yes /k "BACKUP_TK1" You need to ensure that all existing and future data on TK1 is backed up successfully. What should you do?（）A
Specify /b in the command line of the batch file.B
Change /m daily to /m normal in the command line of the batch file.C
Modify the NTFS permissions on the user home folders to assign the Allow - Full Control permission to the Administrators group.D
Add the local Administrator account for TK1 to the local Backup Operators group
考题
单选题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
WindowB
ProgramC
Job_ClassD
Window group
考题
多选题Identify four uses of the Oracle Scheduler.（）Aenables Oracle database to schedule which processes execute on which processors in a multiple CPU environmentBenables Oracle database to do patches according to a DBA-defined scheduleCenables you to schedule the execution of jobs based on timeDenables you to execute jobs in a clustered environmentEenables you to periodically execute operating systemscript files located on the same server as the databaseFenables you to create a job that makes use of saved programs and schedulesGenables you to automate the management of the jobs that are created using the DBMS_JOB package
考题
单选题You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a stored procedure. The stored procedure implements a database maintenance process. A SQL Server Agent job should be created to that runs the stored procedure. Besides this， you must make sure that after it is completed successfully， the job is removed. What should you do？ （）A
You should create a job which is assigned to the Database Maintenance categoryB
You should create an Alert which will run another to delete the maintenance job.C
You should create a job. You schedule the job to run only once.D
You should create a job. The job uses the Automatically delete job option
考题
单选题You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. You create a SQL Server Agent job that execute every 2 minutes. There istext file named SQL.log On the E://drive. The job logs information to the text file. You get a report from users saying that the server doesn'；t make response. You check and find that the SQL Server Agent service does not run and the Agent job doesn'；t function any loner. As the IT support， you have to identify the reason for the failure of the SQL Server Agent service. Which log should you check？ （）A
You should check ERRORLOGB
You should check QL1.logC
You should check SQLAGENT.OUTD
You should check log_xx.trc
考题
单选题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 onlyB
Flashback Table onlyC
Flashback Versions Query onlyD
Flashback Database and Flashback Transaction QueryE
Flashback Versions Query and Flashback Transaction Query
考题
多选题You notice that the elapsed time for an important database scheduler Job is unacceptably long. The job belongs to a scheduler job class and window. Which two actions would reduce the job's elapsed time?（）AIncreasing the priority of the job class to which the job belongsBIncreasing the job's relative priority within the Job class to which it belongsCIncreasing the resource allocation for the consumer group mapped to the scheduler job's job class within the plan mapped to the scheduler windowDMoving the job to an existing higher priority scheduler window with the same schedule and durationEIncreasing the value of the JOB_QUEUE_PROCESSES parameterFIncreasing the priority of the scheduler window to which the job belongs
考题
单选题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.
考题
单选题You are the network administrator for All network servers run Windows Server 2003. A member server named TK1 hosts several hundred folders, which are located on multiple volumes on the server. A backup job on TK1 is configured to run a normal backup of the folders every Saturday at 1:00 A.M. On Wednesday morning, you discover that you need to install a new application on TK1 before the close of business that day. You need to back up all folders on TK1 as quickly as possible so you can install the new application. What should you do?（）A
Create a new backup job that specifies the folders and runs once only.B
Run the existing backup job.C
Enable Volume Shadow Copy for the volumes that contain the folders.D
Create an Automated System Recovery (ASR) set.
热门标签
最新试卷
