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

Multiple choice technology web technology
  1. If the specified file is already in the open mode, the program is suspended, and waits for exclusive availability of the file.

  2. If the specified file is not in the open mode, the file is opened.

  3. If the specified file is not in the open mode, the program is suspended, and waits for exclusive availability of the file.

  4. If the specified file is in the open mode, the file is opened.

Reveal answer Fill a bubble to check yourself
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.

Multiple choice technology mainframe
  1. Mismatch in LRECL between your COBOL pgm & the JCL

  2. Mismatch in BLOCKSIZE between your COBOL pgm & the JCL

  3. Mismatch in RECFM between your COBOL pgm & the JCL

  4. All of the above

Reveal answer Fill a bubble to check yourself
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.

Multiple choice technology enterprise content management
  1. ReportFile

  2. SortIndexFile

  3. Initialization File

  4. File Viewer

Reveal answer Fill a bubble to check yourself
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.

Multiple choice technology mainframe
  1. CICS cannot handle file management by itself.

  2. CICS helps in task of monitoring.

  3. CICS doesn't need the statements like READ, WRITE, OPEN.

  4. CICS doesn't act as data communication system.

  5. CICS takes care of system functions along with application program functions.

Reveal answer Fill a bubble to check yourself
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).

Multiple choice technology platforms and products
  1. Distribution Definition

  2. Stream Definition

  3. Output Definition

  4. Output Profile

  5. Business Document Template (BDT)

Reveal answer Fill a bubble to check yourself
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.

Multiple choice technology storage
  1. True

  2. False

Reveal answer Fill a bubble to check yourself
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.

Multiple choice technology databases
  1. Control file

  2. Redo Logfile and datafile

  3. Database

  4. Current SCN Number

  5. All of the above

Reveal answer Fill a bubble to check yourself
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.

Multiple choice technology databases
  1. database

  2. redo logfile & datafile

  3. archivelog file location

  4. All of the above

Reveal answer Fill a bubble to check yourself
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.

Multiple choice technology platforms and products
  1. Text Files (.txt)

  2. MS EXCEL Files (.xls)

  3. Data Files (.dat)

  4. Comma Delimited Files (.csv)

Reveal answer Fill a bubble to check yourself
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.

Multiple choice technology mainframe
  1. SQL processing using file input

  2. SQ Linear processing using file input

  3. SQL processing using file

  4. None of the above

Reveal answer Fill a bubble to check yourself
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.