Study tips 1z0-042

Study tips 1z0-042, Database 10g Administration I

Which statement is true in this scenario?

Which two effects would you see in your database?

After which two operations you should take the backup of control file ?

What is the implication of setting the initialization parameter FAST_START_MTTR_TARGET to 0 in your database?

How would you achieve this?

Total System Global Area 281018368 bytesFixed Size 789000 bytesVariable Size 229635576 bytesDatabase Buffers 50331648 bytesRedo Buffers 262144 bytesORA-00205: error in identifying controlfile, check alert log for more infoWhich view would you query at this stage to investigate this missing control file?

How would you identify the changes in configuration settings, workload profile, and statistics to diagnose the possible causes of the performance degradation?

What effect would this have on space management?

Which two database operations can be performed at the MOUNT stage of database startup?

What is the best method to create the replica?