Explanation/Reference:
The following example creates pyramid data for a GeoRaster object.
DECLARE
gr sdo_georaster;
BEGIN
SELECT georaster INTO gr
FROM georaster_table WHERE georid = 6 FOR UPDATE;
-- Generate pyramids.
sdo_geor.generatePyramid(gr, 'rLevel=5, resampling=NN');
-- Update the original GeoRaster object.
UPDATE georaster_table SET georaster = gr WHERE georid = 6;
COMMIT;
END;
Incorrect Answers:
A, C: Must use rLevel, not PyramidLevel.
rLevel (for example, rLevel=2): Specifies the maximum reduction level: the number of pyramid levels to create at a smaller (reduced) size than the original object.
B: Use a separate sdo_geor.generatePyramid statement to generate the pyramids, and a separate UPDATE statement to update the GeoRaster object.
D: Must use a UPDATE statement to update the Georaster object.
References: http://docs.oracle.com/cd/B28359_01/appdev.111/b28398/geor_ref.htm#CHEDFEAI