Quiz 1Z0-045

Quiz 1Z0-045, Oracle Database 10g DBA New Features for Oracle8i OCPs

Which action would you consider to overcome the performance degradation?

Which file is the appropriate way to protect the database against failures by adding one more control file?

How do you recover the data file belonging to the SYSTEM tablespace?

In order to achieve the objective, which component would you configure on each database server?

Which two steps are performed the first time any UPDATE statement is issued after the instance is started?

Which two statements are correct regarding the mytbs tablespace?

Which two new features of the Oracle 10g database could you use to automate this task?

In which three cases should you collect statistics manually?

Which four initialization parameters will be tuned automatically?

Which two structures can you select?