Exam information

Exam 1Z0-041, Oracle Database 10g: 2 Day DBA Assessment Exam

Other exams

Which statement represents the Segment Advisor’s feature?


A long running query to a database fails to execute because the undo records for this query have been overwritten. Which two of these options provide a solution to this problem? (Choose two.)Which statement represents the Segment Advisor’s feature?

Which four statements represent features of the segment shrink operation?

Which four statements represent features of the segment shrink operation? (Choose four.)

Which four options represent the features of Oracle Undo Advisor?

Which four options represent the features of Oracle Undo Advisor? (Choose four.)

Which three statements about media recovery are correct?

Which three statements about media recovery are correct? (Choose three.)

Which four options would you specify while creating a table using Enterprise Manager?

Which four options would you specify while creating a table using Enterprise Manager? (Choose four.)


Which three components comprise a relational database model?

Which three components comprise a relational database model? (Choose three.)

If you want the Oracle server to manage the size of the SGA dynamically on its own, then which option would be the solution?

You manually configured the System Global Area (SGA). If you want the Oracle server to manage the size of the SGA dynamically on its own, then which option would be the solution?

Which two methods can you use to proactively monitor the workload and database state?

Which two methods can you use to proactively monitor the workload and database state? (Choose two.)

What happens when you try to start an instance and connect to the database?

A control file has been accidentally deleted. What happens when you try to start an instance and connect to the database?

Which two scripts would you need to run as user root?

You are installing Oracle10g on Linux operating system. Which two scripts would you need to run as user root? (Choose two.)

Page 1 of 712345...Last »