READ Free Dumps For Oracle- 1z0-485

Question ID 3068	How does partition pruning, a 11gR2 database feature, help to improve performance on an Exadata Database Machine?
Option A	A.    Partition pruning allows you to reduce a 5 TB I/O operation to a much smaller I/O operation and therefore, enables a much faster return of information.
Option B	B.    Using partition pruning can force the optimizer to use that method instead of Smart Scan. Partitioning in Exadatashould be used wisely
Option C	C.    Partition pruning is not a supported option in the11gR2database codethatruns on an Exadata Machine, due to issues with Cost Based Optimizer plans.
Option D	D.    Partition pruning allows you to reduce the size of the physical table by reducing fragmentation within the individual tables.
Option E	E.    Partition pruning allows you to reduce a 5 TB I/O operation to a larger I/O operation and therefore, forces the use of the Smart Scan technology.
Correct Answer	E

Explanation

Question ID 3069	Identify the correct steps required to upgrade a 1/8th rack of Exadata to a 1/4th rack.
Option A	A.    Remove the doors of the 1/8th rack. Add the new servers. Cable the Database Servers in the rack. Cable the Exadata Storage Servers in the rack. Close the rack.
Option B	B.    Activate all cores by using a software command. Activate all hard drives and flash drives. Create the grid disks. Expand the Oracle ASM diskgroups. Review the new configuration.
Option C	C.    Remove the doors of the 1/8th rack. Add an additional Sun Datacenter InfiniBand Switch. Add the new servers. Cable the Database Servers in the rack. Cable the Exadata Storage Servers in the rack. Close the rack. Configure the new hardware.
Option D	D.    Activate all cores by using a software command. Activate all hard drives and flash drives.
Correct Answer	B

Explanation

Previous-Page 1 2. . . 13 14 15 16 17 18 19. . . 35 36 Next-Page

Send email to admin@getfreedumps for new dumps request!!!