Certificate Associate Exam - Back-end Developer PT13

Which of the following expressions require CAST() to avoid syntax errors in ABAP SQL? (Multiple answers). seats_occupied / seats_max. seats_max - seats_occupied. CAST( 100 AS FLTP ) * seats_occupied / CAST( seats_max AS FLTP ). seats_occupied * 100.

Which of the following are true about DIV() and DIVISION() in ABAP SQL? (Multiple answers). DIV( a, b ) performs commercial rounding. MOD( a, b ) returns the remainder of a division. DIVISION( a, b, 2 ) rounds result to 2 decimals. Both DIV and DIVISION accept FLTP operands.

What are the valid rules regarding arithmetic result types in ABAP SQL? (Multiple answers). INT + INT → result is INT. DEC + INT → result is DEC. Mixing FLTP with INT or DEC is allowed without CAST. FLTP + FLTP → result is FLTP.

Which expressions about CAST are correct in ABAP SQL? (Multiple answers). You can use CAST( ... AS DATS ) even if the value is not a real date. Dictionary data elements (like S_MANDT) can be used as target types in CAST. Mixing incompatible types in CAST can cause runtime errors. You must cast date fields to use them in string functions like SUBSTRING().

What statements are true about using the / division operator in ABAP SQL? (Multiple answers). It is allowed between any numeric types. It only works in expressions where all operands are FLTP. You must use CAST to FLTP before using /. It is allowed between INT and DEC without CAST.

What are true behaviors of the && operator in ABAP SQL string handling? (Multiple answers). It adds a space automatically between strings. It ignores trailing blanks in fields. You can use it to combine strings, literals, and function results. It only works if both operands are CHAR types.

What can CONCAT_WITH_SPACE() do that CONCAT() and && cannot? (One correct answer). Combine more than two strings at once. Add a blank between values automatically. Work with numeric values. Remove extra trailing blanks.

What is the result of LEFT( CAST( date_field AS CHAR(8) ), 4 ) if the date is '20240422'?. '2024'. '0422'. '04-22'. '22-04'.

Which of the following will cause syntax errors if used without conversion? (Multiple answers). INT + INT. DEC + INT. FLTP + DEC. FLTP / DEC.

What are true statements about string functions in ABAP SQL?. INITCAP() capitalizes only the first letter of the first word. LOWER() and INITCAP() produce the same result. RIGHT( str, 3 ) returns the last 3 characters. UPPER() transforms all letters to uppercase.