Realtime OpenEdge Multiple choice Questions and Answers pdf

6) Mention what are the types of partitioning does OpenEdge allows?
OpenEdge allows three types of partitioning
•  List partition: Partitioning is done by group based on a field or areas like reporting for a specific country only
•  Data range partition: Partitioning based on a range of data
•  Sub-partitioning: Group based on the combination of the above options

7) Mention what is the advantage of using OpenEdge ABL?
•  ABL makes easy to leverage business terminology and statements to quickly express and understand rich business rules
•  Single line in ABL saves the time which would be hundreds of lines of codes in another language
•  It enables developers to integrate and combine classes with procedures and vice versa
•  It is the only mainstream development language that offers built-in capabilities to access, manipulate and store data from different data sources
•  It converts ABL structures to XML documents, i.e. data= .xml
•  There is no requirement to write your own code using SAX or DOM
•  It supports in and out of XML to ABL objects

8) How you decide whether you should use a property or a variable in OpenEdge ABL?
You can use property if you plan on accessing the value from outside the current class. Likewise, if you only need it inside the class, use a variable. If no one else is supposed to see the value, then value is “state” and not “property”.

9) Mention how big the DB cache and how long will the DB cache stays?
DB cache is sized by the value of the –B configuration parameter. It is created in memory when the database is created and deleted when the database is shut down.

10) Explain whether DB cache is available across different progress sessions even though each session has made its own DB connection?
When run in multi-user mode, the primary broker for the database creates the buffer cache in one or more shared memory segments. These segments are directly accessed by server processes that access the database on behalf of clients, by self-serving clients that carries the client and server code in the same process and by database utility programs and various supporting processes. All of the processes must be running on the same machine as the primary broker process.

Read More Questions:
OpenEdge interview questions Part1
OpenEdge interview questions Part2