Category «1Z0-043»

Which option would you choose?

You work as a database administrator at Pass4sures.com. Your database is open andrunning in ARCHIVELOGmode. You take RMANfull backups every Sunday night. OnMonday morning, while querying the user1.employeestable, you receive the following errormessage:01578: ORACLE data block corrupted (file # 5, block # 51) ORA-01110: data file 5:‘/u01/app/oracle/oradata/orcl/example01.dbf’You need to rectify the corruption while ensuring the …

Which two statements regarding flashback logs are true?

You are working on an Oracle Database 10g database. You enabled the FlashbackDatabase feature. Which two statements regarding flashback logs are true? (Choose two.) A.Flashback logs are not archived. B.Flashback logs are maintained in redo log files. C.Flashback logs are maintained in the Flash Recovery Area. D.Flashback logs are used to maintain Flashback Database related …

Which statement is correct regarding the query output?

You executed the following query:SELECT operation, undo_sql, table_nameFROM flashback_transaction_query;Which statement is correct regarding the query output? A.It would return information regarding only the last committed transaction. B.It would return only the active transactions in all the undo segments in the database. C.It would return only the committed transactions in all the undo segments in the …

Which statement is correct regarding the query output?

You executed the following query:SELECT operation, undo_sql, table_nameFROM flashback_transaction_query;Which statement is correct regarding the query output? A.It would return information regarding only the last committed transaction. B.It would return only the active transactions in all the undo segments in the database. C.It would return only the committed transactions in all the undo segments in the …

Consider the following configuration: /devices/D1is a member of disk group dgroup

Consider the following configuration:/devices/D1is a member of disk group dgroup A./devices/D2is a member of disk group dgroupA. /devices/D3is a member of disk group dgroupA. You plan to add a new disk, /devices/D4,to the disk group dgroupA. You execute the following command: SQL> ALTER DISKGROUP dgroupA ADD DISK ‘/devices/D*’; which task would be accomplished by the …

CALC_STATupdates the optimizer statistics for the objects owned by the APPSschem

You work as a database administrator at Pass4sures.com. In your production databasethere is a job, CALC_STAT, which has been scheduled to run every Friday at 5.00 p.m.CALC_STATupdates the optimizer statistics for the objects owned by the APPSschem A.You want the task to be generic, thereby allowing users to modify the attributes of the task at …

Which two activities could you perform to maintain a consistent performance of the database while adding or re

Immediately after adding a new disk to or removing an existing disk from an AutomaticStorage Management (ASM) instance, you find that the performance of the databasedecreases initially, until the addition or removal process is completed. Performance thengradually returns to normal levels. Which two activities could you perform to maintain aconsistent performance of the database while …

which recovery method would you use?

The current time is 12:00 noon. You want to recover the USERS tablespace from a failurethat occurred at 11:50A.m. You discover that the only member of an unachieved redo log group containinginformation from 11:40 A.m. onwards is corrupt. With reference to this scenario, if you arenot using Recovery Manager (RMAN), which recovery method would you …

How would you recover the tablespace?

You lost the PRODSTD tablespace, which was read/write. The tablespace was read-onlywhen the last backup was performed. How would you recover the tablespace? A.restore the tablespace from the backup; there is no need to apply the redo information B.restore the full database to recover the data up to the point when you performed the backup …