1z0-033 Oracle - Braindumps.com.ua: question list for "Oracle9i:Performance Tuning", page: 3

Add to favorites

Profile

Registration

Braindumps

Master braindump list

Forums

Vendor

Linux Prof Institute (LPI) (2)

Lotus (11)

Microsoft (2461)

Network Appliance (2)

Authorization

Login:
Password:
remember me:

Contacts
Certification links
Links

Authorized user can see question and answers.
Please log in or sign up.

Exam question list:
Show all comments

Oracle 1z0-033: Oracle9i:Performance Tuning

#21. Your database is running in Shared Server mode. You have set the LARGE_POOL_SIZE parameter to 1 MB. While the database is functioning, you realize that the large pool is running out of space because of the increasing number of user requests. What will the effect be if there is no more free space left in the large pool to store new information?

#22. 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 seconds or less. What is the first thing that Smith should do to diagnose the cause of the slow response time?

#23. View the Exhibits and compare the baseline and current Load Profile statistics in the statspack report.

The customer had collected baseline statistics by using statspack six months ago. The customer is facing performance issues and you have collected the current statistics. Which option would you use on the basis of Load Profile statistics to improve the performance?

#24. You have many users complaining about slow inserts into a large table. While investigating the reason, you find that the number of indexes on the table is high. You want to find out which indexes are not being used. Which method would you follow to achieve this?

#25. In the parameter file of your production database, the LOG_CHECKPOINT_INTERVAL parameter is set to 3600. When does the checkpoint occur due to this setting?

#26. Which three types of objects can you keep in the shared pool by using the dbms_shared_pool.keep procedure? (Choose three.)

#27. After monitoring the Shared Server environment, you decided to increase the number of Shared Servers available for use by the database by increasing the value of the initialization parameter MAX_SHARED_SERVERS. Which condition requires this change in the parameter value?

#28. You executed the following query:

 SQL> SELECT department_name, last_name 
 FROM employees E, departments D 
 WHERE E.department_id=D.department_id;

The EMPLOYEES and DEPARTMENTS tables have no indexes and the HASH_JOIN_ENABLED parameter is set to false. From the following list of actions, select the correct sequence on the basis of the order of their execution:
1) Sort each row sources separately
2) Perform full tablescans of EMPLOYEES and DEPARTMENTS tables
3) Merge the sorted sources

#29. Oracle Shared Server is best used when _____ and _____ (Choose two.)

#30. While querying the V$WAITSTAT data dictionary view, you find that the COUNT and TIME is very large for the class SEGMENT HEADER. How would you describe this problem?

[1] [2] [3] [4] [5] [6] [7] [8] [9] [10] [11] ... [17]

gen. 0.085

Server date 05:43 02-12-2008

Oracle 1z0-033

Forum

Start online exam simulation

Master braindump

User braindumps