Online Access Free 1Z0-025 Practice Test

The instance crashed after the current online redo-log becomes corrupt. Which action can the DBA take to open the database?

• A.Perform a complete recovery of the database.
• B.Perform a time-based recovery that stops at the time that the current online redo-log became corrupt.
• C.Recover the SYSTEM tablespace.
• D.Perform a tablespace recovery.
• E.Skip recovery and open the database with the RESETLOGS option.

Which type of tablespace point-in time recovery method needs to be performed if the recreated database is on a separate machine?

• A.EBU
• B.Use of transportable tablespaces.
• C.RMAN
• D.Operating system.

Which RECOVER command is appropriate when, while recovering a lost data file, a DBA discovers that a required, archived redo-log is corrupted?

• A.RECOVER DATABASE UNTIL CANCEL;
• B.RECOVER TABLESPACE system UNTIL CANCEL;
• C.RECOVER DATABASE USING BACKUP CONTROLFILE;
• D.RECOVER DATABASE UNTIL MISSING REDOLOG;
• E.ALTER TABLESPACE system RECOVER;

What are two causes of a user process failure? (Choose two)

• A.There is a head crash on the disk containing a database file.
• B.The application program receives an addressing exception.
• C.The user issues an abnormal interrupt.
• D.A table is accidentally truncated.
• E.There is a logic error in the application.

When configuring a database for ARCHIVELOG mode, you use initialization parameter to specify which two actions? (Choose two)

• A.Where log files will be archived.
• B.The size of archived log files.
• C.The names that will be given to archived log files.
• D.How frequently log files will be archived.