SAP Certified Development Specialist – ABAP for SAP HANA 2.0 — Question 2

Which functional problem can you detect when using the Runtime Check Monitor (SRTCM)?

Answer options

• A. Use of Native SQL and DB Hints
• B. Existence check for Secondary Indexes
• C. Direct access to Table Pools/Cluster
• D. Missing ORDER BY or SORT after SELECT

Correct answer: D

Explanation

The correct answer is D because the Runtime Check Monitor (SRTCM) specifically checks for SQL queries that lack proper ordering, which can lead to unpredictable results. Options A, B, and C do not pertain to functional issues detected by SRTCM; they relate to SQL optimization and database structure checks rather than query execution order.