Free Oracle 1Z0-025 Exam Dumps Questions & Answers

Which two benefits do the command?
ALTER DATABASE MOUNT CLONE DATABASE
Offer for the tablespace point-in-time recovery? (Choose two)

• A.It allows the POINT_IN_TIME_RECOVERY option on the export to function.
• B.It allows the export to recover statistics on the tables.
• C.It prevents accidental corruption of the primary database.
• D.It allows you to remove a data file that has been added to the wrong tablespace.
• E.It allows the SYSTEM tablespace to become a transportable tablespace.

What is the difference between using NOLOGGING operations in a single database environment and a standby database environment?

• A.NOLOGGING operations can be used on the standby database, but not on the primary database.
• B.The standby database becomes unavailable after a NOLOGGING operation has been used on the primary database.
• C.NOLOGGING operations are not allowed when using a standby database.
• D.The affected data file needs to be copied from the primary to the standby server.

Which statement about an open database backup is NOT true?

• A.The database is available for use during backups.
• B.All the database files copied are consistent to a point-in-time.
• C.An operating system backup of the database files is required.
• D.The database must be available in ARCHIVELOG mode.

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

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

Which command creates a text backup of the control file?

• A.ALTER DATABASE BACKUP CONTROLFILE TO TRACE;
• B.ALTER DATABASE BACKUP CONTROLFILE TO BACKUP;
• C.ALTER DATABASE BACKUP CONTROLFILE TO 'filename'
• D.ALTER DATABASE BACKUP CONTROLFILE TO TEXT 'filename'