SAP
C_HANAIMP151 · Question #222
C_HANAIMP151 Question #222: Real Exam Question with Answer & Explanation
Sign in or unlock C_HANAIMP151 to reveal the answer and full explanation for question #222. The question stem and answer options stay visible for context.
Question
A customer wants to reproduce the following SQL statement in SAP HANA: SELECT P.PROD_NAME, P.PROD_ID, PT.PROD_DESC FROM PRODUCTS P, PROD_TEXTS PT WHERE P.PROD_ID=PT.PROD_ID; Which of the following SQLScript constructs is equivalent to this SQL statement and yields the best performance?
Options
- Aot_products= CE_COLUMN_TABLE(PRODUCTS);
- BSELECT P.PROD_NAME, P.PROD_ID, NULL as PROD_DESC
- CSELECT P.PROD_NAME, P.PROD_ID, PT.PROD_DESC FROM PRODUCTS P
- Dot_products= CE_COLUMN_TABLE(PRODUCTS);
Unlock C_HANAIMP151 to see the answer
You've previewed enough free C_HANAIMP151 questions. Unlock C_HANAIMP151 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.