Download Oracle Database 11g: Administration II.1z0-053.ActualTests.2019-02-07.443q.vcex

Vendor: Oracle
Exam Code: 1z0-053
Exam Name: Oracle Database 11g: Administration II
Date: Feb 07, 2019
File Size: 10 MB
Download Exam

How to open VCEX files?

Files with VCEX extension can be opened by ProfExam Simulator.

Download
ProfExam Simulator

Purchase
Coupon: EXAMFILESCOM

Discount: 20%

ProfExam Simulator ProfExam Simulator ProfExam Simulator ProfExam Simulator ProfExam Simulator

Demo Questions

Question 1
Which statement is true regarding the VALIDATE DATABASE command?
  1. It checks the database for intrablock corruptions only.
  2. It checks for block corruption in the valid backups of the database.
  3. It checks the database for both intrablock and interblock corruptions.
  4. It checks for only those corrupted blocks that are associated with data files.
Correct answer: A
Explanation:
interblock corruption A type of block corruption in which the corruption occurs between blocks rather than within the block itself. This type of corruption can only be logical corruption. intrablock corruption A type of block corruption in which the corruption occurs within the block itself. this type of corruption can be either a physical corruption or logical corruption.    
interblock corruption 
A type of block corruption in which the corruption occurs between blocks rather than within the block itself. This type of corruption can only be logical corruption. 
intrablock corruption A type of block corruption in which the corruption occurs within the block itself. this type of corruption can be either a physical corruption or logical corruption. 
  
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?
  1. The online redo log file is not allowed to be overwritten.
  2. The archived redo log files are written to the flash recovery area until the MANDATORY destination is made available.
  3. The database instance will crash because the archived redo log file cannot be created in a destination set as MANDATORY.
  4. 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.
Correct answer: D
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?
  1. Restore the 19ths backup, restore all archived redo logs, recover the database to the 20th, and open the database.
  2. Tell them that their request cannot be met with the current backup strategy.
  3. Restore the 19ths backup, apply the online redo logs, and open the database.
  4. Switch the database into ARCHIVELOG mode, restore the 19th's backup, restore all archived redo logs, and recover the database to the 20th.
  5. Use the recover database command to roll back the database from today to the 19th of the month.
Correct answer: B
Question 4
What does the SCN represent?
  1. The system change number, which is a point in time relative to transactions within a given database.
  2. A number that represents time. Thus, at 1300 hours, the SCN is the same on all databases.
  3. The security change number, which represents the security code that is needed to access any database structure.
  4. A conversion factor that converts internal database time to external clock time.
  5. UTC time in the database, providing a standardized way of tracking time in Oracle.
Correct answer: A
Explanation:
SCN System Change Number. A database ordering primitive. The value of an SCN is the logical point in time at which changes are made to a database. Refer to v11.2 document
SCN 
System Change Number. A database ordering primitive. 
The value of an SCN is the logical point in time at which changes are made to a database. 
Refer to v11.2 document
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.)
  1. V$LOGFILE
  2. V$RECOVER_LOG
  3. V$RECOVER_DATABASE
  4. V$LOG_RECOVER
  5. V$LOG
Correct answer: AE
Question 6
How is block-change tracking enabled?
  1. With alter database enable block change tracking
  2. With alter system enable block change tracking
  3. With an init.ora parameter change
  4. With an spfile parameter change
Correct answer: A
Question 7
The CONTROL_FILE_RECORD_KEEP_TIME initialization parameter should be set to what value? (Choose all that apply.)
  1. The initialization parameter should be set to 0 when the RMAN repository is being used.
  2. The initialization parameter should be set to greater than 0 with the RMAN repository utilizing the recovery catalog only.
  3. The initialization parameter should be set to greater than 0 with the RMAN repository utilizing the control file or the recovery catalog.
  4. The initialization parameter should be set to 0 with the RMAN repository utilizing the control file or the recovery catalog.
  5. The initialization parameter should never be set to 0 if you are using RMAN.
Correct answer: CE
Explanation:
CONTROL_FILE_RECORD_KEEP_TIME specifies the minimum number of days before a reusable record in the control file can be reused. In the event a new record needs to be added to a reusable section and the oldest record has not aged enough, the record section expands. If this parameter is set to 0, then reusable sections never expand, and records are reused as needed. If the number of reusable records in the control file exceeds the circular reuse record limit UB4MAXVAL, then reusable records will be overwritten even if CONTROL_FILE_RECORD_KEEP_TIME has not elapsed. UB4MAXVAL is defined in the oratypes.h header file, which is found in the public directory. Its value may vary according to the operating system you are using.
CONTROL_FILE_RECORD_KEEP_TIME specifies the minimum number of days before a reusable record in the control file can be reused. In the event a new record needs to be added to a reusable section and the oldest record has not aged enough, the record section expands. If this parameter is set to 0, then reusable sections never expand, and records are reused as needed. 
If the number of reusable records in the control file exceeds the circular reuse record limit UB4MAXVAL, then reusable records will be overwritten even if CONTROL_FILE_RECORD_KEEP_TIME has not elapsed. 
UB4MAXVAL is defined in the oratypes.h header file, which is found in the public directory. Its value may vary according to the operating system you are using.
Question 8
You want to use the automatic management of backup and recovery operations features for your database. 
Which configuration must you set?
  1. Enable the flash recovery area and specify it as the archived redo log destination.
  2. Disable the flash recovery area and start the database instance in ARCHIVELOG mode.
  3. Enable the flash recovery area but do not specify it as the archived redo log destination.
  4. Disable the flash recovery area and start the database instance in NOARCHIVELOG mode.
Correct answer: A
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.)
  1. Alert log file
  2. Archived redo log files
  3. Control file autobackups
  4. Server Parameter file (SPFILE)
  5. Recovery Manager (RMAN) backup piece
Correct answer: BCE
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.)
  1. An entry is created in the alert log file and the database instance continues to function normally
  2. The log switch hangs occur for transactions until free space is available in the flash recovery area
  3. The Oracle database server deletes a file that is on the obsolete file list to make free space in the flash recovery area
  4. The database instance status is implicitly changed to RESTRICTED mode and file creations to the flash recovery area are prevented
Correct answer: BC
CONNECT US
HOW TO OPEN VCE FILES

Use VCE Exam Simulator to open VCE files
Avanaset

HOW TO OPEN VCEX AND EXAM FILES

Use ProfExam Simulator to open VCEX and EXAM files
ProfExam Screen

ProfExam
ProfExam at a 20% markdown

You have the opportunity to purchase ProfExam at a 20% reduced price

Get Now!