网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
In one of your online transaction processing （OLTP） applications， users are manipulating and querying a database table simultaneously. From the Segment Advisor， you find that one of the tables is highly fragmented and you want to shrink the table immediately without affecting the currently active queries. Which option would you use with the ALTER TABLE command to achieve this objective？（）
A
REBUILD
B
CASCADE
C
TRUNCATE
D
ROW MOVEMENT
E
SHRINK SPACE COMPACT
F
SHRINK SPACE CASCADE
参考答案
参考解析
解析：
暂无解析
更多 “单选题In one of your online transaction processing （OLTP） applications， users are manipulating and querying a database table simultaneously. From the Segment Advisor， you find that one of the tables is highly fragmented and you want to shrink the table immediately without affecting the currently active queries. Which option would you use with the ALTER TABLE command to achieve this objective？（）A REBUILDB CASCADEC TRUNCATED ROW MOVEMENTE SHRINK SPACE COMPACTF SHRINK SPACE CASCADE” 相关考题
考题
Online banking refers to banking activities that are carried out over the Internet on a secure website. It developed in the late 1990s and grew more popular over the years since it can make one’s financial life much easier to manage. First, you can use online banking to pay your bills. Most banks have a section in which you set up payees. Fill out the information once, you can simply choose that profile every time you pay a bill online. Second, online banking allows you to access your account history and transactions from anywhere. It is the quickest way to check and see if a transaction has cleared your account. It also enables you to find out about unauthorized transactions more quickly. Third, online banking also allows you to transfer money between accounts effectively. It is more convenient than using the automated phone service. When you set up your online banking, be sure that all of your accounts at the bank are listed. This will make it easier to transfer money and make loan payments online. ? Obviously, you need to pay special attention to your safety or privacy using online banking. It is important to clear your cookies after each banking session, especially at a public computer. Additionally, make sure that your password is long enough to prevent it from easily being hacked. Never give your online account information to anyone else. Check your credit report regularly. Thus you can protect yourself from identity theft.1. Online banking refers to banking systems where you can carry out your business over the Internet on any website.()2. Most banks have a section in which you set up your own business.()3. Online banking is the quickest way to check and see if a transaction is done.()4. It is more useful and easier than using the automated phone service.()5. No doubt, you have to keep a special eye on your safety or privacy using online banking.()
考题
Your company has an existing Windows Communication Foundation (WCF) service that allows business partners to place orders. The service uses netMsmqBinding. You find that processing every order in its own transaction is causing a delay. You need to ensure that the service is configured to process multiple orders in one transaction. What should you do? （）A. Useservice behavior and set the maxConcurrentCalls attribute.B. Useendpoint behavior and set the maxBatchSize attribute.C. Useendpoint behavior and set the maxPendingReceives attribute.D. Useendpoint behavior.
考题
Your database supports an online transaction processing (OLTP) application.The application is undergoing some major schema changes, such as addition of new indexes and materialized views.You want to check the impact of these changes on workload performance.What should you use to achieve this?（）A. Database replayB. SQL Tuning AdvisorC. SQL Access AdvisorD. SQL Performance AnalyzerE. Automatic Workload Repository compare reports
考题
You want to use the Flashback Transaction Query feature to identify all the changes made to your database within a specific time period. What is a prerequisite for using the Flashback Transaction Query feature？（）A、 You must use automatic undo management in the database.B、 You must configure OMF in your database.C、 You must configure ASM for storing the datafiles.D、 You must multiplex the online redo log file.
考题
In one of your online transaction processing （OLTP） applications， most users frequently modify the values， including the key values， of the application tables. Some users generate application reports by using multiple application tables. What is the best table structure that you can use to gain optimal performance？（）A、heap tableB、object tableC、external tableD、clustered tableE、global temporary tableF、indexorganized table （IOT）
考题
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.
考题
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 are maintaining your OLTP database in Oracle10g. You are performing the Flashback Transaction Query to find the undo SQL statements that can be used to undo the changes made to the database in the specific time period. Which pseudocolumn will you use to perform the Flashback Transaction Query？（）A、 VERSIONS_STARTSCNB、 VERSIONS_STARTTIMEC、 VERSIONS_XIDD、 VERSIONS_OPERATION
考题
You want to create a new optimized database for your transactional production environment to be used by a financial application. While creating the database， you want the Oracle software to take care of all basic settings to optimize the database performance. Which method would you use to achieve this objective？（）A、Use the CREATE DATABASE .. command to create the database with Oracle-managed files. B、Use the Database Configuration Assistant (DBCA) to create the database with Oracle-managed files. C、Use Enterprise Manager to create a new database with the Online Transaction Processing (OLTP) option. D、Use Database Configuration Assistant (DBCA) to create the database with Transaction Processing template. E、Use the CREATE DATABASE .. command to create the database with Automatic Storage Management (ASM) file system.
考题
In one of your online transaction processing （OLTP） applications， most users frequently modify the values， including the key values， of the application tables. Some users generate application reports by using multiple application tables. What is the best table structure that you can use to gain optimal performance？（）A、heap tableB、object tableC、external tableD、clustered tableE、global temporary tableF、index-organized table （IOT）
考题
Your database supports an online transaction processing (OLTP) application. The application is undergoing some major schema changes, such as addition of new indexes and materialized views. You want to check the impact of these changes on workload performance. What should you use to achieve this?（）A、Database replayB、SQL Tuning AdvisorC、SQL Access AdvisorD、SQL Performance AnalyzerE、Automatic Workload Repository compare reports
考题
In one of your online transaction processing （OLTP） applications， users are manipulating and querying a database table simultaneously. From the Segment Advisor， you find that one of the tables is highly fragmented and you want to shrink the table immediately without affecting the currently active queries. Which option would you use with the ALTER TABLE command to achieve this objective？（）A、 REBUILDB、 CASCADEC、 TRUNCATED、 ROW MOVEMENTE、 SHRINK SPACE COMPACTF、 SHRINK SPACE CASCADE
考题
Your company has an existing Windows Communication Foundation (WCF) service that allows business partners to place orders. The service uses netMsmqBinding. You find that processing every order in its own transaction is causing a delay. You need to ensure that the service is configured to process multiple orders in one transaction. What should you do? （）A、Use service behavior and set the maxConcurrentCalls attribute.B、Use endpoint behavior and set the maxBatchSize attribute.C、Use endpoint behavior and set the maxPendingReceives attribute.D、Use endpoint behavior.
考题
单选题You are maintaining your OLTP database in Oracle10g. You are performing the Flashback Transaction Query to find the undo SQL statements that can be used to undo the changes made to the database in the specific time period. Which pseudocolumn will you use to perform the Flashback Transaction Query？（）A
VERSIONS_STARTSCNB
VERSIONS_STARTTIMEC
VERSIONS_XIDD
VERSIONS_OPERATION
考题
多选题You administer an online transaction processing (OLTP) system whose database is stored in Automatic Storage Management (ASM) and whose disk group use normal redundancy. One of the ASM disks goes offline, and is then dropped because it was not brought online before DISK_REPAIR_TIME elapsed. When the disk is replaced and added back to the disk group, the ensuing rebalance operation is too slow. Which two recommendations should you make to speed up the rebalance operation if this type of failure happens again?（）AIncrease the value of the ASM_POWER_LIMIT parameter.BSet the DISK_REPAIR_TIME disk attribute to a lower value.CSpecify the statement that adds the disk back to the disk group.DIncrease the number of ASMB processes.EIncrease the number of DBWR_IO_SLAVES in the ASM instance.
考题
单选题While designing the database for one of your online transaction processing （OLTP） applications， you want to achieve the following： a） high availability of data b） faster primary key access to the table data c） compact storage for the table Which type of tables would you use to achieve these objectives？（）A
heap tablesB
object tablesC
partitioned tablesD
index-organized tables （IOTs）
考题
单选题You want to use the Flashback Transaction Query feature to identify all the changes made to your database within a specific time period. What is a prerequisite for using the Flashback Transaction Query feature？（）A
You must use automatic undo management in the database.B
You must configure OMF in your database.C
You must configure ASM for storing the datafiles.D
You must multiplex the online redo log file.
考题
单选题You are working on an online transaction processing （OLTP） system. You notice that a PL/SQL procedure got executed twice at 2） 00 p.m. This has incorrectly updated the EMP_SAL table. How would you revert the table to its state at 2） 00 p.m.？（）A
Perform point-in-time recovery to 2： 00 p.m.B
Use Flashback Table feature to revert the changes.C
Restore the entire database from the recent backup and open it.D
Issue the rollback statement with system change number （SCN）.
考题
单选题While designing the database for one of your online transaction processing （OLTP） applications， you want to achieve the following： a） high availability of data b） faster primary key access to the table data c） compact storage for the table Which type of tables would you use to achieve these objectives？（）A
heap tablesB
object tablesC
partitioned tablesD
indexorganized tables （IOTs）
考题
单选题In one of your online transaction processing （OLTP） applications， most users frequently modify the values， including the key values， of the application tables. Some users generate application reports by using multiple application tables. What is the best table structure that you can use to gain optimal performance？（）A
Heap tableB
Object tableC
External tableD
Clustered tableE
Global temporary tableF
Index-organized table （IOT）
考题
单选题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 recoveryB
perform a Flashback Table operation to restore the table to the state it was in two days agoC
perform a Flashback Database operation to restore the database to the state it was in two days agoD
perform Flashback Versions Query and Flashback Transaction Query to determine all the necessary undo SQL statements， and then use them for recovery
考题
单选题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 EMPLOYEES table. 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 recoveryB
perform a Flashback Table operation to restore the table to the state it was in two days agoC
perform a Flashback Database operation to restore the database to the state it was in two days agoD
perform Flashback Versions Query and Flashback Transaction Query to determine all the necessary undo SQL statements， and then use them for recovery
考题
单选题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.
考题
单选题In one of your online transaction processing （OLTP） applications， users are manipulating and querying a database table simultaneously. From the Segment Advisor， you find that one of the tables is highly fragmented and you want to shrink the table immediately without affecting the currently active queries. Which option would you use with the ALTER TABLE command to achieve this objective？（）A
REBUILDB
CASCADEC
TRUNCATED
ROW MOVEMENTE
SHRINK SPACE COMPACTF
SHRINK SPACE CASCADE
考题
单选题Your database supports an online transaction processing (OLTP) application. The application is undergoing some major schema changes, such as addition of new indexes and materialized views. You want to check the impact of these changes on workload performance. What should you use to achieve this?（）A
Database replayB
SQL Tuning AdvisorC
SQL Access AdvisorD
SQL Performance AnalyzerE
Automatic Workload Repository compare reports
考题
单选题You are working in an online transaction processing （OLTP） environment. You used the FLASHBACK TABLE command to flash back the CUSTOMERS table. Before executing the FLASHBACK TABLE command， the System Change Number （SCN） was 663571. After flashing back the CUSTOMERS table， you realize that the table is not in the correct state and the resultant changes are not what you had desired. So， you need to reverse the effects of the FLASHBACK TABLE command while ensuring that： a） No other user data in the database is affected. b） The operation takes the minimum possible time. Which option would you choose？（）A
Use ROLLBACK command with SCN 663571.B
Perform Flashback Transaction Query with SCN 663571.C
Execute the FLASHBACK DATABASE statement to retrieve the CUSTOMERS table as it was at SCN 663571.D
Execute another FLASHBACK TABLE statement to retrieve the CUSTOMERS table as it was at SCN 663571.
考题
单选题In which situation would you use the Oracle Shared Server configuration？（）A
when performing export and import using Oracle Data PumpB
when performing backup and recovery operations using Oracle Recovery ManagerC
when performing batch processing and bulk loading operation in a data warehouse environment D
in an online transaction processing （OLTP） system where large number of client sessions are idle most of the time
热门标签
最新试卷