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 “<message text>” view-as alert-box <message type> buttons <button type>
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 RUN statement?
Syntax:
RUN <internal/external> procedure name
Example:
RUN calculator.p
6. What are the data types in progress?
Character
Integer
Decimal
Logical
Date
Handle
Widget-Handle
Com-handle
Rowid/Recid
7. What is the syntax for variable declaration?
Define variable <variable-name> as <data-type>format<format-value> initial <initial-value> no-undo
Example:
Define variable lv_a as integer format 999 initial 1 no-undo.
8. 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.
9. How many date formats available in progress?
Two types of date format available
MDY
DMY
10. What are the types of looping statement?
Repeat
Do
For-each
Do-while
11. What is the syntax for REPEAT loop?
Repeat :
Statements…..
End.
12. What is the syntax for FOR-EACH loop and use of FOR-EACH loop?
Syntax:
For each <table name>:
Statements…..
End.
Use:
For each loop is used to fetch records one by one from one or more tables with or without where clause from the database.
13. 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 (<Position of a String><variable-List>).
14. What is the use of NUM-ENTRIES?
NUM-ENTRIES is used to return the no of entries available in the list .
Syntax:
Num-entries(<variable-list>).
15. What are the types of BLOCKS?
Repeat, do, for-each block
Procedure block
Trigger block
Editing block
16. 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.
17. What is EDITING Block?
Editing block is used to get the input from the user
• Prompt-for
• Set
• Update
18. 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.
19. What are the types of PROCEDURES?
Internal procedure
External procedure
Persistent procedure
Super procedure
20. 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
Progress Interview Questions with Answers pdf
21. How will you Run External procedure persistently?
Run <external procedure name> persistent set <Handle Variable Name>
22. What is the use of PARAMETER?
The parameter is used to passing the argument to function and procedure
23. What are the types of PARAMETERS?
Input
Output
Input-output
24. How will you define a PARAMETER?
Syntax:
Define <parameter-type> parameter <parameter Name> as <data-type> no-undo.
Example:
Define input parameter ip_a as integer no-undo.
25. What are the types of programming models?
Procedure driven model (CUI)
Event driven model (GUI)
26. What is FUNCTION?
Function is a sub-program like procedure but it can return only one single value.
27. What is the syntax for FUNCTION?
Syntax:
Function <function-name> return <data-type> (Parameter type) <parameter-Value> as <data-type> [forward]
Statements……
End function
Example:
Function calculate return integer (input lv_a as integer, input lv_a as integer)
lv_a + lv_b.
End function
28. What is a FRAME?
Frame is a rectangular display area with in the window. It is used to display field level widgets.
29. What are the types of frames?
Down
One Down
30. How will you track the error in the statement?
Using error-status function we can track the error in the statement
31. What are the methods in ERROR-STATUS?
Error
Num-Messages
Get-Number
Get-Message
32. Which is default & unknown Frame?
Default frame is
Repeat
For each
Do with frame
Procedure blocks
Unknown frame is
do
33. How many files are created for new Database?
Five files will be created. They are
.db => default database file
.b1 => before image file
.d1 => after image file
.lg => log file
.st => size and location of the database
34. How many primary keys will be in a single table?
Only one primary key in a single table
35. What are the types of INDEXES?
Primary key index
Unique index
Word index
36. How will you fetch Single record & multiple records?
For-first and find-first are used to fetch a single record
For each statement is used to fetch the multiple records
37. 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
38. What is the difference between FIND-FIRST and FOR-FIRST?
For-first:
Using field option for specify the field name for modification
Using multiple index
Using word index field
Find-first:
In find first not support the above three statements
In find first we use no-error and available option
39. What is the use of NO-ERROR?
No-error statement which is used to suppress the progress errors
40. What is the use of XREF?
XREF is used to find out the index being used in a file
41. What is the syntax for XREF?
Compile <external-procedure>save XREF <XREF-filename>
42. What is record SCOPING?
To identify the scope of the record
43. What are the types of scoping and their uses?
Weak scope .
eg :- for each loop
Strong scope
eg :- Do for loop
44. What is the use of LOCKS?
It is used to control the data access in the multi-user environment
45. What are the types of LOCKS?
Share-lock
Exclusive-lock
No-lock
46. What is the syntax to release the LOCK Explicitly?
Release <table-name> no-error
47. What is DEADLOCK?
Deadlock is situation at which the transaction will not be able to continue.
If we are not using proper locking statement then deadlock will occur.
48. What is TRANSACTION?
Set of changes into the database to be accepted / rejected by the system which is called transaction
49. How will you identify the TRANSACTION?
Using the following three steps we can identify that the transaction is available or not
The statements which is directly interact to the database use create update delete insert
When we use the TRANSACTION statement explicitly
Fetching record using exclusive-lock statement
50. What are the types of TRANSACTION?
i) Transaction
ii) Sub Transaction
It can also be a Larger Transaction (nested transaction) or a Smaller Transaction
(Repeat transaction, do transaction, etc.,)
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 “<message text>” view-as alert-box <message type> buttons <button type>
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 RUN statement?
Syntax:
RUN <internal/external> procedure name
Example:
RUN calculator.p
6. What are the data types in progress?
Character
Integer
Decimal
Logical
Date
Handle
Widget-Handle
Com-handle
Rowid/Recid
7. What is the syntax for variable declaration?
Define variable <variable-name> as <data-type>format<format-value> initial <initial-value> no-undo
Example:
Define variable lv_a as integer format 999 initial 1 no-undo.
8. 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.
9. How many date formats available in progress?
Two types of date format available
MDY
DMY
10. What are the types of looping statement?
Repeat
Do
For-each
Do-while
11. What is the syntax for REPEAT loop?
Repeat :
Statements…..
End.
12. What is the syntax for FOR-EACH loop and use of FOR-EACH loop?
Syntax:
For each <table name>:
Statements…..
End.
Use:
For each loop is used to fetch records one by one from one or more tables with or without where clause from the database.
13. 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 (<Position of a String><variable-List>).
14. What is the use of NUM-ENTRIES?
NUM-ENTRIES is used to return the no of entries available in the list .
Syntax:
Num-entries(<variable-list>).
15. What are the types of BLOCKS?
Repeat, do, for-each block
Procedure block
Trigger block
Editing block
16. 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.
17. What is EDITING Block?
Editing block is used to get the input from the user
• Prompt-for
• Set
• Update
18. 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.
19. What are the types of PROCEDURES?
Internal procedure
External procedure
Persistent procedure
Super procedure
20. 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
Progress Interview Questions with Answers pdf
21. How will you Run External procedure persistently?
Run <external procedure name> persistent set <Handle Variable Name>
22. What is the use of PARAMETER?
The parameter is used to passing the argument to function and procedure
23. What are the types of PARAMETERS?
Input
Output
Input-output
24. How will you define a PARAMETER?
Syntax:
Define <parameter-type> parameter <parameter Name> as <data-type> no-undo.
Example:
Define input parameter ip_a as integer no-undo.
25. What are the types of programming models?
Procedure driven model (CUI)
Event driven model (GUI)
26. What is FUNCTION?
Function is a sub-program like procedure but it can return only one single value.
27. What is the syntax for FUNCTION?
Syntax:
Function <function-name> return <data-type> (Parameter type) <parameter-Value> as <data-type> [forward]
Statements……
End function
Example:
Function calculate return integer (input lv_a as integer, input lv_a as integer)
lv_a + lv_b.
End function
28. What is a FRAME?
Frame is a rectangular display area with in the window. It is used to display field level widgets.
29. What are the types of frames?
Down
One Down
30. How will you track the error in the statement?
Using error-status function we can track the error in the statement
31. What are the methods in ERROR-STATUS?
Error
Num-Messages
Get-Number
Get-Message
32. Which is default & unknown Frame?
Default frame is
Repeat
For each
Do with frame
Procedure blocks
Unknown frame is
do
33. How many files are created for new Database?
Five files will be created. They are
.db => default database file
.b1 => before image file
.d1 => after image file
.lg => log file
.st => size and location of the database
34. How many primary keys will be in a single table?
Only one primary key in a single table
35. What are the types of INDEXES?
Primary key index
Unique index
Word index
36. How will you fetch Single record & multiple records?
For-first and find-first are used to fetch a single record
For each statement is used to fetch the multiple records
37. 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
38. What is the difference between FIND-FIRST and FOR-FIRST?
For-first:
Using field option for specify the field name for modification
Using multiple index
Using word index field
Find-first:
In find first not support the above three statements
In find first we use no-error and available option
39. What is the use of NO-ERROR?
No-error statement which is used to suppress the progress errors
40. What is the use of XREF?
XREF is used to find out the index being used in a file
41. What is the syntax for XREF?
Compile <external-procedure>save XREF <XREF-filename>
42. What is record SCOPING?
To identify the scope of the record
43. What are the types of scoping and their uses?
Weak scope .
eg :- for each loop
Strong scope
eg :- Do for loop
44. What is the use of LOCKS?
It is used to control the data access in the multi-user environment
45. What are the types of LOCKS?
Share-lock
Exclusive-lock
No-lock
46. What is the syntax to release the LOCK Explicitly?
Release <table-name> no-error
47. What is DEADLOCK?
Deadlock is situation at which the transaction will not be able to continue.
If we are not using proper locking statement then deadlock will occur.
48. What is TRANSACTION?
Set of changes into the database to be accepted / rejected by the system which is called transaction
49. How will you identify the TRANSACTION?
Using the following three steps we can identify that the transaction is available or not
The statements which is directly interact to the database use create update delete insert
When we use the TRANSACTION statement explicitly
Fetching record using exclusive-lock statement
50. What are the types of TRANSACTION?
i) Transaction
ii) Sub Transaction
It can also be a Larger Transaction (nested transaction) or a Smaller Transaction
(Repeat transaction, do transaction, etc.,)
No comments:
Post a Comment