Multiple choice technology databases

Which opcode is used to add a new field to a Physical file without deleting its records?

  1. CRTPF

  2. CHGPFM

  3. CHGPF

  4. Can't be done so

Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

The CHGPF (Change Physical File) command is used to modify a physical file's structure, including adding new fields, without deleting existing records. CHGPFM changes file attributes but not structure. CRTPF creates a new file (which would be empty). The operation preserves existing data while allowing schema evolution.