The Open SQL set of commands comprise operations for both Data Manipulation Language (DML) and Data Definition Language (DDL). True False.
Accessing the database with Native SQL enables you to use database-specific commands. True False.
You can limit the target quantity on the database by using all the Native SQL commands. T F.
Which keyword is used to update specific fields of a database table from a work area? Using SET Client-Specific.
Which of the following statements provides two variants for changing a specific record within a database table? COMMIT ROLLBACK UPDATE MODIFY.
What are the methods that will cause a database rollback? Sending a termination dialog message (A or X Message Updating a data record Using the ROLLBACK WORD ABAP statement Inserting the variant.
An SAP Logical Unit of Work (LUW) consists of changes based on the “all or nothing principle”. T F.
Which of the following ends the database LUW and confirms the current database status? Database rollback Database LUW Database table Database commit.
In the case of an error during a database update, which function would you use to restore the previous (consistent) database status? DB LUW DB ROLLBACK DB TABLE DB COMMIT.
What are the three levels of an Application Server ABAP based on a client/server architecture? Database server Application server Lock server Presentation server.
The fat client architecture is more scalable than a three-tier client architecture T F.
For which of the following, does the database system release each database lock if an implicit database commit is triggered? Application Server (AS) ABAP Database Management System (DBMS) Open SQL.
Which of the following is a special, table-related function module that is created automatically when you activate a table-related lock object? Lock module Lock parameter Lock object.
Why are the DEQUEUE modules hardly used? Locks are released automatically at hte end of program Locks are passed over to update techniques ENQUEUE lock module determines which table lines must be locked.
If an application program that has created lock entries is terminated, the system releases the locks automaticall (implicitly). T F.
Which of the following is considered the core part of a lock entry? Lock object Lock Module Lock argument Lock container.
You can send the contents of the lock container to the lock management by using the ENQUEUE_ESFLIGHT function module. T F.
Which of the following is the lock mode that sets a lock for changing data and can be accumulated? X O S E.
The existing ENQUEUE and DEQUEUE function modules can be used for optimistic locks. T F.
Which is the lock mode that you use to convert the optimistic lock into an exclusive lock (type “E”)? X R S O.
A pessimistic lock is set if the user displays data in the change mode. T F.
Which of the following needs data to be saved first as global program data before the database changes are made? SAP transaction Update program Dialog program.
Which of the following is the massage type that you can use to terminate processing from a deferred subroutine and restore the previous consistent database status? Type E Type A Type W Type I.
Which statement carries out all subroutines registered by using addition ON COMMIT to be executed, one after the other and triggers a database commit? COMMIT WORK ON COMMIT IN UPDATE TASK.
Update techniques allow you to separate user dialogs from the database changes? T F.
Which update mode is used if further processing or dialog program termination depends on the update result? Synchronous update Asynchronous update Local update.
Which of the following is the standard technique used in dialog processing? Synchronous updating Asynchronous updating Local updating.
V2 update modules are used for database changes that are linked to the V1 changes but do not necessarily have to be executed in the same Database Logical Unit of Work. T F.
For what types of updates do V1 updtae modules create requests in the log tables? Synchronous Local Asynchronous.
Which of the following statements can you use to call different programs during the execution of the current program and terminate the calling program? CALL TRANSACTION SUBMIT LEAVE TO TRANSACTION SUBMIT ... AND RETURN.
You can set additional locks to the existing E or X locks from within a program called using SUBMIT … AND RETURN or CALL TRANSACTION statements. T F.
|
