Ensurepass.com : Ensure you pass the IT Exams
2018 Jan Oracle Official New Released 1z0-053
100% Free Download! 100% Pass Guaranteed!
http://www.EnsurePass.com/1z0-053.html
Oracle Database 11g: Administration II
Question No: 81 – (Topic 2)
If you issue the command shutdown abort prior to trying to put the database in ARCHIVELOG mode, what will be the result when you issue the command alter database archivelog?
-
The alter database archivelog command will fail.
-
The alter database archivelog inconsistent command must be used to put the database in ARCHIVELOG mode.
-
The alter database archivelog command will succeed.
-
The alter database archivelog command will ask if you want to make the database consistent first.
-
There is no alter database archivelog command. The correct command is alter database alterlogging.
Answer: A Explanation:
Before you change database to archivelog mode, you need to have a clean database shutdown.
Question No: 82 – (Topic 2)
Which command would you use to determine what database backups are currently available for restore?
-
list database backup;
-
report database backup;
-
list backup of database;
-
list summary backup;
-
report backup of database;
Answer: C
Question No: 83 – (Topic 2)
You execute the following Recovery Manager (RMAN) commands in the following order: BACKUP VALIDATE DATABASE;
RECOVER CORRUPTION LIST;
Which (two tasks are performed by these commands? (Choose two.)
-
Repair the corrupted blocks. If any. In the backup created.
-
Populate V$COPY_CORRUPTION with names of files that have corrupted blocks.
-
Back up the database after checking whether array of the files have corrupted blocks.
-
Discover any corrupt blocks that are viewable with the V$DATABASE_BLOCK_CORRUPTION view.
-
Repair all corrupted blocks that have been logged in the V$DATABASE_BLOCK_CORRUPTION
Answer: D,E Explanation:
V$DATABASE_BLOCK_CORRUPTION displays information about database blocks that were corrupted after the last backup.
—————————————- BACKUP…VALIDATE
Scans the specified files and verifies their contents, testing whether this file can be backed up and whether the data blocks are corrupt. RMAN creates no output files.
This option is equivalent to using the VALIDATE command on the database files specified in the backup. If you do not specify CHECK LOGICAL, then BACKUP..VALIDATE checks for physical corruption only. If you specify CHECK LOGICAL, then BACKUP VALIDATE checks for both physical and logical corruption.
RMAN populates the V$DATABASE_BLOCK_CORRUPTION view with any corruptions that it finds.
You can use the SET MAXCORRUPT command to set a limit for the number of corrupt blocks tolerated during the backup validation. The default is zero.
If you execute BACKUP INCREMENTAL with VALIDATE, then the behavior depends on whether block change tracking is enabled. If change tracking is enabled, then RMAN
validates only changed blocks; otherwise, RMAN validates all blocks in the files included in the backup.
Note: You cannot validate backups of backup sets.
—————————————-
The following prerequisites apply to RECOVER BLOCK: (link)
->The target database must run in ARCHIVELOG mode and be open or mounted with a current control file.
->RMAN can only recover blocks marked media corrupt. The V$DATABASE_BLOCK_CORRUPTION view indicates which blocks in a file were marked corrupt since the most recent BACKUP or BACKUP … VALIDATE command was run against the file.
->The backups of the data files containing the corrupt blocks must be full backups and not proxy backups. If only proxy backups exist, then you can restore them to a nondefault location on disk, in which case RMAN considers them data file copies. You can then use the data file copies for block media recovery.
->RMAN can use only archived redo log files for recovery. Block media recovery cannot survive a missing or inaccessible log, although it can sometimes survive missing or inaccessible records (see Oracle Database Backup and Recovery User#39;s Guide).
->For RMAN to be able to search the flashback logs for good copies of corrupt blocks, Flashback Database must be enabled on the target database.
->For RMAN to be able to search a standby database for good copies of corrupt blocks, the target database must be associated with a physical standby database in a Data Guard environment. In addition, the physical standby database must be open read-only in managed recovery.
Question No: 84 – (Topic 2)
View the Exhibit and examine the Data Pump architecture. Identify the numbered components.
Exhibit:
-
1 – Oracle Loader, 2 – Oracle Data Pump, 3 – Direct Path API
-
1 – Oracle Data Pump, 2 – Direct Path API, 3 – Oracle Loader
-
1 – Direct Path API, 2 – Oracle Loader, 3 – Oracle Data Pump
-
1 – Oracle Loader, 2 – Direct Path API, 3 – Oracle Data Pump
Answer: A
Question No: 85 – (Topic 2)
To enable faster incremental backups, you enabled block change tracking for the database. Which two statements are true about the block change tracking file? (Choose two.)
-
Multiple change tracking files can be created for a database.
-
The change tracking file must be created after the first level 0 backup.
-
RMAN does not support backup and recovery of the change tracking file.
-
The database clears the change tracking file and starts tracking changes again, after whole database restore and recovery operations.
Answer: C,D
Question No: 86 – (Topic 2)
You want to make sure that your database backup does not exceed 10 hours in length. What command would you issue that would meet this condition?
-
backup database plus archivelog;
-
backup database plus archivelog until time 10:00;
-
backup database plus archivelog timeout 10:00;
-
backup database plus archivelog duration 10:00;
-
backup database plus archivelog timeout 10:00;
Answer: D
Question No: 87 – (Topic 2)
What is the purpose of the recover command? (Choose all that apply.)
-
Recover database datafiles from physical disk backup sets.
-
Recover required incremental backups from physical disk backup sets.
-
Recover required archived redo logs from physical disk backup sets.
-
Apply incremental backups to recover the database.
-
Apply archived redo logs to recover the database.
Answer: B,C,D,E
Question No: 88 – (Topic 2)
Which options would you consider while configuring a flash recovery area (fast recovery area in 11g Release 2) for your production database that is running in ARCHIVELOG mode? (Choose all that apply.)
-
Setting the FAST_START_MTTR_TARGET to set the mean time to recover
-
Setting the RECOVERY_PARALLELISM parameter to twice the number of CPUs
-
Using the DB_RECOVERY_FILE_DEST parameter to set the location for flash recovery area
-
Using the DB_RECOVERY_FILE_DEST_SIZE parameter to define the disk space limit for the recovery files created in the flash recovery area
Answer: C,D
Question No: 89 – (Topic 2)
How is block-change tracking enabled?
-
With alter database enable block change tracking
-
With alter system enable block change tracking
-
With an init.ora parameter change
-
With an spfile parameter change
Answer: A
Question No: 90 – (Topic 2)
You run the following commands:
RMANgt; list expired backup; RMANgt; delete expired backup;
What will happen to the backup set pieces associated with the backups that appear in the list expired backup command?
-
They will be renamed.
-
Nothing will happen to them. The backup set pieces do not exist.
-
They will be deleted immediately since they are not in the flash recovery area.
-
You will need to manually remove the physical files listed in the output of the commands.
-
They will become hidden files and removed 10 days later.
Answer: B
100% Ensurepass Free Download!
–Download Free Demo:1z0-053 Demo PDF
100% Ensurepass Free Guaranteed!
–1z0-053 Dumps
EnsurePass | 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 |
100-105 Dumps VCE PDF
200-105 Dumps VCE PDF
300-101 Dumps VCE PDF
300-115 Dumps VCE PDF
300-135 Dumps VCE PDF
300-320 Dumps VCE PDF
400-101 Dumps VCE PDF
640-911 Dumps VCE PDF
640-916 Dumps VCE PDF
70-410 Dumps VCE PDF
70-411 Dumps VCE PDF
70-412 Dumps VCE PDF
70-413 Dumps VCE PDF
70-414 Dumps VCE PDF
70-417 Dumps VCE PDF
70-461 Dumps VCE PDF
70-462 Dumps VCE PDF
70-463 Dumps VCE PDF
70-464 Dumps VCE PDF
70-465 Dumps VCE PDF
70-480 Dumps VCE PDF
70-483 Dumps VCE PDF
70-486 Dumps VCE PDF
70-487 Dumps VCE PDF
220-901 Dumps VCE PDF
220-902 Dumps VCE PDF
N10-006 Dumps VCE PDF
SY0-401 Dumps VCE PDF