1Z0-030 Oracle9i: New Features for Administrators Certification Exam

Demo Question 11.

You word for a manufacturing company that frequently runs its production lines 24 hours a day. The accounting department is working with the development staff on plans to create an application to track manufacturing costs at the shop floor level. As a senior DBA, you have been assigned the task of ensuring that the new application will run with sub-second response time as information is entered into the application via terminals installed in the manufacturing area. Daily, weekly and monthly reports will also be run overnight detailing the previous period's activity. The reports must run during a time of high user interaction with the database. Choose two tasks that you should perform to make sure that the new application meets its sub-second response time requirement. (Choose two.)

A. Help design the screen layout used to input the data into the application.
B. Help with the design of the tables used in the application to guarantee that every table is normalized to the third normal form for good relational design. 1Z0-031
C. Use performance-monitoring tools to gather information about the current workload on the system and again later while testing the application to identify potential bottlenecks within the database.
D. Help with the design of the tables used in the application to guarantee that every table is normalized to the third normal form for good relational design, and then de-normalize the tables as necessary to achieve the best performance of the application.


Display Answer

Answer: C, D

Explanation: