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

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

#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]

gen. 0.195

Server date 02:14 20-11-2008

Oracle 1z0-033

Forum

Start online exam simulation

Master braindump

User braindumps