Computer Knowledge
Computer File Systems
1,249 Questions
Computer file systems dictate how data is stored, organized, and retrieved on storage devices. Important concepts include file allocation tables, access mechanisms, and various formats like sequential and video files. Candidates preparing for banking and government exams should practice these fundamentals thoroughly.
File access mechanismsVideo and password filesFile extensionsFile allocation tableSystem metadata
Computer File Systems Questions
B
Correct answer
Explanation
COBOL has three types of file access modes: Sequential (records read in order), Random (direct access by key), and Dynamic (combines sequential and random access). These correspond to the three file organization types.
-
If the specified file is already in the open mode, the program is suspended, and waits for exclusive availability of the file.
-
If the specified file is not in the open mode, the file is opened.
-
If the specified file is not in the open mode, the program is suspended, and waits for exclusive availability of the file.
-
If the specified file is in the open mode, the file is opened.
A,B
Correct answer
Explanation
When executing an open operation with a lock, the system requests exclusive access to the file. If the file is not currently open, it is opened successfully. If it is already open by another process, the program is suspended and waits for the file to become available.
-
OPEN INPUT
-
OPEN INPUT-OUTPUT
-
OPEN EXTEND
-
OPEN OUTPUT
-
Mismatch in LRECL between your COBOL pgm & the JCL
-
Mismatch in BLOCKSIZE between your COBOL pgm & the JCL
-
Mismatch in RECFM between your COBOL pgm & the JCL
-
All of the above
D
Correct answer
Explanation
File status 39 indicates a mismatch in file attributes between your COBOL program and the JCL. This can be LRECL (logical record length), BLOCKSIZE, or RECFM (record format) mismatch - any of these will cause status 39. The question is comprehensive - all three types of mismatches trigger status 39. Options A, B, and C each name one specific cause. Option D correctly captures all of them as possible causes.
-
ReportFile
-
SortIndexFile
-
Initialization File
-
File Viewer
A,B
Correct answer
Explanation
ReportFile is designed for generating output reports to text files. SortIndexFile can write sorted or indexed data to text files. Initialization Files are typically read-only configuration files. File Viewers are for reading and viewing files, not writing output.
-
Initialisation file
-
Auxillary File
-
File viewer
-
None Of these
-
CICS cannot handle file management by itself.
-
CICS helps in task of monitoring.
-
CICS doesn't need the statements like READ, WRITE, OPEN.
-
CICS doesn't act as data communication system.
-
CICS takes care of system functions along with application program functions.
A,D
Correct answer
Explanation
CICS cannot directly handle file management by itself - it relies on access methods like VSAM for file operations (A is true). CICS does not act as a data communication system - it manages communication but the actual data communication is handled by the system's telecommunications controller (D is true). CICS does help with monitoring (B is false). CICS does need READ/WRITE statements for file operations (C is false). CICS does handle both system and application program functions (E is false).
-
Distribution Definition
-
Stream Definition
-
Output Definition
-
Output Profile
-
Business Document Template (BDT)
E
Correct answer
Explanation
Output Management File components define how output is processed and delivered: Distribution Definition (where output goes), Stream Definition (output format), Output Definition (what to produce), and Output Profile (configuration settings). Business Document Template (BDT) is a design component, not a file management component.
B
Correct answer
Explanation
NAS (Network Attached Storage) provides file-level data access to applications. The statement claims that file blocks can be accessed by applications in NAS, which is false - NAS abstracts storage at the file level only, not at the block level. Applications work with entire files through NAS protocols like NFS or SMB.
A
Correct answer
Explanation
Network Attached Storage (NAS) provides file-level data access, meaning clients access data via network file sharing protocols like NFS or SMB/CIFS rather than raw blocks.
-
Control file
-
Redo Logfile and datafile
-
Database
-
Current SCN Number
-
All of the above
E
Correct answer
Explanation
The control file is a critical binary file that tracks the database structure. It contains records about the database name, locations of datafiles and redo log files, backup sets, and the current System Change Number (SCN). Because it contains all of these details, 'All of the above' is correct.
-
database
-
redo logfile & datafile
-
archivelog file location
-
All of the above
D
Correct answer
Explanation
The Oracle control file is a small binary file that contains critical database metadata. It stores information about the database name and creation timestamp, locations and names of all datafiles, online redo log files, and archived redo log destinations. Option D is correct because it encompasses all these components. Options A, B, and C are each individually true but incomplete.
-
Text Files (.txt)
-
MS EXCEL Files (.xls)
-
Data Files (.dat)
-
Comma Delimited Files (.csv)
A,B,D
Correct answer
Explanation
Essbase rules files support multiple data source formats for loading data. Standard supported formats include text files (.txt), Microsoft Excel files (.xls), and comma-delimited files (.csv). The .dat format is typically Essbase's native data export format and is loaded directly, not through rules files.
A
Correct answer
Explanation
.NET 2.0 introduced the System.IO.Compression namespace which includes GZipStream and DeflateStream classes for compression and decompression. These APIs allow developers to compress and decompress data streams and files.
-
SQL processing using file input
-
SQ Linear processing using file input
-
SQL processing using file
-
None of the above
A
Correct answer
Explanation
SPUFI stands for SQL Processing Using File Input. It is an IBM DB2 facility that allows SQL statements to be executed from input files rather than interactively. Users prepare SQL queries in a dataset, and SPUFI processes them and returns results to output files. The other options are incorrect expansions of the SPUFI acronym.