Accessing the DB with native SQL enables you to use DB-specific commands. True False. The Open SQL set of commands comprise operations for both Data Manipulation Language (DML) and Data Definition Language (DDL). True False. You can limit the target quantity on the DB by using all the native SQL commands. True False. Which keyword is used to update specific fields of a DB table from a workarea? Using SET Client-Specific. Which of the following statements provides two variants for changing a specific record within a DB table? COMMIT ROLLBACK UPDATE MODIFY. What are the two methods that will cause a database rollback? Sending a termination dialog message (A or X) Updating a data record Using the ROLLBACK WORK ABAP statement Inserting the variant. An SAP LUW consists of changes based on the "all or nothing" principle. True False. Which of the following ends the DB LUW and confirms the current DB status? DB ROLLBACK DB LUW DB table TB COMMIT. In the case of an error during a DB update, which function would you use to restore the previous (consistent) DB 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 flat client architecture is more scalable than a three-tier architecture. True False.
