Certificate Associate Exam - Back-end Developer PT16

Which of the following are valid ABAP SQL join types? (Multiple answers). INNER JOIN. OUTER JOIN. LEFT OUTER JOIN. RIGHT OUTER JOIN.

What is the purpose of the ON clause in a JOIN statement?. It specifies the columns that define how two tables are related. It filters rows after the join is complete. It acts like a WHERE condition but inside the JOIN. It identifies which rows to exclude from the result set.

You want to join /DMO/CARRIER and /DMO/CONNECTION, both of which have a column called CARRIER_ID. Which of the following is required in the SELECT list or conditions?. You must prefix both fields with their table or alias name. You can omit the prefix if the field names are the same. You only need to prefix the field from the left-hand table. ABAP SQL automatically distinguishes between them.

What happens if you omit the ON clause when writing a JOIN in ABAP SQL?. The system throws a syntax error. The system uses NATURAL JOIN behavior. The system joins all rows from both tables. The join condition is inferred from the field names.

In a SELECT statement, which of the following expressions are valid to calculate the number of available seats? (Multiple answers). seats_max - seats_occupied AS seats_available. CAST( seats_max AS FLTP ) - seats_occupied AS seats_available. DIV( seats_max, seats_occupied ) AS seats_available. MOD( seats_occupied, seats_max ) AS seats_available.

Which of the following statements about LEFT OUTER JOIN are true? (Multiple answers). It includes all rows from the right-hand table, even if there's no match on the left. It includes all rows from the left-hand table, even if there's no match on the right. It will insert nulls for the missing right-hand table values. It is identical in result to INNER JOIN if all values match.

What is the effect of using aliases in a JOIN?. They simplify syntax by shortening table names. They are required when joining a table with itself. They allow columns with the same name to be uniquely referenced. They remove the need to use the ON clause.

Which of the following are considered best practices when writing JOIN statements? (Multiple answers). Use aliases to improve readability. Always include the ON clause. Avoid JOINs when working with two small tables. Use brackets in nested joins to clarify evaluation order.

You want to extract the year from a field of type DATS using JOIN results. What must you do?. Use LEFT( date_field, 4 ) directly. Use SUBSTRING( date_field, 1, 4 ) directly. Use LEFT( CAST( date_field AS CHAR(8) ), 4 ). Use CAST( date_field AS INT4 ) and divide by 10000.

Which of the following would cause a syntax error in a JOIN? (Multiple answers). Using a JOIN without an ON condition. Mixing FLTP and INT in an arithmetic expression without casting. Selecting columns with the same name from both tables without prefix or alias. Using LEFT JOIN instead of LEFT OUTER JOIN.