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

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: 251 – (Topic 6)

Your database is up and running and one of your three control files is accidentally erased. You start RMAN and run the following command:

RESTORE CONTROLFILE FROM AUTOBACKUP;

Which of the following statements is true? (Choose all that apply.)

  1. The command restores only the missing control file.

  2. The command restores all the control files.

  3. The command fails because the database is running.

  4. This is the correct way to address this problem.

  5. This is not the correct way to address this problem.

Answer: C,E Explanation:

During the database running, the control files are locked by the database instance, you must shutdown the database and startup at NOMOUNT status to restore a missing control file.

And you have to open database with RESETLOGS option, due to control file change.

Question No: 252 – (Topic 6)

Examine the following scenario:

->Database is running in ARCHIVELOG mode.

->Complete consistent backup is taken every Sunday.

->On Tuesday the instance terminates abnormally because the disk on which control files are located gets corrupted

->The disk having active online redo log files is also corrupted.

->The hardware is repaired and the paths for online redo log files and control files are still valid.

Which option would you use to perform the recovery of database till the point of failure?

  1. Restore the latest whole backup, perform complete recovery, and open the database normally

  2. Restore the latest whole backup, perform incomplete recovery, and open the database with the RESETLOGS option.

  3. Restore the latest backups control file, perform complete recovery, and open the database with the RESETLOGS option.

  4. Restore the latest backup control file, perform incomplete recovery using backup control file, and open the database with the RESETLOG option.

    Answer: D

    Question No: 253 – (Topic 6)

    Your production database is running in archivelog mode and you are using recovery manager (RMAN) with recovery catalog to perform the database backup at regular intervals. When you attempt to restart the database instance after a regular maintenance task on Sunday, the database fails to open displaying the message that the data file belonging to the users tablespace are corrupted.

    The steps to recover the damaged data files are follows:

    1. Mount the database

    2. Open the database

    3. Recover the data file

    4. Restore the data file

    5. Make the data file offline

    6. Make the data file online

      Which option identifies the correct sequence that you must use to recover the data files?

      A. 2, 4, 3

      B. 1, 4, 3, 2

      C. 2, 5, 4, 3, 6

      D. 5, 2, 4, 3, 6

      E. 1, 5, 4, 3, 6, 2

      Answer: D

      Question No: 254 – (Topic 6)

      You have lost all your database control files. To recover them, you are going to use the results of the alter database backup controlfile to trace command. Your datafiles and your online redo logs are all intact.

      Which of the following is true regarding your recovery?

      1. You will need to open the database with the resetlogs command.

      2. All you need to do is execute the trace file from SQL*Plus and it will perform the recovery for you.

      3. You will use the resetlogs version of the create controlfile command.

      4. You will use the noresetlogs version of the create controlfile command.

      5. You will use the trace file to create a backup control file, and then you will recover the database with the recover database using backup controlfile command

Answer: D Explanation: Refer to here

CREATE CONTROLFILE Using NORESETLOGS Example

The following CREATE CONTROLFILE statement is generated by an ALTER DATABASE BACKUP CONTROLFILE TO TRACE statement for a database with Oracle managed data files and redo log files: CREATE CONTROLFILE

Latesttests 2018 PDF and VCE

C:\Users\albo\Desktop\1-1.jpg

Question No: 255 – (Topic 6)

The database is running in the ARCHIVELOG mode. It has three redo log groups with one member each. One of the redo log groups has become corrupted. You have issued the following command during the recovery of a damaged redo log file:

ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 3;

Which action should you perform immediately after using this command?

  1. You should perform a log switch

  2. You should make a backup of the database

  3. You should switch the database to the NOARCHIVELOG mode

  4. You should shut down the database instance and perform a complete database recovery

Answer: B

Question No: 256 – (Topic 6)

The database Is configured in ARCHIVELOG mode. The database needs to be up 24 X 7. You want to perform user managed backup for the data files of the HR_DATA tablespace. To accomplish the task, you issued the following command:

SQLgt; ALTER TABLESPACE hr_data BEGIN BACKUP;

Which two statements are true in this scenario? (Choose two.)

  1. No transaction on the tablespace is allowed but you can perform queries.

  2. The tablespace will automatically come out of backup mode when the file copy is complete.

  3. The checkpoint change number is frozen in headers of the data files until the file is removed from backup mode.

  4. The database writes the before image of an entire block to the redo stream before modifying. block tor the first time.

Answer: C,D Explanation:

Making User-Managed Backups of Online Read/Write Tablespaces

You must put a read/write tablespace in backup mode to make user-managed data file backups when the tablespace is online and the database is open. The ALTER TABLESPACE … BEGIN BACKUP statement places a tablespace in backup mode. In backup mode, the database copies whole changed data blocks into the redo stream. After you take the tablespace out of backup mode with the ALTER TABLESPACE … END BACKUP or ALTER DATABASE END BACKUP statement, the database advances the data file checkpoint SCN to the current database checkpoint SCN.

When restoring a data file backed up in this way, the database asks for the appropriate set of redo log files to apply if recovery is needed. The redo logs contain all changes required to recover the data files and make them consistent.

Question No: 257 – (Topic 6)

Your database is in ARCHIVELOG mode. You have two online redo log groups, each of which contains one redo member.

When you attempt to start the database, you receive the following errors: ORA-00313: open failed for members of log group 1 of thread 1

ORA-00312: online log 1 thread 1: #39;D:\REDO01.LOG#39;

You discover that the online redo log file of the current redo group is corrupted. Which statement should you use to resolve this issue?

  1. ALTER DATABASE DROP LOGFILE GROUP 1;

  2. ALTER DATABASE CLEAR LOGFILE GROUP 1;

  3. ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 1;

  4. ALTER DATABASE DROP LOGFILE MEMBER #39;D:\REDO01.LOG#39;;

Answer: C

Question No: 258 – (Topic 6)

While working on a data problem, Curt, Bill, Ben, Mike, and Matt introduced a vast amount of corrupted data into the database. Pablo has discovered this problem and he needs you to recover the database to the point in time prior to the introduction of the corruption. The logical corruption was introduced at 6:30 p.m. on September 6, 2008.

Which of the following would be the correct commands to use to restore the database to a point in time before the corruption?

Latesttests 2018 PDF and VCE

  1. Option A

  2. Option B

  3. Option C

  4. Option D

  5. Option E

Answer: C

Question No: 259 – (Topic 6)

Which mode of database shutdown requires an instance recovery at the time of the next database startup?

  1. ABORT

  2. NORMAL

  3. IMMEDIATE

  4. TRANSACTIONAL

Answer: A

Question No: 260 – (Topic 6)

Which files will you need to perform a full recovery of a database backed up in NOARCHIVELOG mode? (Choose all that apply.)

  1. Database datafiles

  2. Control files

  3. Archived redo logs

  4. Online redo logs

  5. Flashback logs

    Answer: A,B,D Explanation:

    Recovering a Database in NOARCHIVELOG Mode

    1. Restore all the data files and control files

    2. (optional) if the media failure is not fixed, you need to modify the control file to the new location of data files and redo log files.

      SQLgt; STARTUP MOUNT;

      SQLgt; ALTER DATABASE RENAME FILE #39;lt;damaged file, datafile, redo loggt;#39; TO #39;lt;new locationgt;#39;;

    3. SQLgt; RECOVER DATABASE UNTIL CANCEL Because online redo logs are never backed up, you cannot restore them with the data files and control files. To enable the database to reset the online redo logs, you must first mimic incomplete recovery:

    4. SQLgt; ALTER DATABASE OPEN RESETLOGS;

      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