M204 Programming Language Quiz
Test your knowledge of M204 (Model 204) programming language syntax, commands, file structures, and database operations.
Questions
O RSREFR.FILE FILEMAN BEGIN A: IN RSREFR FDWOL RECTYPE = REPORT END FIND END Suppose if you have 10 records with rectype = report,when you run the above adhoc what will be printed
- 10
- 0
- Nothing will be printed
- Error
The statement to remove fields from a record is:
- DELETE RECORD
- DELETE
- DELETE FIELD
- REMOVE
Largest section of a M204 file tables is:
- TABLE A
- TABLE B
- TABLE C
- TABLE D
The retrievable data of all records in a file lies in
- TABLE A
- TABLE B
- TABLE C
- TABLE D
Command to find out the number of records that satisfy a particular condition i
- FPC
- WOL
- FCOUNT
- FRC
Command to print the fields STOR.CODE and CTRY.CODE with a space in between is
- PRINT STOR.CODE WITH CTRY.CODE
- PRINT STOR.CODE AND CTRY.CODE
- PRINT STOR.CODE,CTRY.CODE
- PRINT STOR.CODE CTRY.CODE
The Batch M204 procedure is executed by the utility
- BATCH204
- ADDR204
- FREB204
- EXEC204
Variable name in the M204 procedure is prefixed with
- %
- $
- ?
- #
What will be the result of this statement $SUBSTR(’ACCOUNT’, -3, 5) statement ?
- 'ACCOU'
- NULL STRING
- ACCO'
- COUNT'
What is the use of $SUBSYS ?
- This prints all the subsystem which are active.
- This determines status of a subsystem.
- This inactivates a particular subsystem.
- This activates a subsystem.
A: IN SEGNRL FD RECTYPE = STORE END -------------------------- PRINT STOR.CODE END FOR In the above example if 15 records are there in found set 'A ' and I would like to print only first three records store code . What should be the statement that has to be filled in the above blank to obtain the desired output?
- FOR THREE RECORDS IN A
- FR A
- FOR K RECORDS IN A
- FOR 3 RECORDS IN A
In “FOR K VALUES OF FIELDNAME” statement . If K is negative?
- The loop is skipped
- The loop is repeated for all the values of the field
- Infinite loop
- The loop is executed once.
Use of NOTE Statement :
- Note the M204 procedure you are currently working on.
- Notes the Date when you have logged in
- Notes only the First occurrence in a Mulitply Occuring Fiel
- Notes Only the Last occurrence in a Multiply Occuring Fiel
The FOR EACH RECORD IN ORDER BY statement:
- The FOR EACH RECORD IN ORDER BY statement retrieves and loops only on the first occurrence of a field in a record
- The FOR EACH RECORD IN ORDER BY statement loops only on the first occurrence of a field in a record
- The FOR EACH RECORD IN ORDER BY statement retrieves and loops on all the occurrence of a field in a record
- The FOR EACH RECORD IN ORDER BY statement retrieves and loops on only the last occurrence of a field in a record
The COUNT IN clause refers to
- The count obtained by the COUNT OCCURRENCES statement.
- The Count obtained from counting the number of 'IN' in your M204 Code.
- Counting of the M204 Database files used in the Code
- Count obtained by the Count Statement.
The CLEARGO command clears from GTBL
- All global images, screens,menus, found sets, lists, and temporary and permanent positions. It does not clear global variables.
- All global images, screens,menus, found sets, lists, and temporary and permanent positions,global variables.
- Clears the Garbage Variables
- Clears the only the Global Variables
Which are not valid user language working Areas:
- FSBC
- TTBL
- GTBL
- STBL
The VALUE IN statement is used in which of the following statements?
- ADD statement
- CHANGE statement
- STORE RECORD statement
- All the Above
The statement CHANGE FULLNAME TO is equal to which of the statements below?
- CHANGE FULLNAME TO NULL
- CHANGE FULLNAME TO ‘NULL’
- CHANGE FULLNAME TO 0
- DELETE FULLNAME
“/” is a -
- Wild card character
- Alphabetic character
- OR character
- Repeat character