Oracle-Database-10g-Administration-II-(1Z0-043).pdf -...

This preview shows page 1 - 5 out of 14 pages.

1Z0-043 Oracle Oracle Database 10g: Administration II
QUESTION: 172 You lost the index tablespace in your database. You decided to re-create the index tablespace and the indexes in the tablespace. What methods can you use to re-create the indexes? (Choose all that apply.) A. SQL scripts B. Recovery Manager (RMAN) script C. Data Pump D. SQL*Loader E. Flashback database Answer: A, C QUESTION: 173 From the V$SESSION_LONGOPS view, you find that some of the database users have long-running queries that consume a lot of CPU time. This causes performance problems for other users in the database, who have much shorter queries. You would like to make sure that the users with large queries do not use all the CPU time, but you still do not want to terminate them with an error message. Which method would you follow to achieve this? D QUESTION: 174 You noticed that large memory allocations for the Oracle backup and restore operations are causing a performance overhead on the shared pool. Which memory structure would you configure to avoid this performance overhead? 75
B QUESTION: 175 In your Automatic Storage Management (ASM) instance, one of the nonempty disk groups, DGROUP1, is no longer required and you want this disk group to be removed. You executethe following command to achieve this objective: DROP DISKGROUP dgroup1 EXCLUDING CONTENTS; What would be the result of this command? A QUESTION: 176 View the Exhibit and examine the properties of the USERS tablespace. You execute the following statement to shrink the TRANS table existing on the USERS tablespace: SQL> ALTER TABLE trans SHRINK SPACE CASCADE;Which objects would be affected by this command? (Choose all that apply.) Exhibit: A. the materialized views based on the TRANS table B. the materialized views log of the TRANS table C. the TRANS table 76
D. the B*Tree indexes on the TRANS table E. the large object (LOB) segments of the TRANS table Answer: C, D

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture