MODULE 5

SQL statement keyword that reads data from the database table.

• SELECT

• INSERT

• UPDATE

• DELETE

Which is not an ABAP boolean operator?

• AND

• OR

• NOT

• EQUIV

• None of the above

sy-subrc <> 0 means ...

• Success

• Failure

sy-subrc = 0 means...

• Success

• Failure

Data access is faster when using <fs> so runtime performance is faster than using workarea.

• TRUE

• FALSE

In SELECT... FOR ALL ENTRIES, if the itab of the main query is empty, the entire WHERE condition in the subquery is ignored.

• TRUE

• FALSE

Before using SELECT ... FOR ALL ENTRIES, the itab of the main query should not be sorted and adjacent duplicates shpuld be elimanated.

• TRUE

• FALSE

__________ means the data is selected only if data is found in both tables.

• LEFT OUTER JOIN

• RIGHT OUTER JOIN

• FULL OUTER JOIN

• INNER JOIN

The addition ORDER BY can be used with the addition SINGLE.

• TRUE

• FALSE

In a range table from select-options, what does I in SIGN = I mean?

• IN

• INCLUDE

• EXCLUDE