ABAP 7.5 SQL Statements and Update Strategies

Update tasks are the only way to make changes to the database. True. False.

Which statement is true?. A database LUW (logical unit of work) must be placed within a SAP LUW. A SAP LUW must be placed within a Database LUW.

Which Actions release a database lock? Select all that apply. COMMIT WORK or ROLLBACK WORK. /n in the command field. Display of a SAP Screen. Display of a Dialog Message type E. Display of a Dialog Message type A. ENQUEUE_<lock_object>. DEQUEUE_<lock_object>. A call to a function module. CALL TRANSACTION. SUBMIT.

Which Actions release a lock object (with a default value for _SCOPE)? Select all that apply. COMMIT WORK or ROLLBACK WORK. /n in the command field. Display of a SAP Screen. Display of a Dialog Message type E. Display of a Dialog Message type A or X. ENQUEUE_<lock_object>. DEQUEUE_<lock_object>. A call to a function module. CALL TRANSACTION. SUBMIT.

How can you implement a table join other than by using the JOIN statement?. By creating A DATABASE VIEW that corresponds to a table join. By using the Join Statement in SELECT statement.

The Data buffered on each application server... Is always the same. Is never the same. Depends on the users.

The target structure of a select statement requires the field names to match the columns selected and to be in the same left-justified order. True. False.

When an ENDSELECT is not required for a SELECT? Select all that apply. When the FROM is a view. When you specify a join of tables. When you do a SELECT SINGLE. When you specify INTO a table. When you specify APPENDING TABLE.

The database always uses the primary key when the WHERE clause contains any of the key fields. True. False.

Open SQL does not allow you to specify a secondary index during a SELECT. True. False.

You should always buffer database tables that contain fewer than 100 records. True. False.

All open SQL commands allow processing on multiple rows. True. False.

The _WAIT parameter of a lock object waits for the lock to be successful. True. False.

It is recommended that you place the COMMIT WORK in the update task. True. False.

It is possible to PERFORM <subroutine> ON COMMIT in an update task. True. False.

What is the correct order for using lock objects?. Read the data, set the lock, change the data, release the lock. Set the lock, read the data, change the data, release the lock. Set the lock, read the data, release the lock, change the data.

Local update tasks are quicker because they stay within the same work process. True. False.

V1 update tasks are always non-restartable, whereas V2 update tasks are always restartable. True. False.

Lock objects are only required when doing dialog programming; SAP's best practice does not require then when doing background or mass changes, as there is no COMMIT WORK that will occur. True. False.

Database access can occupy most of the runtime in an ABAP program. Which tools are availableto assist you to diagnose performance issues in you program? Select all that apply. ABAP Objects Runtime Analysis (TC: SE30). ABAP Objects Runtime Analysis (TC: ATRA). Performance Trace (TC: ST05). ABAP Trace (TC: SAT).

Which statement cannot use a subquery?. SELECT. UPDATE. DELETE. INSERT. None of the above.

Buffering data can speed access to data up to 100 times when compared to reading it from the database. True. False.

Beginning with SAP NetWeaver 7.40, if SAP HANA is being used as a database, then table buffering is no longer effective and therefore is not possible. True. False.

A SAP LUW differs from a Database LUW in that it allows for multiple screens to be processed. True. False.