You modify an Application Engine program to use parallel processing with temporary tables. The Application Engine program includes this code snippet, which is part of a SQL statement that inserts rows
into a temporary table.
INSERT INTO PS_CRS_FULL_TMP
What changes do you need to make to the code so that the Application Engine program will implement parallel processing properly?
A. No changes to the code are needed as long as the temporary table has been properly configured for parallel processing.
B. Replace INSERT INTO PS_CRS_FULL_TMP with %INSERT INTO PS_CRS_FULL_TMP so that the meta-SQL resolves to the correct state record at run time.
C. Replace INSERT INTO PS_CRS_FULL_TMP with %INSERT INTO %Table(CRS_FULL_TMP) so that the system variables resolve to the correct syntax at run time.
D. Replace INSERT INTO PS_CRS_FULL_TMP with INSERT INTO %Table(CRS_FULL_TMP) so that the meta-SQL resolves to the correct temporary table instance at run time.
E. Replace INSERT INTO PS_CRS_FULL_TMP with %INSERT INTO %Temp(CRS_FULL_TMP) so that the meta-SQL resolves to the correct syntax and temporary table instance at run time.
|
Download Printable PDF. VALID exam to help you PASS. |
 |