Which three statements about media recovery are correct? (Choose three.)
Media recovery is used when you accidentally drop a tablespace.
Media recovery brings your database to a transactionally consistent state when it is opened.
Point-in-time media recovery returns your database to its state at a specified time in the past.
Media recovery requires an SPFILE, datafiles, and all archived redo logs from the time the datafiles were backed up.
Media recovery is performed by the DBA when the DBA tries to open the database after restoring the archived redo logs and the datafiles from a backup.
Complete media recovery restores your database from image copies of the datafiles and returns the database to its state at the time of failure.