Knowledge quiz

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

Q1.
Which of the following uses of SQL function SUBSTRING( ) returns the same result as LEFT( text_field, 1)?
Choose the correct answer.
Q2.
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.
Q3.
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.
Q4.
When are you forced to define alias names for the data sources of a join?
Choose the correct answer.
Q5.
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.
Q6.
Which of the following statements is true?
Choose the correct answer.
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?
Choose the correct answer.

Log in to track your progress & complete quizzes