Question Bank: Test Your Knowledge on PROGRESS Database

1). Table name is employee and the field name is empno, want to access one specific employee number.
A. for each employee where employee.empno = '******'
B. for each employee where empno = '*******"
C. for each employee where employee(empno) = '********'
D. for each employee where empno.employee = '********"

which is (are) not correct in the above example?

2).Which is not the valid data type name in PROGRES database?
A. Char
B. Real
C. Recid
D. Raw

3). What is difference between SKIP and SKIP(1)
A. SKIP will skip the remaining protion of a line and SKIP(1) will skip 1 line
B. SKIP will skip 1 line, but SKIP(1) actually skip 2 line at a time.
C. SKIP and SKIP(1) will do same thing

4). To concatenate two strings which operator is used
A.+ (PLUS)
B. ^
C. , (COMMA)
D. &

5). FOR EACH customer

UPDATE name address city state country
credit-limit VALIDATE(credit-limit < 500000, "Too high").
END.

What is the wrong with this statement ?

A. For each statement require a ':' (COLON)
B. Fields should be separated by comma(,)
C. "Too High" is invalid here.
D. None of the above.

6). Which statement is used to refer the value of a field in a frame or window buffer?
A. INPUT
B. READ
C. ASSIGN
D. SCAN

7). Which statement is used to read input to any variable using the frame?
A. READ
B. ASSIGN
C. PROMPT-FOR
D. PROMPT
E. none

8). A record having large number of data, i.e. record length is large. Which statement is not advisable to use in PROGRESS database ?
A. FOR EACH
B. FOR
C. FIND
D. SELECT

9). A Progress Decimal variable can store maximum of ______ decimal places.
A. 16
B. 32
C. 8
D. 10
E. none

10). Which statement is used to create a character string which is made up with a specific character repeatedly?
A. REPEAT()
B. FILL()
C. FILL-WITH()
D. CREATE()
E. REPSTR()

Answers:
1. C & D - C. for each employee where employee(empno) = '********' and D. for each employee where empno.employee = '********"
2. B - Real
3. A - SKIP will skip the remaining protion of a line and skip(1) will skip 1 line
4. A - plus (+)
5. A - For each statement require a ':'
6. A - INPUT
7. C - PROMPT-FOR
8. C - FIND
9. D - 10
10. B - FILL()