TAW_10_1 chapter 16, ABAP openSQL

Question 1

What table types cannot be used with the ORDER BY clause?

Answer 1

Cluster and Pooled tables

Question 2

Where does the ORDER BY clause occur?

Answer 2

After the where clause

Question 3

Using ORDER BY PRIMARY KEY requires that what?

Answer 3

All of the fields in the primary key must be in the select list
Only single tables, no views or joins

Question 4

Does MANDT need to be part of the SELECT clause if ORDER BY PRIMARY KEY is used?

Answer 4

Yes…at least that what it says

Question 5

Could I use SELECT DISTINCT on BSEG?

Answer 5

No, it is a cluster table

Question 6

What are the 5 aggregate functions that can be used in a select clause?

Answer 6

MIN (same type as field)
MAX (same type as field)
COUNT (same type as field)
AVG (float)
SUM (type  i)

Question 7

Can DISTINCT be used with the 5 aggregate functions?

Answer 7

Yes, for example Select SUM( DISTINCT

Question 8

What are the restrictions of using the HAVING clause?

Answer 8

Must either use fields from the group by cluse or an aggregate function from the select

Question 9

What are the two characters used in the LIKE clause

Answer 9

_ and %

Question 10

What is the maximum number of tables in a join

Answer 10

50

Question 11

What is the maximum number of subqueries in a select?

Answer 11

50