[Free] 2018(Jan) Latesttests Testking Oracle 1z0-053 Dumps with VCE and PDF Download 191-200

Latesttests 2018 Jan Oracle Official New Released 1z0-053
100% Free Download! 100% Pass Guaranteed!
http://www.Latesttests.com/1z0-053.html

Oracle Database 11g: Administration II

Question No: 191 – (Topic 5)

You want to take a complete database backup using RMAN. The backup should consist only the used blocks from your database.

Which two statements are true about this backup operation? (Choose two.)

  1. Backup compression should be enabled

  2. Parallelism for the channel should be set to 2

  3. All the files must be backed up as backup sets

  4. The backup may be stored either on disk or on media with media manager

Answer: C,D

Question No: 192 – (Topic 5)

Your database is running in ARCHIVELOG mode, and the database is open. You execute an RMAN backup and specify the KEEP clause.

Which components are backed up when this option is specified?

  1. only the control file, the current SPFILE, and data files

  2. only the current SPFILE and data files if autobackup is disabled

  3. only the data files and the archived redo logs

  4. the control file, current SPFILE file, data files, and archived redo logs

Answer: D

Question No: 193 – (Topic 5)

What is the impact of the results of the output of the following command?

RMANgt; report unrecoverable database;

Report of files that need backup due to unrecoverable operations File Type of Backup Required Name

