OCA OCP Oracle Certification Exam Braindumps

11. ABC Corp. plans to build an online transaction processing (OLTP) system. The company plans to tune all the components during the development life cycle.
From the list given below, identify the order in which the components should be tuned.
A.1, 2, 3, 5, 4
B.1, 3, 2, 4, 5
C.1, 2, 3, 4, 5
D.1, 2, 5, 3, 4

ANSWER: A

12. ABC Corp. has an online transaction processing (OLTP) system that has just gone into production. The system was rigorously tested during the development phases. What is the first recommended activity that the DBA should perform before starting to monitor the performance of the system on a regular basis?
A.running SQL*Trace
B.collecting baseline statistics
C.analyzing indexes and user tables
D.arranging meetings with users once each two weeks to discuss performance

ANSWER: B

 
13. When tuning a database server, which three goals should you focus on? (Choose three.)
A.minimize response time for OLTP users
B.maximize throughput for batch processing
C.minimize response time for batch processing
D.increase load capability for the decision-support systems
E.minimize parallelism for online transaction processing (OLTP) systems

ANSWER: ABD

 
14. Smith is a DBA with ABC Corp. He is in the process of tuning the database. He has received various problem statements from the customers.Identify three appropriately defined problem statements that Smith can use to tune the database correctly. (Choose three.)
A.The system is too slow.
B.Online response is very slow.
C.Sometimes the batch process throws errors.
D.The weekly backup took 30 minutes, and earlier it used to take 5 minutes.
E.The batch process is taking 2 hours, whereas it should take only 30 minutes.
F.The system currently has 100 users. We wish to increase the number of users to 250. The users' response time should not be affected.

ANSWER: DEF

 
15. Smith is a DBA with XYZ Corp. There are 500 data entry users in an online transaction processing (OLTP) environment.The current response time is 15-20 seconds. The company wants the response time to be brought down to 10 secondsorless. What is the first thing that Smith should do to diagnose the cause of the slow response time?
A.determine whether there is contention for locks
B.determine whether the file system is fast enough
C.determine whether more memory needs to be allocated to PGA
D.determine whether more memory needs to be allocated to SGA
E.determine whether the slow response is wait bound or CPU boun

ANSWER: E