REBUILD
CASCADE
TRUNCATE
ROW MOVEMENT
SHRINK SPACE COMPACT
SHRINK SPACE CASCADE
第1题：
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 replay
B. SQL Tuning Advisor
C. SQL Access Advisor
D. SQL Performance Analyzer
E. Automatic Workload Repository compare reports
第2题：
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？（）
第3题：
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.()
第4题：
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？（）
第5题：
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？（）
第6题：
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？（）
第7题：
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？（）
第8题：
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
B. Use
C. Use
D. Use
第9题：
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？（）
第10题：
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？（）