— ———— ——————

  • full or incremental C:\ORACLE\ORADATA\ORCL\USERS01.DBF

    1. There are no backup sets with any backups of the users01.dbf datafile.

    2. The users01.dbf datafile has had unrecoverable operations occur in it. It will need to be backed up or some data loss is possible during a recovery.

    3. The users01.dbf datafile is corrupted.

    4. The users01.dbf datafile backup exceeds the retention criteria.

    5. The last backup of the users01.dbf datafile failed and must be rerun.

    Answer: D

    Question No: 194 – (Topic 5)

    You are using RMAN to backup your ARCHIVELOG mode database. You have enabled control-file autobackups. Which files are not backed up during the RMAN backup?

    1. Database Datafiles

    2. Database Control Files

    3. Online redo logs

    4. Archived redo logs

    5. The database SPFILE

    6. None of the above, all these files are backed up.

    Answer: C

    Question No: 195 – (Topic 5)

    Which of the following commands will fail?

    1. report schema;

    2. report need backup;

    3. report need backup days 3;

    4. report user;

    5. report obsolete;

    Answer: D

    Question No: 196 – (Topic 5)

    Examine the following set of RMAN commands:

    RMANgt; CONFIGURE CHANNEL dc1 DEVICE TYPE DISK FORMAT #39;/u02/backup/%U#39;; RMANgt; RUN (

    ALLOCATE CHANNEL Chi DEVICE TYPE DISK;

    EXECUTE SCRIPT full_backup;

    )

    Which statement is true when the RMAN RUN block is executed?

    1. The execution of the script fails because multiple channels cannot coexist.

    2. The script is executed and both the channels are used for the script execution.

    3. The new channel #39;CHI#39; is Ignored because a channel has been configured already.

    4. configuration parameter dc1 is overridden because a new channel is allocated in RMAN RUN block.

    Answer: D

    Question No: 197 – (Topic 5)

    True or false: RMAN offers the equivalent of the SQL command alter database backup controlfile to trace.

    1. True

    2. False

    Answer: B

    Question No: 198 – (Topic 5)

    Given the following steps, which would be the correct order to create a backup of an Oracle database in NOARCHIVELOG mode?

    1. shutdown immediate from RMAN

    2. Log into RMAN

    3. startup mount from RMAN 10.backup database

    1. alter database open

    2. backup database plus archivelog delete input

    A. 2,3,1,4,5

    B. 2,1,3,6,5

    C. 1,3,5,4

    D. 2,1,3,5,6

    E. 2,1,3,4,5

    Answer: E Explanation:

    Backing Up a Database in NOARCHIVELOG Mode

    If a database runs in NOARCHIVELOG mode, then the only valid database backup is a consistent backup. For the backup to be consistent, the database must be mounted after a consistent shutdown. No recovery is required after restoring the backup.

    To make a consistent database backup:

    1. Start RMAN and connect to a target database.

    2. Shut down the database consistently and then mount it.

      For example, enter the following commands to guarantee that the database is in a consistent state for a backup:

      RMANgt; SHUTDOWN IMMEDIATE; RMANgt; STARTUP FORCE DBA; RMANgt; SHUTDOWN IMMEDIATE; RMANgt; STARTUP MOUNT;

    3. Run the BACKUP DATABASE command.

      For example, enter the following command at the RMAN prompt to back up the database to the default backup device:

      RMANgt; BACKUP DATABASE;

      The following variation of the command creates image copy backups of all data files in the database:

      RMANgt; BACKUP AS COPY DATABASE;

    4. Open the database and resume normal operations. The following command opens the database:

      RMANgt; ALTER DATABASE OPEN;

      Question No: 199 – (Topic 5)

      What is the impact of the following backup if it exceeds the duration allowance? backup as compressed backupset duration 2:00 partial minimize load database ;

      1. The entire backup will fail. It will not be usable for recovery.

      2. The entire backup will fail, but any datafile successfully backed up will be usable for recovery.

      3. If this backup fails, subsequent backups will prioritize datafiles not backed up.

      4. If this backup fails, an error will be raised and any other commands will not be executed.

      5. If this backup fails, no error will be raised and any other commands will be executed.

    Answer: B

    Question No: 200 – (Topic 5)

    Identify the scenarios in which the RMAN CROSSCHECR command is useful. (Choose all that apply.)

    1. To check that the obsolete backups are deleted from the repository records and from the disk.

    2. To update the RMAN repository if you delete archived redo logs with operating system commands.

    3. To update outdated information about backups that disappeared from disk or tape or became corrupted and inaccessible.

    4. To synchronize the actual files on disk or in the media management catalog with the RMAN repository for which the backup was not taken using RMAN.

    Answer: B,C Explanation:

    Crosscheck are useful because they can do the following: (Link)

    ->Update outdated information about backups that disappeared from disk or tape or became corrupted

    ->Update the repository if you delete archived redo logs or other files with operating system commands

    Use the CROSSCHECK command to synchronize the physical reality of backups and copies with their logical records in the RMAN repository.

    The CROSSCHECK command checks only objects marked AVAILABLE or EXPIRED in the repository by examining the files on disk for DISK channels or by querying the media manager for sbt channels.

    Meaning of Crosscheck Status: EXPIRED

    Object is not found either in file system (for DISK) or in the media manager (for sbt). A backup set is EXPIRED if any backup piece in the set is EXPIRED.

    The CROSSCHECK command does not delete the repository records of the files that it does not find, but updates their repository records to EXPIRED. You can run DELETE EXPIRED to remove the repository records for expired files and any existing physical files whose status is EXPIRED.

    If backups are EXPIRED, then you can re-execute the crosscheck later and determine whether expired backups are available. This precaution is especially useful when you use RMAN with a media manager. For example, if some backup pieces or copies were erroneously marked as EXPIRED because the PARMS channel settings were incorrect, then after ensuring that the files really do exist in the media manager, run the CROSSCHECK BACKUP command again to restore those files to AVAILABLE status.

    AVAILABLE

    Object is available for use by RMAN. For a backup set to be AVAILABLE, all backup pieces in the set must have the status AVAILABLE.

    100% Free Download!
    Download Free Demo:1z0-053 Demo PDF
    100% Pass Guaranteed!
    Download 2018 Latesttests 1z0-053 Full Exam PDF and VCE

    Latesttests ExamCollection Testking
    Lowest Price Guarantee Yes No No
    Up-to-Dated Yes No No
    Real Questions Yes No No
    Explanation Yes No No
    PDF VCE Yes No No
    Free VCE Simulator Yes No No
    Instant Download Yes No No

    2018 Latesttests IT Certification PDF and VCE