搜题
用户您好， 请在下方输入框内搜索其它题目：
搜题
题目内容 （请给出正确答案）
提问人：网友 发布时间：
【单选题】

A batch application executes a large number of update statements. The service level agreement for the application states that the application must complete its work as quickly as possible to ensure that dependent workloads can start ontime. What is one way to help the application complete quickly?（）

A、Code the application to issue a LOCK TABLE statement.  

B、Code the application to issue a LOCK ROW statement.  

C、Decrease the number of I/O servers.  

D、Increase the locklist parameter. 

查看正确答案
更多“A batch application executes a large number of update statements. The service level agreement for the application states that the application must complete its work as quickly as possible to ensure that dependent workloads can start ontime. What is one way to help the application complete quickly?（）”相关的问题
第1题
[单选题] 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  

点击查看答案
第2题
[单选题] When a system has both online transaction processing as well as large batch processing， which of the following common procedures will best help to improve system performance？（）

A、 Boost the priority of batch jobs.  B、 Schedule batch runs to reduce contention with OLTP.  C、 Schedule OS maintenance such that it includes frequent application of PTFs.  D、 Perform incremental backups of transaction processing and full backups of batch processing.  

点击查看答案
第3题
[单选题] 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  

点击查看答案
第4题
[单选题] When configuring a Commerce Payments cassette for a merchant， what should be created for EACH account？（）

A、A batch for each supported credit card type  B、A batch for each currency and credit card type  C、A batch for each cassette and currency  D、A brand for each supported credit card type  E、A brand for each currency and credit card type  

点击查看答案
第5题
[多选题] You set the undo pool resource plan directive for the consumer group named DSS_USERS that is assigned to the DAY_SHIFT plan. The database users， SCOTT and BLAKE， belong to the DSS_USERS resource group. The user， SCOTT， initiates a database session and executes a batch operation that inserts millions of rows into the HISTORY table. Which two options are true if the total undo space allocated to the DSS_USERS group exceeds the value specified in the undo pool resource plan directive？（）

A、 The batch operation started by the user， SCOTT， terminates with an error.  B、 The batch operation started by the user， SCOTT， hangs and you are required to increase the undo pool resource plan directive.  C、 The batch operation started by the user， SCOTT， runs uninterrupted because the database uses the SYSTEM tablespace for the undo operation.  D、 The user， BLAKE， cannot start a transaction that uses any DML operations until you increase the value of the undo pool resource plan directive.  E、 The user BLAKE can start a transaction that uses any DML operations after the batch operation started by the user， SCOTT， terminates with an error.  

点击查看答案
第6题
[] You are performing a Weekly backup and you want to be sure that you backup everything including the registry， boot files， and COM. How can you do this with the least amount of administrative effort？（）

A、A.Configure the backup to backup the system state area.  B、B.Configure the backup to backup the system partition.  C、C.Create a batch file to run RDISK.EXE /s-before backup starts.  D、D.Create a batch file to run RDISK.EXE /s- after backup is started.  

点击查看答案
第7题
[单选题] 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.  

点击查看答案
第8题
[单选题] 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  

点击查看答案
第9题
[单选题] A corporation wants help in reducing backup costs. By proposing a library with LTO-5 drives,which one of the following would be the BEST reason to choose LTO-5 over LTO-4?（）

A、WORM and encryption capability   B、offers sequential stream of batch data   C、offers ability to read and write multiple generation cartridges   D、lower cost per GB when compared to LTO-4  

点击查看答案
第10题
[多选题] The Automatic Shared Memory Management feature is enabled for the PROD database. Currently， a lot of insert activity is taking place in the database， and the memory structures are allocated according to the database workload. As the workload reduces， you decide to perform batch jobs in the database. Which of the following initialization parameters are NOT automatically resized according to the new workload and continue to remain unchanged？（）

A、 LOG_BUFFER  B、 DB_CACHE_SIZE  C、 JAVA_POOL_SIZE  D、 LARGE_POOL_SIZE  E、 SHARED_POOL_SIZE  F、 STREAMS_POOL_SIZE  

点击查看答案
账号：
答题记录 我的收藏 我的题库
客服
TOP

请使用微信扫码支付

订单号：
遇到问题请联系在线客服