SQL Statements Including Update Strategies

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.