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

Профиль

Бреиндампы

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

Форумы

Продавец

Linux Prof Institute (LPI) (2)

Lotus (11)

Microsoft (2461)

Network Appliance (2)

Авторизация

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

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

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

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

Oracle 1z0-033: Oracle9i:Performance Tuning

#1. Which statements are true regarding configuring multiple buffer pools in the Database Buffer Cache that is using only the standard block size? (Choose all that apply.)

#2. 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.)

#3. You execute the following query to check resource consumption in the current plan used by the database:

 SQL> SELECT name, active_sessions, requests, queue_Iength, current_undo_consumption 
“UNDO CONSUMPTION” FROM V$rsrc_consumer_group;

 NAME          ACTIVE_SESSIONS      REQUESTS      QUEUE_LENGTH     UNDO CONSUMPTION 
 OTHER_GROUPS                1             1                 0                    0 
 GROUP1                      2             4                 2                    0

Which statement is correct when a user belonging to GROUP1 tries to start a session?

#4. You require that a warning is written to a trace file without impacting the application when the session’s Java state exceeds 2GB. Which parameter would you modify?

#5. You use the following query to monitor the Shared Servers:

 SQL>SELECT maximum_connections “MAX CONN”, servers_started “STARTED”, servers_terminated 
“TERMINATED”, servers_highwater “HIGHWATER” FROM v$shared_server_monitor;

 MAX CONN    STARTED    TERMINATED     HIGHWATER 
        3          6             6             3

With every execution, you observe that the values of the STARTED and TERMINATED columns are growing quickly. What action would you take?

#6. As part of the performance-tuning activity, you executed the utllockt.sql script. What does this script do? (Choose all that apply.)

#7. Which two statements are valid regarding row migration? (Choose two.)

#8. While tuning the shared server in your database, you executed the following command:

 SQL> ALTER SYSTEM SET DISPATCHERS = ‘(PROTOCOL=TCP)(DISPATCHERS=5)’;

How does this statement affect the shared server configuration? (Choose two.)

#9. Which two actions could you perform to reduce busy buffer waits caused on segment header blocks? (Choose two.)

#10. In an online transaction processing (OLTP) system, which is configured in shared server mode, you execute the following query to examine the sort performance:

 SQL> SELECT d.VALUE “Disk”, m.VALUE “Mem”, (d.VALUE/m.VALUE)*100 “Ratio” 
FROM v$sysstat m, v$sysstat d WHERE m.name=’sorts (memory)’ AND d.name=’sorts (disk)’;

 Disk      Mem      Ratio 
   23      206      11.165049

What action would you take after observing the output?

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

ген. 0.094

Дата сервера 14:20 20-11-2008

Oracle 1z0-033