Study tips 1Z0-040

Quiz 1Z0-040 , Oracle Database 10g: New Features for Administrators

How do you recover the data file?

Which file is the appropriate way to perform this task?

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

Which two statements are correct regarding the mytbs tablespace?

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

Which four initialization parameters will be tuned automatically?

In which three cases should you collect statistics manually?

Which four statements regarding the block change track file are correct?

Where would you fund the information about cleared alerts?

Which data dictionary view would you query to find the name of the default permanent tablespace of the database?