Using Code Pushdown in ABAP SQL

1.

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

Choose the correct answer.

Never, alias names for data sources are always optional.

If the join contains the same data source more than once.

If the same field name occurs in multiple data sources.

Always, alias names for data sources are always mandatory.

2.

Which of the following statements is true?

Choose the correct answer.

The ABAP Dictionary contains exactly the same number of predefined data types as the ABAP language.

There are more predefined data types in the ABAP Dictionary than in the ABAP language.

There are more predefined data types in the ABAP language than in the ABAP Dictionary.

3.

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

Choose the correct answer.

SUBSTRING( text_field, 0, 1 )

SUBSTRING( text_field, 1, 1 )

SUBSTRING( text_field, 1, 0 )

4.

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.

GROUP BY field1

GROUP BY field1, field2

GROUP BY field1, field2, field3

5.

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.

numeric function DIV( )

operator /

numeric function DIVISION( )

6.

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.

DATS

DATN

TIMS

TIMESTAMPL

UTCLONG

7.

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.

the sequence of data sources

the sequence of ON conditions

Knowledge quiz

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

Which of the following statements is true?

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

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?

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?

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?

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?