Certificate Associate Exam - Back-end Developer PT15

In an ABAP SQL INNER JOIN, which condition must always be explicitly stated using ON?. The join condition must compare primary keys of both tables. The join condition must link fields from both tables using a condition. The join condition is optional if the tables share the same field names. The join automatically joins on the first matching column names.

In ABAP SQL, what happens if you perform a calculation like seats_max / seats_occupied without casting, assuming both fields are of type INT?. It will return a decimal result with automatic precision. It will work fine and return an integer result. It will cause a runtime error. It will throw a syntax error because / is only allowed with FLTP operands.

You want to calculate a percentage of occupied seats in ABAP SQL like this: (seats_occupied * 100) / seats_max Which of the following statements is correct?. You must use CAST() to convert all operands to FLTP to avoid syntax errors. You can perform this calculation directly as long as you use the DIVISION() function. You only need to cast the literal 100 to FLTP; the rest will adjust automatically. This calculation works as-is with integer fields in ABAP SQL.

You want to calculate a percentage of occupied seats in ABAP SQL using the formula: (seats_occupied * 100) / seats_max Which of the following statements are correct? (Multiple answers possible). You must use CAST() to convert all operands to FLTP when using /. You can replace the expression with DIVISION( seats_occupied * 100, seats_max, 2 ) to get a rounded decimal result. You only need to cast the literal 100 to FLTP; the rest adjusts automatically. If all operands are INT, the expression works fine and returns an integer.

You're joining the tables /DMO/CARRIER and /DMO/CONNECTION using an INNER JOIN to read each flight's carrier name and compute available seats. Which of the following statements are correct? (Multiple answers possible). The join condition must be written using ON c~carrier_id = cn~carrier_id or similar. You can perform arithmetic in the FIELD list, like seats_max - seats_occupied AS seats_available. If both tables contain the field CARRIER_ID, you must prefix them with the table or alias name. Arithmetic expressions in the SELECT list automatically cast INT to DEC if one operand is a decimal.

You’re working with a join of multiple tables and want to calculate the rounded percentage of occupied seats using either / or DIVISION(). Which of the following are correct? (Multiple answers possible). If using /, all operands must be explicitly cast to FLTP. DIVISION() cannot include arithmetic operations inside its parameters. DIVISION( seats_occupied * 100, seats_max, 2 ) is a valid expression. Using / with INT fields will work if at least one of them is a literal like 100.