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?
Which two system privileges or roles enable you to access the database instance even when the database is not open? (Choose two.)