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

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

#51. You have the following outcome from the V$SYSSTAT view:

 SQL> SELECT name, VALUE FROM v$sysstat WHERE name = ‘TABLE FETCH continued ROW’;

 NAME                         VALUE 
 table fetch continued row      308

What action would you take to have control of this value in the future?

#52. You have reserved memory within the Shared Pool by using the SHARED_POOL_RESERVED_SIZE parameter to accommodate large space allocations while compiling PL/SQL blocks and database triggers. While observing the performance of the reserved area, you find that the value of the REQUEST_FAILURES column in the V$SHARED_POOL_RESERVED view is continuously increasing. Which statement is true in this scenario?

#53. You executed the following query on the V$SYSTEM_EVENT view:

 SQL> SELECT event, total_waits, time_waited 
 FROM v$system_event;

The result of this query displays the total waits and time waited for events as shown in the Exhibit. View the Exhibit.

The query provides the total waits and time waited for the events of _____

#54. The buffer cache advisory feature is off in your database. You execute the following command to enable the Buffer Cache advisory feature in the database instance:

  SQL> ALTER SYSTEM SET DB_CACHE_ADVICE = ON;

After executing the command, you receive the following error
ORA-04031: unable to allocate shared memory.
What could be the reason for this error?

#55. Which three techniques should a DBA use to reduce the overhead on library cache? (Choose three.)

#56. You executed the following query to know about users and their consumer groups:

  SQL> SELECT * FROM DBA_RSRC_CONSUMER_GROUP_PRIVS;

 GRANTEE               GRANTED_GROUP       GRANT_OPTION     INITIAL_GROUP 
   SCOTT                   LOW_GROUP                 NO                NO 
  PUBLIC                   LOW_GROUP                 NO                NO 
  PUBLIC      DEFAULT_CONSUMER_GROUP                YES               YES 
  SYSTEM                   SYS_GROUP                 NO               YES

If the user SCOTT starts a session, to which consumer group will the session belong?

#57. You executed the following command to observe the index statistics:

 SQL> SELECT name, height, blocks, If_rows, del_If_rows, If_blks, distinct_keys 
 2 FROM index_stats 
 3 WHERE name=’CUIND’;

 NAME HEIGHT BLOCKS LF_ROWS DEL_LF_ROWS LF_BLKS DISTINCT_KEYS 
 CUIND 2 24 8192 4096 18 32

Which statement is true regarding the CUIND index?

#58. In your database, Smith and John work on the HR schema. They connect to the HR schema and update the dept table simultaneously from their respective sessions:
Smith’s session:

 SQL> UPDATE dept SET deptno=60 WHERE loc=’NEW YORK’;

1 row updated.
John’s session:

 SQL> UPDATE dept SET deptno=80 WHERE loc=’BOSTON’;

In Smith’s session, the UPDATE statement is successful whereas in John’s session the UPDATE statement is waiting for Smith to complete his transaction. What could be the reason for this?

#59. You receive complaints from users regarding the high waiting time for their transactions. On investigation, you find that some users are not committing their transactions even though their sessions do not perform any activity for a long time.
Which strategy would prevent this locking problem?

#60. A customer has various dictionary-managed tablespaces with past data. The extents in dictionary-managed tablespaces are not uniformly sized. Newly created tablespaces are locally managed. You want to make all the tablespaces locally managed. What approach would you use to change the dictionary-managed tablespaces to locally managed tablespaces to get all the performance benefits of local extent management?

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

gen. 0.093

Server date 05:37 02-12-2008

Oracle 1z0-033

Forum

Start online exam simulation

Master braindump

User braindumps