M204 Programming Language Quiz

Test your knowledge of M204 (Model 204) programming language syntax, commands, file structures, and database operations.

20 Questions Published

Questions

Question 1 Multiple Choice (Single Answer)

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

  1. 10
  2. 0
  3. Nothing will be printed
  4. Error
Question 2 Multiple Choice (Single Answer)

The statement to remove fields from a record is:

  1. DELETE RECORD
  2. DELETE
  3. DELETE FIELD
  4. REMOVE
Question 3 Multiple Choice (Single Answer)

Largest section of a M204 file tables is:

  1. TABLE A
  2. TABLE B
  3. TABLE C
  4. TABLE D
Question 4 Multiple Choice (Single Answer)

The retrievable data of all records in a file lies in

  1. TABLE A
  2. TABLE B
  3. TABLE C
  4. TABLE D
Question 5 Multiple Choice (Single Answer)

Command to find out the number of records that satisfy a particular condition i

  1. FPC
  2. WOL
  3. FCOUNT
  4. FRC
Question 6 Multiple Choice (Single Answer)

Command to print the fields STOR.CODE and CTRY.CODE with a space in between is

  1. PRINT STOR.CODE WITH CTRY.CODE
  2. PRINT STOR.CODE AND CTRY.CODE
  3. PRINT STOR.CODE,CTRY.CODE
  4. PRINT STOR.CODE CTRY.CODE
Question 7 Multiple Choice (Single Answer)

The Batch M204 procedure is executed by the utility

  1. BATCH204
  2. ADDR204
  3. FREB204
  4. EXEC204
Question 8 Multiple Choice (Single Answer)

Variable name in the M204 procedure is prefixed with

  1. %
  2. $
  3. ?
  4. #
Question 9 Multiple Choice (Single Answer)

What will be the result of this statement $SUBSTR(’ACCOUNT’, -3, 5) statement ?

  1. 'ACCOU'
  2. NULL STRING
  3. ACCO'
  4. COUNT'
Question 10 Multiple Choice (Single Answer)

What is the use of $SUBSYS ?

  1. This prints all the subsystem which are active.
  2. This determines status of a subsystem.
  3. This inactivates a particular subsystem.
  4. This activates a subsystem.
Question 11 Multiple Choice (Single Answer)

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?

  1. FOR THREE RECORDS IN A
  2. FR A
  3. FOR K RECORDS IN A
  4. FOR 3 RECORDS IN A
Question 12 Multiple Choice (Single Answer)

In “FOR K VALUES OF FIELDNAME” statement . If K is negative?

  1. The loop is skipped
  2. The loop is repeated for all the values of the field
  3. Infinite loop
  4. The loop is executed once.
Question 13 Multiple Choice (Single Answer)

Use of NOTE Statement :

  1. Note the M204 procedure you are currently working on.
  2. Notes the Date when you have logged in
  3. Notes only the First occurrence in a Mulitply Occuring Fiel
  4. Notes Only the Last occurrence in a Multiply Occuring Fiel
Question 14 Multiple Choice (Single Answer)

The FOR EACH RECORD IN ORDER BY statement:

  1. The FOR EACH RECORD IN ORDER BY statement retrieves and loops only on the first occurrence of a field in a record
  2. The FOR EACH RECORD IN ORDER BY statement loops only on the first occurrence of a field in a record
  3. The FOR EACH RECORD IN ORDER BY statement retrieves and loops on all the occurrence of a field in a record
  4. The FOR EACH RECORD IN ORDER BY statement retrieves and loops on only the last occurrence of a field in a record
Question 15 Multiple Choice (Single Answer)

The COUNT IN clause refers to

  1. The count obtained by the COUNT OCCURRENCES statement.
  2. The Count obtained from counting the number of 'IN' in your M204 Code.
  3. Counting of the M204 Database files used in the Code
  4. Count obtained by the Count Statement.
Question 16 Multiple Choice (Single Answer)

The CLEARGO command clears from GTBL

  1. All global images, screens,menus, found sets, lists, and temporary and permanent positions. It does not clear global variables.
  2. All global images, screens,menus, found sets, lists, and temporary and permanent positions,global variables.
  3. Clears the Garbage Variables
  4. Clears the only the Global Variables
Question 17 Multiple Choice (Single Answer)

Which are not valid user language working Areas:

  1. FSBC
  2. TTBL
  3. GTBL
  4. STBL
Question 18 Multiple Choice (Single Answer)

The VALUE IN statement is used in which of the following statements?

  1. ADD statement
  2. CHANGE statement
  3. STORE RECORD statement
  4. All the Above
Question 19 Multiple Choice (Single Answer)

The statement CHANGE FULLNAME TO is equal to which of the statements below?

  1. CHANGE FULLNAME TO NULL
  2. CHANGE FULLNAME TO ‘NULL’
  3. CHANGE FULLNAME TO 0
  4. DELETE FULLNAME
Question 20 Multiple Choice (Single Answer)

“/” is a -

  1. Wild card character
  2. Alphabetic character
  3. OR character
  4. Repeat character