QUESTION 101
You lost the index tablespace in your database. You are not able to use tablespace point-in-time recovery on the index tablespace. What could be the reason for this?

A.    The index tablespace contains bitmap indexes.
B.    The index tablespace contains more than one data file.
C.    The index tablespace supports only complete recovery.
D.    The index tablespace is not a dictionary-managed tablespace.
E.    There is a dependency relationship between a table and its indexes.

Answer: E

QUESTION 102
For 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?

A.    Set the CPU time per call in the users profile.
B.    Set the CPU time per session in the users profile.
C.    Set the CPU levels for the user’s group using Resource Manager.
D.    Set the TIMED_STATISTICS parameter to TRUE in the parameter file.

Answer: C

QUESTION 103
View the Exhibit and examine the characteristic of the USERS tablespace. You observe that a large volume of inserts and deletes are happening on the TRANS table in the USERS tablespace and you suspect that the TRANS table is fragmented. Which advisory component would you refer to, in order to find information about table fragmentation?
Exhibit:

A.    Memory Advisor
B.    Segment Advisor
C.    SLQ Tuning Advisor
D.    SLQ Access Advisor
E.    Automatic Database Diagnostic Monitor (ADDM)

Answer: B

QUESTION 104
A data file become corrupted in your database due to bad sectors on the disk. Because of corruption, you lost all the important tables in that data file. Which method would you use for recovery?

A.    Flash back all the tables in the data file, one by one.
B.    Restore the data file to a new location and perform a media recovery.
C.    Flash back the database, there is no need to restore the data file.
D.    Restore the data file from the most recent backup and flash the database.

Answer: B

QUESTION 105
For which two SQL statements can you use the Flashback Table feature to revert a table to its previous state? (Choose two)

A.    UPDATE TABLE
B.    CREATE CLUSTER
C.    TRUNCATE TABLE
D.    ALTER TABLE MOVE
E.    INSERT INTO…VALUES
F.    ALTER TABLE…DROP COLUMN
G.    ALTER TABLE…DROP PARTITION

Answer: AE

QUESTION 106
What purpose would you achieve by enabling the block change tracking feature?

A.    Eliminate the necessity for backups.
B.    Perform optimized image copy backups.
C.    Perform optimized incremental backups.
D.    Enable checkpoint (CKPT) to perform checkpointing at every block change.
E.    Enable database writer (DBWn) to write changed blocks to data files faster.

Answer: C

QUESTION 107
You execute the following RMAN command in the order shown below:
BACKUP VALIDATE DATABASE;
BLOCKRECOVER CORRUPTION LIST;
What will these commands do?

A.    Create a backup of the database and recover all corrupted blocks found in the backup.
B.    Run a backup validation and list all the logically corrupt blocks as well as physically corrupt blocks in the database.
C.    Run a backup validation to populate V$COPY_CORRUPTION view, and then list any corrupt blocks recorded in the view.
D.    Run a backup validation to populate V$DATABASE_BLOCK_CORRUPTION view, and then repair any corrupt blocks recorded in the view.
E.    Run a backup validation, repair any corrupt blocks found during the validation process, and then update V$DATABASE_BLOCK_CORRUPTION view to indicate which corrupt blocks have been repaired.

Answer: D

QUESTION 108
In Recovery Manager (RMAN), you have set control file autobackup to ON by using the following command:
CONFIGURE CONTROLFILE AUTOBACKUP ON;
Which two events would cause the control file to be backed up automatically? (Choose two)

A.    A tablespace is taken offline.
B.    The database instance is restarted.
C.    A new data file is added to an existing tablespace.
D.    A successful backup is recorded in the RMAN repository.
E.    The RMAN connection is disconnected from the target database.

Answer: CD

QUESTION 109
You are working on an Oracle Database 10g database. For which purposes would you use the Flashback Transaction Query feature? (Choose all that apply)

A.    To recover a dropped table.
B.    To recover a dropped schema.
C.    To recover data from a truncated table.
D.    To view changes made by all the transactions during a given period of time.
E.    To view changes made by a single transaction during a given period of time.

Answer: DE

QUESTION 110
Consider the following command to add a new disk group called "tdgroupA" with two failover groups:
CREATE DISKGROUP tdgroupA NORMAL REDUNDANCY
FAILOVERGROUP control01 DISK
‘/devices/A1’,
‘/devices/A2’,
‘/devices/A3’
FAILOVERGROUP control02 DISK
‘/devices/B1’,
‘/devices/B2’,
The disk "/devices/A1" is currently a member disk of a disk group by the name "tdgroup1".
Which task would be accomplished by the command?

A.    This command would result in an error because a disk group can have only one failover group.
B.    This command would result in an error because the /devices/A1 disk is a member of another disk group tdgroup1.
C.    A new disk group called tdgroupA will be added with two failover groups and the /devices/A1 disk will get reattached to the new disk group without being detached from the existing one.
D.    A new disk group called tdgroupA will be added with two failover groups and the /devices/A1 disk will be ignored for the new disk group because it is a member of an existing disk group tdgroup1.
E.    A new disk group called tdgroupA will be added with two failover groups and the /devices/A1 disk gets detached from the existing disk group tdgroup1and attached to the new disk group tdgroupA.

Answer: B

Get Passleader New Update Oracle 1Z0-043 Test Questions With Low Cost