TAW_11 Chapter 5, Database updates with ABAP open sql

Question 1

Open SQL is comprised of both DML and DDL commands

Answer 1

False, OPENSQL is only the DML commands The DDL commands are part of the data dictionary

Question 2

What clause has replaced CLIENT SPECIFIED

Answer 2

USING CLIENT ###

Question 3

DB INSERT uses what for the values

Answer 3

Using VALUES or FROM or FROM TABLE

Question 4

If ACCEPTING DUPLICATE KEYS is added does it mean that the database will contain duplicates?

Answer 4

No, it just means that the insert wont fail if a duplicate is found, The duplicate will not be inserted and the process will continue. A sy-subrc of 4 will be returned but you can check sy-dbcnt to make sure the records have been inserted

Question 5

What are the variants of the DB UPDATE

Answer 5

SET fld1 = val1
where...
or
UPDATE tab1 from 
UPDATE tab1 from