Proper study guides for Replace Oracle Oracle Database 11g: Administration II certified begins with Oracle 1Z0-053 preparation products which designed to deliver the Download 1Z0-053 questions by making you pass the 1Z0-053 test at your first time. Try the free 1Z0-053 demo right now.
2021 Jul 1z0-053 exam dumps:
Q81. 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?
A. Restore the latest whole backup, perform complete recovery, and open the database normally
B. Restore the latest whole backup, perform incomplete recovery, and open the database with the RESETLOGS option.
C. Restore the latest backups control file, perform complete recovery, and open the database with the RESETLOGS option.
D. Restore the latest backup control file, perform incomplete recovery using backup control file, and open the database with the RESETLOG option.
Q82. You performed the RMAN database backup with the KEEP option. Which two statements are true regarding this backup? (Choose two.)
A. The backup contains data files, the server parameter file, and the control file even if the control file autobackup is disabled.
B. The KEEP option overrides the configured retention policy.
C. The backup contains only data files and archived redo log files.
D. The KEEP option is an attribute of an individual backup piece.
Q83. You want to use RMAN to create compressed backups.
Which statement is true about the compression algorithms that RMAN can use?
A. The BZIP2 compression algorithm consumes more CPU resources than the ZLIB compression algorithm.
B. The ZLIB compression algorithm consumes more CPU resources than the BZIP2 compression algorithm.
C. The ZLIB compression algorithm provides maximum compression and produces smaller backups than the BZIP2 compression algorithm.
D. Only the BZIP2 compression algorithm can be used to make compressed backups to disk.
Q84. View the exhibit and examine the TRANS table's storage information.
After a massive delete operation, you executed the following statement to shrink the TRANS table:
SQL> ALTER TABLE trans SHRINK SPACE CASCADE;
Which statement describes the outcome of the command?
A. An error is produced.
B. The table and all related objects are compacted and the position of the high-water mark (HWM) for the table is adjusted
C. The table and related indexes are compacted but the position of the high-water mark (HWM) for the table remains unchanged
D. The unused space in the table is reclaimed and returned to the tablespace and the data manipulation language (DML) triggers on the table are fired during the shrinking process
Q85. Immediately after adding a new disk to or removing an existing disk from an ASM instance, you find that the performance of the database goes down initially until the time the addition or removal process is completed, and then gradually becomes normal.
Which two activities would you perform to maintain a consistent performance of the database while adding or removing disks? (Choose two.)
A. Define the POWER option while adding or removing the disks.
B. Increase the number of ARB processes by setting up a higher value for ASM_POWER_LIMIT.
C. Increase the number of DBWR processes by setting up a higher value for DB_WRITER_PROCESSES.
D. Increase the number of slave database writer processes by setting up a higher value for DBWR_IO_SLAVES.
Renew free 1z0-053 vce:
Q86. Examine the following command:
SQL> ALTER TABLE booking SHRINK SPACE COMPACT;
Which activity is performed when the preceding command is executed?
A. The shrink operation touches every block in the BOOKING table
B. The high-water mark (HWM) for the BOOKING table is shifted from its original position
C. The progress of the shrink operation is saved in the bitmap blocks of the BOOKING table
D. The data manipulation language (DML) triggers on the BOOKING table are executed because the shrink operation is internally handled by the INSERT/DELETE operation
Q87. 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.
Q88. The application tables owned by the user TEST in a test database need to be exported to the APPS schema in the production database by using Data Pump. Which option of Data Pump Import would you use to accomplish this?
Q89. You are maintaining the SALES database. You have added a new disk to a disk group. Automatic Storage Management performs the rebalancing activity. You want to speed up the rebalancing activity.
Which parameter should you specify to control the speed of the rebalancing activity?
Q90. In Oracle 11g, by default which one of the following conditions implicitly enables Automatic PGA Memory Management?
A. Setting a nonzero value for SGA_TARGET
B. Configuring Automatic Shared Memory Management
C. Configuring Automatic Memory Management
D. Setting a nonzero value for SGA_MAX_SIZE and PGA_AGGREGATE_TARGET
E. None of the above