File Info
| Exam | Oracle Database 11g: Administration II |
| Number | 1z0-053 |
| File Name | Oracle.1z0-053.NewDumps.2018-03-22.706q.tqb |
| Size | 19 MB |
| Posted | Mar 22, 2018 |
| Download | Oracle.1z0-053.NewDumps.2018-03-22.706q.tqb |
How to open VCEX & EXAM Files?
Files with VCEX & EXAM extensions can be opened by ProfExam Simulator.
Coupon: MASTEREXAM
With discount: 20%
Demo Questions
Question 1
The INV_HISTORY table is created using the command:
The following data has been inserted into the INV_HISTORY table:
You would like to store the data belonging to the year 2006 in a single partition and issue the command:
SQL> ALTER TABLE inv_history
MERGE PARTITIONS
FOR(TO_DATE('15-feb-2006','dd-mon-yyyy')),
FOR(TO_DATE('15-apr-2006'))
INTO PARTITION sys_py;
What would be the outcome of this command?
- It executes successfully, and the transition point is set to '1-apr-2006'.
- It executes successfully, and the transition point is set to '15-apr-2006'.
- It produces an error because the partitions specified for merging are not adjacent.
- It produces an error because the date values specified in the merge do not match the date values stored in the table.
Correct answer: C
Question 2
You want to perform the following operations for the DATA ASM disk group:
- Verify the consistency of the disk.
- Cross-check all the file extent maps and allocation tables for consistency.
- Check whether the alias metadata directory and file directory are linked correctly.
- Check that ASM metadata directories do not have unreachable allocated blocks.
Which command accomplishes these tasks?
- ALTER DISKGROUP data CHECK;
- ALTER DISKGROUP data CHECK DISK;
- ALTER DISKGROUP data CHECK FILE;
- ALTER DISKGROUP data CHECK DISK IN FAILURE GROUP 1;
Correct answer: A
Explanation:
Syntax: ALTER DISKGROUP <disk_group_id> CHECK [REPAIR | NOREPAIR];The check_diskgroup_clause lets you verify the internal consistency of Oracle ASM disk group metadata. The disk group must be mounted. Oracle ASM displays summary errors and writes the details of the detected errors in the alert log. The CHECK keyword performs the following operations:Checks the consistency of the disk. Cross checks all the file extent maps and allocation tables for consistently. Checks that the alias metadata directory and file directory are linked correctly. Checks that the alias directory tree is linked correctly. Checks that Oracle ASM metadata directories do not have unreachable allocated blocks. Syntax: ALTER DISKGROUP <disk_group_id> CHECK [REPAIR | NOREPAIR];
The check_diskgroup_clause lets you verify the internal consistency of Oracle ASM disk group metadata. The disk group must be mounted. Oracle ASM displays summary errors and writes the details of the detected errors in the alert log.
The CHECK keyword performs the following operations:
- Checks the consistency of the disk.
- Cross checks all the file extent maps and allocation tables for consistently.
- Checks that the alias metadata directory and file directory are linked correctly.
- Checks that the alias directory tree is linked correctly.
- Checks that Oracle ASM metadata directories do not have unreachable allocated blocks.
Question 3
Which two statements are true regarding the functionality of the remap command in ASMCMD? (Choose two.)
- It repairs blocks that have read disk I/O errors.
- It checks whether the alias metadata directory and the file directory are linked correctly.
- It repairs blocks by always reading them from the mirror copy and writing them to the original location.
- It reads the blocks from a good copy of an ASM mirror and rewrites them to an alternate location on disk if the blocks on the original location cannot be read properly.
Correct answer: AD
Explanation:
Reference from the Oracle document release v11.1 at here:Repairs a range of physical blocks on a disk. The remap command only repairs blocks that have read disk I/O errors. It does not repair blocks that contain corrupted contents, whether or not those blocks can be read. The command assumes a physical block size of 512 bytes and supports all allocation unit sizes (1 to 64 MB). Reference from the Oracle document release v11.2 at here:The remap command marks a range of blocks as unusable on the disk and relocates any data allocated in that range. Reference from the Oracle document release v11.1 at here:
Repairs a range of physical blocks on a disk. The remap command only repairs blocks that have read disk I/O errors. It does not repair blocks that contain corrupted contents, whether or not those blocks can be read. The command assumes a physical block size of 512 bytes and supports all allocation unit sizes (1 to 64 MB).
Reference from the Oracle document release v11.2 at here:
The remap command marks a range of blocks as unusable on the disk and relocates any data allocated in that range.
