Data Dictionary Question – What is the Data Dictionary workbench transaction?

(Looking for: SE11)

 How does an index improve the performance of SELECTS?

(Looking for: index is more efficient for the database to scan than the full table, matching index records points back to the table records, improves SELECTS on non-key fields)

 How can you tell if an index is being utilized?

(Looking for: Runtime Analysis, SQL Trace)

 <!–nextpage–>

 ABAP Tuning Question – What do you look for when tuning an ABAP program?

(Looking for: Start with places where physical I/O takes place – SELECTS, file reads/writes, make sure full key specified in WHERE clause, make sure WHERE clause is ordered according to index fields, favor group level reads/updates (SELECT INTO TABLE, UPDATE FROM TABLE), closely inspect nested SELECTS, make sure db reads are not duplicated in the logic, use most recent variations of APPEND FROM to avoid unecessary byte manipulations, favor explicit MOVEs rather than MOVE-CORRESPONDING where appropriate, favor the use of CONSTANTs, explicitly type formal variables in FORM USING)

 How is locking performed between ABAP programs?

(Looking for: LOCK OBJECT on a table, enqueue/dequeue, can lock whole table or only certain rows by passing enqueue function key values, commit work dequeues all objects)

 Explain ALE:

(Looking for: Distribution model, messages between systems, Partner Profile, Port Definition, Segmenting/Filtering/Versioning, Idoc – extending segments, RFC or file)

 System Architecture – Explain System, Instance, Client:

(Looking for: understands that a system is not an instance, that client-dependent data is segregated, transports move from system to system or environment to environment)

 ALE Architecture Question – Describe the overall ALE architecture.

(Looking for: Logical Systems, Messages, Communication Idocs, Segmenting, Filtering, Versioning, Partner Profile, Port Definition)

 BAPI Question – Describe how to find out what BAPIs are available:

(Looking for: ABAP Development Workbench, click on Bus Object, open “Methods”, green dot indicates presence of a BAPI)

 What are the steps in scheduling a background job?

(Looking for: SM36/SM37, Job Name, Steps (ABAP/Variant/Print Specs), Date (Immed, date/time, after job, etc.))

Pages: 1 2 3