| Update tasks are the only way to make 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 DEQUEUE_<lock_object> AND ENQUEUE_<lock_object> A call to a function module 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 DEQUEUE_<lock_object> A call to a function module A CALL TRANSACTION A SUBMIT 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 specify a join of tables 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 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.
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 most of the 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).
Which statement cannot use a subquery SELECT UPDATE DELETE INSERT None of the above.
Which statement cannot use a subquery 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.