Quiz 1z0-042

Quiz 1z0-042, Database 10g Administration I

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

0oradataoracle’You created a tablespace by using this command:CREATE TABLESPACE USERS;Which two statements are true about the USERS tablespace?

Which statement is true in this scenario?

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?

From what point in the redo log does recovery begin and where does it end?

Which is the correct description of the significance of the ORACLE_HOME environmental variable?