Using Code Pushdown in ABAP SQL

1.

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

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.

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

4.

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 )

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.

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.

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

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?

Which of the following statements is true?

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?

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

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?

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

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?