It’s time to put what you’ve learned to the test, get 6 questions right to pass this unit.
Q1.
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.
A
TIMESTAMPL
B
DATN
C
TIMS
D
DATS
E
UTCLONG
Q2.
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.
A
GROUP BY field1
B
GROUP BY field1, field2
C
GROUP BY field1, field2, field3
Q3.
When are you forced to define alias names for the data sources of a join?
Choose the correct answer.
A
Always, alias names for data sources are always mandatory.
B
If the same data sources is used more than once.
C
If a field name is used in several data sources.
D
Never, alias names for data sources are always optional.
Q4.
You analyze ABAP code with an ABAP SQL SELECT. The FROM clause contains a nested joins but there are no brackets. What do you look at to find out in which sequence the joins are evaluated?
Choose the correct answer.
A
The sequence of data sources
B
the sequence of ON conditions
Q5.
Which of the following uses of SQL function SUBSTRING( ) returns the same result as LEFT( text_field, 1)?
Choose the correct answer.
A
SUBSTRING(text_field, 1, 1 )
B
SUBSTRING(text_field, 1, 0 )
C
SUBSTRING(text_field, 0, 1 )
Q6.
Which of the following statements is true?
Choose the correct answer.
A
There are more predefined types in the ABAP language than in the ABAP Dictionary.
B
There is exactly the same number of predefined types in the ABAP Dictionary than in the ABAP language.
C
There are more predefined types in the ABAP Dictionary than in the ABAP language.
Q7.
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?