Download Oracle Database 11g: Administration II.1z0-053.TestInside.2018-12-04.702q.tqb

Vendor:	Oracle
Exam Code:	1z0-053
Exam Name:	Oracle Database 11g: Administration II
Date:	Dec 04, 2018
File Size:	19 MB

Download Exam

How to open VCEX files?

Files with VCEX extension can be opened by ProfExam Simulator.

Download
ProfExam Simulator

Purchase
Coupon: EXAM_HUB

Discount: 20%

Demo Questions

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

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.

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.

CONNECT US

HOW TO OPEN VCE FILES

Use VCE Exam Simulator to open VCE files
Avanaset