Download Oracle.PracticeDumps.1z0-053.2018-03-22.1e.706q.vcex


Download Exam

File Info

Exam Oracle Database 11g: Administration II
Number 1z0-053
File Name Oracle.PracticeDumps.1z0-053.2018-03-22.1e.706q.vcex
Size 16 Mb
Posted March 22, 2018
Downloads 55



How to open VCEX & EXAM Files?

Files with VCEX & EXAM extensions can be opened by ProfExam Simulator.

Purchase
Coupon: EXAMFILESCOM

Coupon: EXAMFILESCOM
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?

  • A: It executes successfully, and the transition point is set to '1-apr-2006'.
  • B: It executes successfully, and the transition point is set to '15-apr-2006'.
  • C: It produces an error because the partitions specified for merging are not adjacent.
  • D: It produces an error because the date values specified in the merge do not match the date values stored in the table.



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?

  • A: ALTER DISKGROUP data CHECK;
  • B: ALTER DISKGROUP data CHECK DISK;
  • C: ALTER DISKGROUP data CHECK FILE;
  • D: ALTER DISKGROUP data CHECK DISK IN FAILURE GROUP 1;



Question 3
Which two statements are true regarding the functionality of the remap command in ASMCMD? (Choose two.)

  • A: It repairs blocks that have read disk I/O errors.
  • B: It checks whether the alias metadata directory and the file directory are linked correctly.
  • C: It repairs blocks by always reading them from the mirror copy and writing them to the original location.
  • D: 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.



Question 4
What is the advantage of setting the ASM-preferred mirror read for the stretch cluster configuration?

  • A: It improves resync operations.
  • B: This feature enables much faster file opens.
  • C: It improves performance as fewer extent pointers are needed in the shared pool.
  • D: It improves performance by reading from a copy of an extent closest to the node.



Question 5
Examine the following command:
ALTER DISKGROUP data MOUNT FORCE; 
In which scenario can you use the above command to mount the disk group?

  • A: when ASM disk goes offline
  • B: when one or more ASM files are dropped
  • C: when some disks in a disk group are offline
  • D: when some disks in a failure group for a disk group are rebalancing



Question 6
Which background process of a database instance, using Automatic Storage Management (ASM), connects as a foreground process into the ASM instance?

  • A: ASMB
  • B: PMON
  • C: RBAL
  • D: SMON



Question 7
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.



Question 8
Identify three key features of ASM. (Choose three.)

  • A: file striping
  • B: allocation unit mirroring
  • C: automatic disk rebalancing
  • D: automatic file size increment
  • E: automatic undo management



Question 9
You have three production databases, HRDB, FINDB, and ORGDB, that use the same ASM instance. At the end of the day, while all three production database instances are running, you execute the following command on the ASM instance:
SQL> shutdown immediate; 
What is the result of executing this command?

  • A: The ASM instance is shut down, but the other instances are still running.
  • B: It results in an error because other database instances are connected to it.
  • C: All the instances, including the ASM instance, are shut down in the IMMEDIATE mode.
  • D: HRDB, FINDB, and ORGDB instances are shut down in the ABORT mode and the ASM instance is shut down in the IMMEDIATE mode.



Question 10
You are managing an ASM instance. You previously issued the following statements:
ALTER DISKGROUP dg1 DROP DISK disk2; 
ALTER DISKGROUP dg1 DROP DISK disk3; 
ALTER DISKGROUP dg1 DROP DISK disk5; 
You want to cancel the disk drops that are pending for the DG1 disk group. 
Which statement should you issue?

  • A: ALTER DISKGROUP dg1 UNDROP disk2, disk3, disk5;
  • B: ALTER DISKGROUP dg1 UNDROP;
  • C: ALTER DISKGROUP dg1 UNDROP DISKS;
  • D: You cannot cancel the pending disk drops.








ProfExam
PROFEXAM WITH A 20% DISCOUNT

You can buy ProfExam with a 20% discount..

Get Now!


HOW TO OPEN VCEX AND EXAM FILES

Use ProfExam Simulator to open VCEX and EXAM files
ProfExam Screen



HOW TO OPEN VCE FILES

Use VCE Exam Simulator to open VCE files
Avanaset