Analyzing and Testing Code
Using Data Types and Type Conversions Correctly
Processing Character Fields
Using Code Pushdown in ABAP SQL
Improving Internal Table Performance
Implementing Authorization Checks
Designing Effective Object-Oriented Code
Defining and Working with Exception Classes
Adding Documentation to ABAP Code

Knowledge quiz

It's time to put what you've learned to the test, get 6 right to pass this unit.

1.

You analyze a SELECT statement in your ABAP code. The FROM clause contains a nested join but there are no brackets. What do you look at to find out in which sequence the joins are evaluated?

Choose the correct answer.
2.

When are you forced to define alias names for the data sources of a join?

Choose the correct answer.
3.

Which of the following statements is true?

Choose the correct answer.
4.

EXTRACT_MONTH( ) is a generic SQL function which can handle input of different types. Which of the following built-in types are allowed for this function?

There are three correct answers.
5.

Your ABAP SQL SELECT statement contains the following FIELDS list: field1, field2, sum( field4 ). Only one of the following GROUP BY clauses causes a syntax error. Which one?

Choose the correct answer.
6.

You want to calculate the ratio of two numeric values in ABAP SQL. The result should be rounded to exactly 1 decimal. What do you use to calculate the division?

Choose the correct answer.
7.

Which of the following uses of SQL function SUBSTRING( ) returns the same result as LEFT( text_field, 1 )?

Choose the correct answer.
Learning
SAP FacebookSAP YoutubeSAP LinkedIn