Certificate Associate Exam - Back-end Developer PT14

Which of the following CAST usages are valid in ABAP SQL? (Multiple answers). CAST( '20240501' AS DATS ). CAST( 42 AS S_MANDT ). CAST( field AS CHAR(10) ). CAST( 'abc' AS INT4 ).

Which statements about using DIV() are correct? (Multiple answers). DIV() can return decimal values. DIV() truncates the remainder. DIV() requires integer inputs. DIV() supports FLTP values.

What is true about DIVISION() in ABAP SQL? (Multiple answers). You can specify how many decimals the result should have. It accepts FLTP inputs. It rounds results using commercial rounding. It returns a decimal value.

Which of the following expressions are invalid without CAST()? (Multiple answers). DEC + INT. FLTP / DEC. FLTP + FLTP. FLTP + INT.

What happens if you mix DEC and FLTP types in one expression without casting? (One correct answer). You get a syntax error. It’s allowed if you wrap in brackets. The expression runs but with a warning. The result is cast to the most precise type automatically.

Which combinations require all operands to be explicitly cast to FLTP for division (/) to work? (Multiple answers). INT / INT. DEC / INT. FLTP / FLTP. INT / FLTP.

What is a correct use of CAST to allow a decimal division? (One correct answer). CAST( quantity AS DEC ) / price. quantity / price. CAST( quantity AS FLTP ) / CAST( price AS FLTP ). quantity + price.

What are the requirements for using DIVISION() safely? (Multiple answers). Input must not be FLTP. Output precision is controlled by a 3rd argument. Result is always an integer. It replaces CAST for type compatibility.

Which result types are correct in the following cases? (Multiple answers). INT + INT → INT. FLTP + INT → error unless cast. FLTP + DEC → FLTP. INT + DEC → DEC.

When should you use DIVISION() instead of /? (Multiple answers). When FLTP values are involved. When you want rounded decimal results. When working with DEC and INT. When precision matters and / is restricted.