1Z0-025 무료 덤프문제 온라인 액세스

If a DBA restores a read-only tablespace from a backup taken before the tablespace was made read-only, what must the DBA do next?

• A.Make the tablespace locally-managed.
• B.Complete media recovery.
• C.After the tablespace to become read-only.
• D.Recreate the control file.

Which action does a DBA take when using a backup control file?

• A.No special action is required.
• B.Includes UNTIL CANCEL in the RECOVER command.
• C.Includes USING BACKUP CONTROLFILE in the RECOVER command.
• D.Issues the RECOVER CONTROLFILE command before recovering the database.

You have determined that one of the data files belonging to the SYSTEM tablespace is corrupt. Which complete media recovery scenario do you choose?

• A.Complete recovery - opened database, initially opened.
• B.Complete recovery - mounted database.
• C.You cannot recover from the corruption of a database file belonging to the SYSTEM tablespace except by going back to the last full backup.
• D.Complete recovery - opened database, initially closed.

What must a DBA do after using NOLOGGING operations on a primary database?

• A.Make sure the database is the only primary database in the current configuration.
• B.Manually reapply the changes to the standby database.
• C.Copy all affected data files to the standby server.
• D.Switch log files on the primary database.

Consider the following scenario using incremental backups. A level 1 backup is taken on the first of the month. A level 2 backup is taken in every Sunday, and a level 3 backup is taken daily. If the database gets corrupted on the second Wednesday of the month and is lost, which scenario would restore the database completely?

• A.A base level backup (level 0) is missing and nothing can be recovered.
• B.The weekly backup (level 2) and the daily backup (level 3).
• C.The monthly backup (level 1), the weekly backup (level 2) and the daily backup (level5)
• D.The monthly backup (level 1) and the daily backup (level 3).