In the parameter file of your production database, the FAST_START_MTTR_TARGET parameter is set to 300 to optimize instance recovery. While observing the performance of the database during instance recovery, you find that the redo log files are not sized properly to support this activity. Which two sources could you use to determine the optimal size of the redo log files? (Choose two.)
A. the V$LOG view
B. the V$DBFILE view
C. the V$LOGFILE view
D. the V$INSTANCE_RECOVERY view
E. Oracle Enterprise Manager Database Control
Why would you use the following FLASHBACK TABLE command? FLASHBACK TABLE emp TO TIMESTAMP (’11:45′,’hh12:mi’);
A. to undo the changes made to the EMP table since the specified time
B. to restore the EMP table that was wrongly dropped from the database
C. to view the transactions that have modified the EMP table since the specified time
D. to view the changes made to the EMP table for one or more rows since the specified time
What effect should the loss of an index tablespace have on an Oracle instance that is running?
A. instance hangs
B. instance gets aborted
C. instance continues running
D. instance gets restarted automatically
By using the transaction identifier provided by ______ for a particular row change, you can use the Flashback Transaction Query to see the operation performed by the transaction.
A. Flashback Table
B. Flashback Database
C. Flashback Version Query
D. The RMAN REPORT command
E. The DBA_PENDING_TRANSACTIONS view
You work as a database administrator at certkiller.com. Manually, you set the consumer group of all of the newly created users to MYDB_GRP. You want the users to be able to change their consumer groups as per the application requirement.
What was the first step that was needed in the process to achieve this objective?
A. The user must have been granted the DBA role.
B. The user must have been granted the switch privilege as a part of a role.
C. The user must have been granted the Resource Manager administrator privilege.
D. The user must have been granted the switch privilege by using the DBMS_RESOURCE_MANAGER_PRIVS package.
While setting up the threshold for tablespace space usage metrics for one of your tablespaces, you define the critical threshold as 60% and warning threshold as 75%. What would be the result of this setting?
A. It would result in an error because the warning threshold cannot be more than the critical threshold.
B. The warning threshold is ignored and alerts would be generated when space usage exceeds the critical threshold.
C. The critical threshold is ignored and alerts would be generated when space usage exceeds the warning threshold.
D. Both threshold values are used and alerts are generated when space usage exceeds the respective threshold values.
You have created a resource plan, DB_PLAN, using DBMS_RESOURCE_MANAGER.CREATE_SIMPLE_PLAN and you want to impose a restriction on utilization of resources by the database users. Which step must be performed before you can start using the resource plan?
A. assign users to consumer groups
B. set the resource plan for the instance
C. configure a simple resource plan and specify plan directives
D. configure a complex resource plan and specify plan directives
You are performing a block media recovery on the tools01.dbf data file in the SALES database using RMAN. Which two statements are correct in this scenario? (Choose two.)
A. You must ensure that the SALES database is mounted or open.
B. You must restore a backup control file to perform a block media recovery.
C. You must take the tools01.dbf data file offline before you start a block media recovery.
D. You must put the database in NOARCHIVELOG mode to perform a block media recovery.
E. You can perform only a complete media recovery of individual blocks, point-in-time recovery of individual data blocks is not supported.
View the Exhibit.
You executed the following command to perform a backup of the USERS tablespace:
RMAN>BACKUP TABLESPACE USERS;
Which type of backup would this command perform?
A. backup set
B. image copy
C. incremental backup
D. None; the user receives on error indicating that the backup must be specified.
In your database, online redo log files are multiplexed and one of the members in a group is lost due to media failure? How would you recover the lost redo log member?
A. import the database from the last export
B. restore all the members in the group from the last backup
C. drop the lost member from the database and then add a new member to the group
D. restore all the database files from the backup and then perform a complete recovery
E. restore all the database files from the backup and then perform an incomplete recovery
Get Passleader New Update Oracle 1Z0-043 Test Questions With Low Cost