1z0-033 Oracle - Braindumps.com.ua: список вопросов для "Oracle9i:Performance Tuning", страница: 3

Профиль

Бреиндампы

Получить последний дамп

Форумы

Продавец

Linux Prof Institute (LPI) (2)

Lotus (11)

Microsoft (2462)

Network Appliance (2)

Авторизация

Логин:
Пароль:
запомнить меня:

Контакты
Сайты по тематике
Cсылки

Авторизированые пользователи могут видеть ответы к вопросам.
Пожалуйста, авторизируйтесь или зарегистрируйтесь.

Список вопросов к экзамену:
Показать все комментарии

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]

ген. 0.067

Дата сервера 11:57 09-01-2009

Oracle 1z0-033