Certificate Associate Exam - Back-end Developer PT10

<ABAP SQL in Cloud> Which type of SQL is permitted in ABAP Cloud?. Any SQL inside FORM routines. Dynamic SQL with EXEC. Open SQL. Native SQL.

<JOIN Syntax> Which of the following is a correct way to write a JOIN in ABAP Open SQL?. JOIN mara TO makt ON mara.matnr = makt.matnr. SELECT mara~matnr, makt~maktx FROM mara INNER JOIN makt ON mara~matnr = makt~matnr. SELECT * FROM mara JOIN makt ON mara~matnr = makt~matnr. SELECT * FROM mara, makt WHERE mara.matnr = makt.matnr.

ABAP SQL Features Which of the following are supported in Open SQL? (Select all that apply). Use of path expressions for associations. Use of CDS views. Using joins between unreleased tables. Using scalar functions like CONCAT.

<Data Access Performance> What does code pushdown mean in the context of ABAP and CDS?. Delaying code execution until after user interaction. Executing logic at the database level to improve performance. Moving logic to the client-side browser. Moving code execution to the SAP GUI.

<Filtering in CDS> How can you apply a WHERE clause in a CDS view?. CDS doesn’t support filters. Using @where: condition annotation. In the ABAP program calling the CDS view. Using FILTER statement inside the SQL view.

SELECT SINGLE vs SELECT UP TO 1 ROWS What is the difference between SELECT SINGLE and SELECT ... UP TO 1 ROWS?. SELECT SINGLE supports ORDER BY. SELECT SINGLE reads based on key fields only. SELECT ... UP TO 1 ROWS is faster. SELECT SINGLE returns multiple entries.

<Use of Associations> How do you access a field from an association in a CDS view?. JOIN _association ON field. _association.field. _association->field. SELECT field FROM _association.field.

<CDS View and ABAP SQL> What is the advantage of querying CDS views instead of base tables directly?. CDS views are easier to write than Open SQL. CDS views provide semantic layers, reusable logic, and annotations. CDS views offer UI enhancements. CDS views store data permanently.

<FOR ALL ENTRIES> Which of the following is true about FOR ALL ENTRIES?. It executes the SELECT for each line of the internal table. It automatically performs joins between tables. It cannot be used in ABAP Cloud. It requires at least one key field in the WHERE clause.

<ABAP SQL Restrictions in Cloud> Which of the following are NOT allowed in ABAP Cloud SQL? (Select all that apply). SELECT from unreleased tables. SELECT from released CDS views. SELECT using INNER JOIN. SELECT using native SQL.