300+ TOP Progress 4GL Interview Questions [UPDATED]

1. What Are The Advantages In Progress 4gl?

• Less development effort
• Solve more complex application
• Support multiple language
• Reusability
• Less knowledge required for platform and deployments
• Support application server and web based application
• It is used for both front-end and back-end.

2. What Is The Latest Version In Progress And In Which Are Currently Working?

• The latest version of the PROGRESS 4GL is 10.1 Open Edge
• The currently working version is progress 9.1D

3. What Are The Two Ways Of Programming In Progress?

• CUI (Procedure Editor)
• GUI (ADM-2)

4. What Is The Syntax For Message Statement?

Syntax:

Message “” view-as alert-box buttons

Message type:

•  Information
•  Question
•  Error
• Warning

Buttons:

• Ok
• Yes-No
• Yes-No-Cancel                  

Example:
Message “welcome to progress” view-as alert-box information buttons ok.

5. What Is The Syntax For Variable Declaration?

Define variable as format initial no-undo

Example:
 Define variable lv_a as integer format 999 initial 1 no-undo.

6. Why We Are Using No-undo?

Whenever we change the value of a variable, it will store the previous value into the before image file. To avoid this reason, we are using no-undo while declaring the variable.

7. How Many Date Formats Available In Progress?

Two types of date format available:

1. MDY
2. DMY

8. What Are The Types Of Looping Statement?

1. Repeat
2. Do
3. For-each
4. Do-while

9. What Is The Use Of Entry?

It is used to extract a string from the list. This function takes two parameters one is the position of the string and another one is the list.

Syntax: 
Entry ().

10. What Is The Use Of Num-entries?

NUM-ENTRIES is used to return the no of entries available in the list .

Syntax:
 Num-entries().

11. What Are The Types Of Blocks?

• Repeat, do, for-each block
• Procedure block
• Trigger block
• Editing block

12. What Is Trigger Block?

It’s a block which contains one or more statements. whenever an event occurs the corresponding trigger block will be fired.

13. What Is Editing Block?

Editing block is used to get the input from the user:

• Prompt-for
• Set 
• Update

14. What Is The Difference Between Prompt-for & Set?

Prompt-for: 
This is used to get input for both variable and database.

Set: 
This is used to get input only for variable.

15. What Are The Types Of Procedures?

1. Internal procedure
2. External procedure
3. Persistent procedure
4. Super procedure

16. What Is Persistent Procedure?

It’s the procedure which keeps the value of the external procedure using handle variable. This variable will be valid until we close the progress session.

17. How Will You Run External Procedure Persistently?

Run persistent set

18. What Is The Use Of Parameter?

The parameter is used to passing the argument to function and procedure.

19. What Are The Types Of Parameters?

1. Input
2. Output
3. Input-output

20. How Will You Define A Parameter?

Syntax:

Define parameter as no-undo.

Example:
 Define input parameter ip_a as integer no-undo.

21. What Are The Types Of Programming Models?

1. Procedure driven model (CUI)
2. Event driven model (GUI)

22. What Is Function?

Function is a sub-program like procedure but it can return only one single value.

23. What Is A Frame?

Frame is a rectangular display area with in the window. It is used to display field level widgets.

24. What Are The Types Of Frames?

• Down
• One Down

25. How Will You Track The Error In The Statement?

Using error-status function we can track the error in the statement.

26. What Are The Methods In Error-status?

• Error
• Num-Messages
• Get-Number
• Get-Message

27. How Many Primary Keys Will Be In A Single Table?

Only one primary key in a single table

28. What Are The Types Of Indexes?

• Primary key index
• Unique index
• Word index

29. How Will You Fetch Single Record & Multiple Records?

1. For-first and find-first are used to fetch a single record
2. For each statement is used to fetch the multiple records

30. What Is The Difference Between Find & Find-first?

Find:

In find statements if there are any non-primary key records which has duplication will provide ambiguous error

Find-first:

In find-first statements the ambiguous error will be overcome because which is return the first record from the buffer

31. What Is The Difference Between Find-first And For-first?

For-first:

1. Using field option for specify the field name for modification
2. Using multiple index
3. Using word index field

Find-first:

1. In find first not support the above three statements
2. In find first we use no-error and available option

32. What Is The Use Of No-error?

No-error statement which is used to suppress the progress errors.

33. What Is The Use Of Xref?

XREF is used to find out the index being used in a file

34. What Is The Syntax For Xref?

Compile save XREF

35. What Is Record Scoping?

To identify the scope of the record.

36. What Are The Types Of Scoping And Their Uses?

Weak scope .

        eg :-  
 for each loop

Strong scope

         eg :-
Do for loop

37. Tools To Develop Web Based Application?

1. Web-speed 3.0 is a software, which is used to develop web-based applications.
2. Web client is a software where client/Server applications will be accessed using browser like Netscape or Internet Explorer.

38. Can We Create A Word-index For An Array Field?

No, we can’t create a word-index for an array field.

39. What Is No-wait?

When one procedure is accessing a table in exclusive lock mode at the same time some other procedure try to access the same table it will not wait till the table is released if the no-wait option is used.

40. What Is The Use Of Delimiter?

The Delimiter is a character that is used to separate the field values. The default delimiter is space.

41. What Is The Use Of Etime & What Does It Returns?

1. It is used to find out the time taking for execution of a particular block
2. It returns milliseconds.

42. What Is Buffer-copy?

Buffer-Copy is one statement. This is used to bulk copy of a source record to a target record by copying each source field to the target field of the same name.