Computer File Systems

It IS possible to create header and footer records in target flat files in Informatica. This can be achieved using various methods: using the Union transformation to combine header, data, and footer records from different sources; using Java transformation; or employing target pre/post session SQL commands. The statement is true.

For a single alphanumeric character 'M' in a variable field (#VAR), Fixed Format storage is preferable. Fixed storage is predictable and efficient for short values. Default Compression and Normal Suppression are variable-length techniques that add overhead for single characters. Fixed format avoids the length byte overhead.

QTP uses VBScript as its scripting language, so test script files are saved with .vbs extension, which is the standard Visual Basic Script file extension.

The 'cat' command in Unix/Linux is used to display the contents of a file to the terminal. 'cat not_empty' will show all contents of the file 'not_empty' at once. While 'more' and 'less' can also display file contents with pagination, 'cat' is the standard command for viewing entire files. Commands like 'type' and 'view' are not standard Unix commands for this purpose.

.xlh is not a standard Microsoft Excel file extension. The other options are all valid Excel formats - .xls (legacy workbook), .xlsx (modern XML-based workbook), and .xla (Excel add-in).

In COBOL, sort descriptions (SD entries for sort files) are defined in the FILE SECTION, specifically within the SORT WORKING-STORAGE or directly under FILE SECTION entries. Working-Storage contains general variables. Linkage Section is for parameters. Control Section is not a standard COBOL section.

To answer this question, the user needs to have knowledge of COBOL file processing clauses.

Option A: Record Not Found - This clause is used to detect if there are no more records beyond the point where a READ statement is executed. It is not an alternative to checking for file status = 10.

Option B: At End - This clause is used to detect the end of a file. It is a valid alternative to checking for file status = 10.

Option C: Duplicate Record - This clause is used to detect if there are duplicate records in a file. It is not an alternative to checking for file status = 10.

Option D: End Of File - This clause is used to detect the end of a file. It is a valid alternative to checking for file status = 10.

Option E: At Spaces - This clause is used to detect if a record contains only spaces. It is not an alternative to checking for file status = 10.

Therefore, the correct answer is:

The Answer is: B. At End

COBOL's REWRITE verb requires I-O (Input-Output) mode because it must read the existing record before writing the modified version back. Input mode only allows reading, Output mode only allows writing new records, and Update is not a valid COBOL open mode.

CICS (Customer Information Control System) file control primarily supports VSAM files. QSAM is a standard MVS access method for sequential files that cannot be directly accessed through CICS file control commands. ISAM and VSAM are supported, and GSAM is less common in CICS contexts.

Temporary files should be completely removed from the server (option C) when no longer needed because they may contain sensitive data. Placing them in web-accessible locations (A, B, D) risks unauthorized access, even without visible links. Security through obscurity is unreliable.

The claimed answer (C, CD-R's) is outdated by modern standards. Current best practices for log backup include secure cloud storage, WORM (Write Once Read Many) storage, or dedicated SIEM solutions. However, given the exam's apparent vintage, I'm noting this as correct but dated. Paper (A) is impractical for logs, and local copies (B) lack geographic redundancy.

To handle temporary data, one frequently used practice is to store the data in temporary files. To correctly handle temporary files, the user needs to know where the files should be placed, how to handle the files, and how to remove them when they are no longer needed.

Option A is incorrect because placing temporary files in a folder called "temp" in the web root is not secure. Doing so would allow anyone with access to the web root to access and potentially manipulate these files.

Option B is also incorrect because placing temporary files anywhere in the web root is not safe. This can make the files accessible to anyone who knows the filename or path.

Option C is not always necessary. While it is important to remove temporary files when they are no longer needed, it is not always possible to remove them completely from the server. In some cases, temporary files may be necessary for the proper functioning of the application.

Option D is not a recommended practice. Changing the file extension does not provide any additional security or protection against unauthorized access.

Therefore, the best option is to store temporary files in a separate folder that is not accessible from the web. This folder should have strict access permissions to ensure that only authorized users can access it. Once the files are no longer needed, they should be deleted using secure deletion methods.

The Answer is: C

CD-Rs (Compact Disc Recordable) provide a secure, write-once medium for backup that prevents tampering or modification of log files after they're written. Unlike paper or desktop copies, CD-Rs create permanent, unalterable records that can be stored offline and protected from unauthorized changes.