Free SAP C-TAW12-740 Exam Dumps Questions & Answers

tableA and tableB are partially buffered. Which of the following SELECT statements always access tha database?

• A.  SELECT a b FROM tableA INTO CORRESPONDING FIELDS OF TABLE It_A_B
• B.  SELECT abed FROM tableA JOIN tableB ON tableA~a = tableB~e INTO CORRESPONDING FIELDS OF TABLE It_A_B
• C.  SELECT SINGLE CLIENT SPECIFIELD a b FROM tableA INTO CORRESPONDING FIELDS OF Is_A_B
• D.  SELECT SINGLE FOR UPDATE a b FROM tableA INTO CORRESPONDING FIELDS OF Is_A_B WHERE c EQ'1234'.

Which of the following structures is created when you use a table type to define one of its components?

• A.  Nested structure
• B.  Deep structure
• C.  Flat structure
• D.  Append structure

What features are provided by the database interface? (Choose three)

• A.  Conversion of Open SQL statements from ABAP statements into the corresponding database statements
• B.  Database independence of application programs
• C.  Data consistency check using foreign key relationships
• D.  Syntax check of Native SQL commands
• E.  Access to SAP table buffers

Which of the following statement can you use to set up checkpoints in an ABAP program?

• A.  LOG-POINT
• B.  BREAK
• C.  ASSERT
• D.  BREAK-POINT
• E.  CHECK

When does SAP recommend that you use a full buffering type for a database table?

• A.  When the table is very small and frequently written
• B.  When the table is very large and seldom written
• C.  When the table is very small and seldom written
• D.  When the table is very large and frequently written