Download Oracle Database 11g-Administration II.actualtests.1z0-053.2019-02-07.1e.443q.vcex


Download Exam

File Info

Exam Oracle Database 11g: Administration II
Number 1z0-053
File Name Oracle Database 11g-Administration II.actualtests.1z0-053.2019-02-07.1e.443q.vcex
Size 9.61 Mb
Posted February 07, 2019
Downloads 68



How to open VCEX & EXAM Files?

Files with VCEX & EXAM extensions can be opened by ProfExam Simulator.

Purchase
Coupon: EXAMFILESCOM

Coupon: EXAMFILESCOM
With discount: 20%


 
 



Demo Questions

Question 1
Which statement is true regarding the VALIDATE DATABASE command?

  • A: It checks the database for intrablock corruptions only.
  • B: It checks for block corruption in the valid backups of the database.
  • C: It checks the database for both intrablock and interblock corruptions.
  • D: It checks for only those corrupted blocks that are associated with data files.



Question 2
You have configured flash recovery area in your database and you set the following Initialization parameters for your database instance:
LOG_ARCHIVE_DEST_1 = 'LOCATION=/disk1/arch MANDATORY' 
LOG_ARCHIVE_DEST_2 = 'LOCATION=/disk2/arch' 
LOG_ARCHIVE_DEST_3 = 'LOCATION=/disk3/arch’ 
LOG_ARCHIVE_DEST_4 = 'LOCATION=/disk4/arch' 
LOG_ARCHIVE_MIN_SUCCEED_DEST = 2 
While the database instance is functional, you realized that the destination set by the LOG_ARCHIVE_DEST_I parameter Is not available for the archived redo log file to be created in. All redo log groups have been used. 
What happens in an event of log switch?

  • A: The online redo log file is not allowed to be overwritten.
  • B: The archived redo log files are written to the flash recovery area until the MANDATORY destination is made available.
  • C: The database instance will crash because the archived redo log file cannot be created in a destination set as MANDATORY.
  • D: The destination set by the LOG_ARCHIVE_DEST_1 parameter is ignored and the archived redo log files are created in the next two available locations to guarantee archive log success.



Question 3
Your developers have asked you to restore the development database, which is in NOARCHIVELOG mode, back to last Tuesday the 20th. Your last backup is from Monday the 19th. 
What do you do?

  • A: Restore the 19ths backup, restore all archived redo logs, recover the database to the 20th, and open the database.
  • B: Tell them that their request cannot be met with the current backup strategy.
  • C: Restore the 19ths backup, apply the online redo logs, and open the database.
  • D: Switch the database into ARCHIVELOG mode, restore the 19th's backup, restore all archived redo logs, and recover the database to the 20th.
  • E: Use the recover database command to roll back the database from today to the 19th of the month.



Question 4
What does the SCN represent?

  • A: The system change number, which is a point in time relative to transactions within a given database.
  • B: A number that represents time. Thus, at 1300 hours, the SCN is the same on all databases.
  • C: The security change number, which represents the security code that is needed to access any database structure.
  • D: A conversion factor that converts internal database time to external clock time.
  • E: UTC time in the database, providing a standardized way of tracking time in Oracle.



Question 5
During recovery, you need to know if log sequence 11 is in the online redo logs, and if so, you need to know the names of the online redo logs so you can apply them during recovery. Which view or views would you use to determine this information? (Choose all that apply.)

  • A: V$LOGFILE
  • B: V$RECOVER_LOG
  • C: V$RECOVER_DATABASE
  • D: V$LOG_RECOVER
  • E: V$LOG



Question 6
How is block-change tracking enabled?

  • A: With alter database enable block change tracking
  • B: With alter system enable block change tracking
  • C: With an init.ora parameter change
  • D: With an spfile parameter change



Question 7
The CONTROL_FILE_RECORD_KEEP_TIME initialization parameter should be set to what value? (Choose all that apply.)

  • A: The initialization parameter should be set to 0 when the RMAN repository is being used.
  • B: The initialization parameter should be set to greater than 0 with the RMAN repository utilizing the recovery catalog only.
  • C: The initialization parameter should be set to greater than 0 with the RMAN repository utilizing the control file or the recovery catalog.
  • D: The initialization parameter should be set to 0 with the RMAN repository utilizing the control file or the recovery catalog.
  • E: The initialization parameter should never be set to 0 if you are using RMAN.



Question 8
You want to use the automatic management of backup and recovery operations features for your database. 
Which configuration must you set?

  • A: Enable the flash recovery area and specify it as the archived redo log destination.
  • B: Disable the flash recovery area and start the database instance in ARCHIVELOG mode.
  • C: Enable the flash recovery area but do not specify it as the archived redo log destination.
  • D: Disable the flash recovery area and start the database instance in NOARCHIVELOG mode.



Question 9
Which three types of files can be automatically placed in the flash recovery area (fast recovery area in 11g Release 2)? (Choose three.)

  • A: Alert log file
  • B: Archived redo log files
  • C: Control file autobackups
  • D: Server Parameter file (SPFILE)
  • E: Recovery Manager (RMAN) backup piece



Question 10
While Monitoring the space usage in your database that is in ARCHIVELOG mode you observed that the flash recovery area does not have enough free space to accommodate any more files and you do not have necessary permissions to add more space to it. 
Identify the two events that can occur in the event of a log switch? (Choose two.)

  • A: An entry is created in the alert log file and the database instance continues to function normally
  • B: The log switch hangs occur for transactions until free space is available in the flash recovery area
  • C: The Oracle database server deletes a file that is on the obsolete file list to make free space in the flash recovery area
  • D: The database instance status is implicitly changed to RESTRICTED mode and file creations to the flash recovery area are prevented








ProfExam
PROFEXAM WITH A 20% DISCOUNT

You can buy ProfExam with a 20% discount..

Get Now!


HOW TO OPEN VCEX AND EXAM FILES

Use ProfExam Simulator to open VCEX and EXAM files
ProfExam Screen



HOW TO OPEN VCE FILES

Use VCE Exam Simulator to open VCE files
Avanaset