Update tasks are the only method of making changes to the database. True False.
Which statement is true? A database LUW must be placed within an SAP LUW. An SAP LUW must be placed within a database LUW.
Which actions release a database lock? Select all that apply. COMMIT WORK ROLLBACK WORK The display of an SAP screen The display of a dialog message type E The display of a dialog message type A ENQUEUE_<lock_object> DEQUEUE_<lock_object> A CALL TRANSACTION A SUBMIT An “/n” in the command field.
Which actions release a lock object (with a default value for _SCOPE)? Select all that apply. COMMIT WORK ROLLBACK WORK The display of an SAP screen The display of a dialog message type E The display of a dialog message type A ENQUEUE_<lock_object> DEQUEUE_<lock_object> A call to a function module A CALL TRANSACTION An “/n” in the command field.
How can you implement a table join other than by using the JOIN statement? Fill in the blank.
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 is an ENDSELECT 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 a 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.
Buffering data can speed up access to data up to 100 times when compared to reading it from the database. 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 a lock object? 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 them when doing background or en masse changes, as there is no COMMIT WORK that will occur. True False.
Database access can occupy the majority of runtime in an ABAP program. Which tools are available to assist you to diagnose performance issues in your program? Select all that apply. ABAP Objects Runtime Analysis (Transaction SE30) ABAP Objects Runtime Analysis (Transaction ATRA) Performance Trace (Transaction ST05) ABAP Trace (Transaction SAT).
An SAP LUW differs from a database LUW in that it allows for multiple screens to be processed. True False.
Beginning with SAP NetWeaver 7.40, if SAP HANA (an in-memory database) is being used as a database, then table buffering is no longer effective and is therefore not possible. True False.