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 four initialization parameters will be tuned automatically?

In which three cases should you collect statistics manually?

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 data dictionary view would you query to find the name of the default permanent tablespace of the database?

Which three statements regarding the properties of a temporary tablespace group are correct?

Which two structures can you select?