Category «1Z0-063»

Exam 1Z0-063: Oracle Database 12c Advanced Administration (update February 06th, 2018)

Which three types of backups can be performed for a database running in NOARCHIVELOG mode?

Which three types of backups can be performed for a database running in NOARCHIVELOG mode? A. consistent whole database backup B. backup of noncritical tablespaces without shutting down the instance C. backup of the database without shutting down the instance D. backup of only those blocks that have changed since the last backup while database …

Which statement is true about the DUPLICATE command?

Examine the RMAN commands:RMAN> CONNECT TARGET “sbu@prod AS SYSBACKUP”;RMAN>CONNECT AUXILIARY “sbu@dup_db AS SYSBACKUP”;RMAN >DUPLICATE TARGET DATABASE TO dup_dbFROM ACTIVE DATABASEPASSWORD FILESECTION SIZE 400M;Which statement is true about the DUPLICATE command? A. It fails because there is no connection to a recovery catalogue. B. It fails because no parallel channels are allocated for the auxiliary database. …

Which statement is true?

You use RMAN to take regular backups for your database.Examine the RMAN commands:RMAN> CROSSCHECK BACKUP;RMAN>DELETE EXPITED BACKUP;Which statement is true? A. All backups and archived redo log files that are not required for the recovery are deleted and the repository is updated. B. All metadata, for backups and archived redo log files that are recorded …

Which action should you perform?

You are performing regular backups of your production database by using a recovery catalog.You add two new tablespaces to your production database after performing a backup. They must be included infuture backups.Which action should you perform? A. Synchronize the recovery catalog with the target database control file. B. Create a new database incarnation record. C. …

What happens at the next log switch?

Your database is running in archivelog mode. Examine the parameters for your database instance:LOG_ARCHIVE_DEST_l =’LOCATION=/disk1/arch MANDATORY’LOG_ARCHIVE_DEST_2 =’LOCATION=/disk2/arch’LOG_ARCHIVE_DEST_3 =’LOCATIO=/disk3/arch’LOG_ARCHIVE_DEST _4 =’LOCATIONs/disk4/arch’LOG_ARCHIVE _MIN_SUCCEED_DEST = 2While the database is open, you notice that the destination set by the log_archive_dest_1 parameter is notavailable. All redo log groups have been used.What happens at the next log switch? A. The database …

Which two operations are NOT performed by the DUPLICATE command in RMAN while duplicating a database that is open?

Which two operations are NOT performed by the DUPLICATE command in RMAN while duplicating a databasethat is open? A. creating a control file for the duplicate database B. restoring target data files to the duplicate database C. performing complete recovery by using all available backups D. generating a new, unique database identifier (DBID) for the …