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

Latesttests 2018 Jan Oracle Official New Released 1z0-053
100% Free Download! 100% Pass Guaranteed!

Oracle Database 11g: Administration II

Question No: 221 – (Topic 6)

You need to restore your database back to 9/30/2008 at 18:00. In what order would you run the following commands to compete this task?

  1. restore controlfile until time #39;09/30/2008:18:00:00#39;;

  2. restore database until time #39;09/30/2008:18:00:00#39;;

  3. restore spfile until time #39;09/30/2008:18:00:00#39;;

  4. recover database until time #39;09/30/2008:18:00:00#39;;

  5. alter database open resetlogs;

  6. alter database open;

  1. b, d, e

  2. b, d, f

  3. c, a, b, d, e

  4. c, a, b, d, f

  5. a, b, d, e

Answer: A

Question No: 222 – (Topic 6)

What methods are available to recover lost control files? (Choose all that apply.)

  1. Backup control file.

  2. Emergency control file.

  3. The create controlfile command.

  4. The restore controlfile SQL*Plus command.

  5. No backup is required. The database will re-create the control file when it is discovered to be lost.

Answer: A,C

Question No: 223 – (Topic 6)

Upon starting your database, you receive the following error:

SQLgt; startup

ORACLE instance started.

Total System Global Area 171581440 bytes Fixed Size 1298640 bytes

Variable Size 146804528 bytes Database Buffers 20971520 bytes Redo Buffers 2506752 bytes Database mounted.

ORA-00313: open failed for members of log group 1 of thread 1 ORA-00312: online log 1 thread 1: #39;/oracle01/oradata/orcl/redo01.log#39;

ORA-00312: online log 1 thread 1: #39;/oracle01/oradata/orcl/redo01a.log#39; You can choose from the following steps:

a: Restore the database datafiles.

b: Issue the alter database clear unarchived logfile group 1 command. c: Issue the alter database open command.

d: Issue the alter database open resetlogs command. e: Recover the database using point-in-time recovery.

f: Issue the Startup Mount command to mount the database. g: Back up the database.

Which is the correct order of these steps in this case?

  1. a, f, e, d, g

  2. f, e, d

  3. f, b, c, g

  4. a, f, c

  5. The database cannot be recovered.

    Answer: C Explanation:

    1. one step of process must be ALTER DATABASE OPEN, since the database instance is started and mounted from clean shutdown.

    2. After redo log clear done, you must backup the database immediately, so that you have a backup you can use for complete recovery without relying on the cleared log group.

      Question No: 224 – (Topic 6)

      In Recovery Manager (RMAN), you are taking image copies of the data files of your production database and rolling them forward at regular intervals. You attempt to restart your database. After a regular maintenance task, you realize that one of the data files that belongs to the USERS tablespace is damaged and you need to recover the data file by using the image copy. Because a media failure caused the data file to be damaged, you want to place the data file in a different location while restoring the file.

      Which option must you consider for this task?

      1. using only the RMAN SWITCH command to set the new location for the data file

      2. placing the database in the MOUNT state for the restore and recovery operations.

      3. using an RMAN RUN block with the SET NEWNAME and then the SWITCH command.

      4. configuring two channels: one for the restore operation and the other for the recovery operation

Answer: C

Question No: 225 – (Topic 6)

Your database is running in ARCHIVELOG mode. One of the data files, USERDATA01.dbf, in the USERS tablespace is damaged and you need to recover the file until the point of failure. The backup for the datafile is available.

Which three files would be used in the user-managed recovery process performed by the database administrator (DBA)? (Choose Three)

  1. Redo logs

  2. Control file

  3. The latest backup of only the damaged data file

  4. The latest backup of all the data file in the USERS tablespace

  5. Temporary files of temporary tablespace

  6. Archive Logs since the latest backup to point of failure

Answer: A,C,F

Question No: 226 – (Topic 6)

You backed up the database at 8 a.m. today using an online backup. Accounting made a large change to the underlying data between 10 a.m. and noon.

Which of the following actions would ensure that the changes could be recovered using the 8 a.m. backup?

  1. Create a manual incremental online database backup.

  2. Back up all the archived redo logs generated since the 8 a.m. backup.

  3. Create a brand-new backup after all the changes have been applied.

  4. There is no way to make the changes recoverable based on the 8 a.m. backup.

  5. Perform an online backup of the tablespace(s) that contained changed data.

Answer: B

Question No: 227 – (Topic 6)

Which statement about recovering from the loss of a redo log group is true?

  1. If the lost redo log group is ACTIVE, you should first attempt to clear the log file.

  2. If the lost redo log group is CURRENT, you must clear the log file.

  3. If the lost redo log group is ACTIVE, you must restore, perform cancel-based incomplete recovery, and open the database using the RESETLOGS option.

  4. If the lost redo log group is CURRENT, you must restore, perform cancel-based incomplete recovery, and open the database using the RESETLOGS option.

Answer: D

Question No: 228 – (Topic 6)

Which command is used to open the database after an incomplete recovery?

  1. alter database open

  2. alter database open repairlog

  3. alter database open resetlogs

  4. alter database open resetlog

  5. alter database resetlogs open

Answer: C

Question No: 229 – (Topic 6)

You are working on a 24X7 database. You want to design a backup strategy for your database that uses user managed backups. You want to be able to perform all backups while the database remains online.

Which statement about performing user-managed backups in a 24×7 environment is true?

  1. You must have change tracking enabled in your database

  2. Your database must be running in NOARCHIVELOG mode

  3. To back up a tablespace, it must be in backup mode

  4. To back up a tablespace, it must first be taken offline

Answer: C

Question No: 230 – (Topic 6)

When performing an online backup, what is the proper order of the following steps?

a: Issue the ALTER DATABASE END BACKUP command. b: Back up the archived redo logs.

c: Issue the ALTER DATABASE BEGIN BACKUP command. d: Back up the database files.

e: Determine the beginning log sequence number. f: Determine the ending log sequence number.

g: Force a log switch with the ALTER SYSTEM SWITCH LOGFILE command.

  1. a, b, c, d, e, f, g

  2. c, d, a, b, e, g, f

  3. f, d, b, g, a, c, e

  4. e, c, d, a, g, f, b

  5. a, f, b, g, e, c, d

    Answer: D Explanation:

    There are two big steps to complete the online database backup:

    1. Enclose with BEGIN BACKUP and END BACKUP options to use O/S file copy command to backup data files;

      Which is e, c, d, a

    2. Use SWITCH LOGFILE command to archive all the online redo log. backup all the archived redo log file. Which is g, f, b

      According to Oracle document, after online backup done, you must archive the online redo log, otherwise you will have no chance to recover the database with consistence.

      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