Which of the following are valid ABAP SQL type conversions? Note: There are 3 correct answers to this question.

• A.CAST (field_f2 as N (8)) AS f_n8
• B.CAST (29 as INT8) AS f_int8
• C.CAST (field_f5 as DEC (15,2)) AS f_dec_15_2
• D.CAST (34 as I) AS f_i34
• E.CAST ('field_f1' as CHAR (8))) AS f_chars

Comment: *

Name: *

Email: *

Verification: *

Which restrictions exist for ABAP SQL arithmetic expressions? Note: There are 2 correct answers to this question.

• A.Floating point types and integer types can NOT be used in the same expression.
• B.The operator/is allowed only in floating point expressions.
• C.Decimal types and integer types can NOT be used in the same expression.
• D.The operator is allowed only in floating point expressions.

Comment: *

Name: *

Email: *

Verification: *

In RESTful Application Programingg, a business object contains which parts? Note: There are 2 correct answers to this question.

• A.Process definition
• B.CDS view
• C.Authentication rules
• D.Behaviour definition

Comment: *

Name: *

Email: *

Verification: *

When you join two database tables, which of the following rules applies to the database fields you use in the join?

• A.They must be at the same position in their table, for example left_table-col1 = right_table-col1.
• B.They must always have an alias name.
• C.They must have the same name, e.g. col1 = col1.
• D.They must be compared with an ON condition.

Comment: *

Name: *

Email: *

Verification: *

You have two database tables - ZDEPARTMENTS and ZEMPLOYEES. They are linked by a foreign key relationship: ZEMPLOYEES is the foreign key table and ZDEPARTMENTS is the check table. A department may have any number of employees (including none at all).
What is the correct cardinality of the foreign key relationship?

• A.[0..,1]
• B.(0..1,1)
• C.(1..1,1)
• D.(1..,1)

Comment: *

Name: *

Email: *

Verification: *