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

Профиль

Бреиндампы

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

Форумы

Продавец

Linux Prof Institute (LPI) (2)

Lotus (11)

Microsoft (2462)

Network Appliance (2)

Авторизация

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

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

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

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

Oracle 1z0-033: Oracle9i:Performance Tuning

#101. Which task can be accomplished by using the ALTER INDEX...COALESCE or REBUILD command?

#102. You executed the following query to view the status of a materialized view:

 SQL> SELECT mview_name, rewrite_capability, refresh_method FROM user_mviews;

 MVIEW_NAME      REWRITE_CAPABILITY     REFRESH_METHOD 
       ITMV               TEXTMATCH              FORCE

Which statement is true regarding the rewrite and refresh mechanism?

#103. You configured your database to run in Shared Server mode. You did not configure the large pool by using the LARGE_POOL_SIZE parameter. Which memory component would be used to store users’ session information?

#104. You moved your test database to the production environment. As a performance measure, you want to create a performance baseline for the production database that would have general performance statistics, SQL plans and usage, segment-level statistics, and parent and child latches. Which option would you use to create the baseline?

#105. Which two statements are correct regarding stored outlines? (Choose two.)

#106. What provides the information about the free extents in a temporary tablespace before a sort operation?

#107. You execute the following command as part of copying statistics to another database:

 SQL> EXECUTE DBMS_STATS.EXPOPT_TABLE_STATS(’SCOTT’, ’EMP’, NULL, ’STATS’, 
 NULL, TRUE);

Which two options are correct recommendations that must be implemented before performing this step? (Choose two.)

#108. Exhibit:

View the Exhibit and examine the steps to create a database resource plan. Execution of the following procedure resulted in an error:
SQL> EXECUTE dbms_resource_manager.validate_pending_area();
What could be the reason for this?

#109. In your database, you executed the following command to monitor the mdi index:

 SQL> SELECT lf_rows, del_lf_rows, del_If_rows_len, If_rows_len FROM INDEX_STATS 
 2 WHERE NAME = ‘IND1’;

 LF_ROWS   DEL_LF_ROWS    DEL_LF_ROWS_LE    NLF_ROWS_LEN 
      14             0                 0             202

After this, the table is updated by a large transaction. Now, you want to check the index statistics. What would you do to update the INDEX_STATS view with the latest statistics?

#110. Users in your production database complain that DMLs on an application table, ORDERS, is slow. You suspect the locking to be causing the contention and queried the V$LOCK dynamic performance view. While querying, you observe that the table is locked with lock type as TM but currently, there are no transactions or queries that are accessing the table. What could have caused the table to be locked?

[1] ... [11] [12] [13] [14] [15] [16] [17]

ген. 0.077

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

Oracle 1z0-033