Study tips 1Z0-043

Which statement correctly describes the change tracking writer (CTWR) background process?

In which scenarios would you rebuild an index?

You performed an incomplete recovery on your Oracle Database 10g database using the following command:SQL> RECOVER DATABASE2 UNTIL TIME ‘2004-08-05:12:10:03’3 USING BACKUP CONTROLFILE;In which situation would the above recovery be required?

With reference to this scenario, which action should you take?

What would be the impact of this setting?

Which method would you follow to achieve this objective without increasing the overhead of sorting the rows?

In the parameter file of the production database, the following parameters have been specified:DB_CREATE_ONLINE_LOG_DEST_1 = ‘+dg1’DB_CREATE_ONLINE_LOG_DEST_2 = ‘+dg2’What would be the impact of this setting?

With reference to this scenario, if you are not using Recovery Manager (RMAN), which recovery method would you use?

Which two actions could you take to resolve the error and avoid this error in the future?

How would you recover the tablespace?