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? (Choose four.)
Which four options represent the features of Oracle Undo Advisor? (Choose four.)
Which three statements about media recovery are correct? (Choose three.)
Which four options would you specify while creating a table using Enterprise Manager? (Choose four.)
Which three components comprise a relational database model? (Choose three.)
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? (Choose two.)
A control file has been accidentally deleted. What happens when you try to start an instance and connect to the database?
You are installing Oracle10g on Linux operating system. Which two scripts would you need to run as user root? (Choose two.)