|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.