Computer Knowledge
Computer File Systems
1,516 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
-
Logical- FILE-1, Physical- INFILE
-
Logical- INFILE, Physical- FILE-1
-
Logical- None, Physical-ASSIGN
-
None of them
A
Correct answer
Explanation
In COBOL's SELECT statement, the first name (FILE-1) is the logical filename - the name used within your COBOL program to reference the file. The second name (INFILE) after ASSIGN TO is the physical filename - the actual name of the file in the external system or device. This logical-to-physical mapping allows portability across different systems.
-
Check the logical abnormal conditions.
-
Check the existence of a file while open, close etc.
-
Check the execution of the program.
-
None of the above.
B
Correct answer
Explanation
The FILE-STATUS clause assigns a two-character variable that the runtime system updates after every I/O statement. This allows the program to programmatically check the success or failure of operations such as opening, closing, or accessing the file.
-
.aspx
-
.asmx
-
.ascx
-
.wsdl
-
.svc
B
Correct answer
Explanation
ASP.NET Web Services use the .asmx file extension, which stands for ASp.NET neXt generation (or 'asmx'). The .aspx extension is for web pages, .ascx is for user controls, .wsdl is for Web Service Description Language files, and .svc is for WCF services. When you create an ASP.NET Web Service in Visual Studio, it automatically generates an .asmx file.
-
swish file format
-
flash file format
-
swarf file file format
-
photoshop file format
B
Correct answer
Explanation
.swf (Small Web Format) is the file format used by Adobe Flash to deliver animations, applications, and interactive content over the web.
B
Correct answer
Explanation
Flash is not a video editing software. While it can import and embed video, it cannot directly edit MPEG videos - you need dedicated video editing software for that task.
B
Correct answer
Explanation
The Library panel in Flash provides access to the library of the current Flash document, not the computer's file system. The library stores symbols, graphics, and other assets used within that specific Flash project. Accessing system files would require different methods like FileReference class.
-
.out file
-
.txt file
-
.csv file
-
.xls file
C
Correct answer
Explanation
In LoadRunner testing scenarios, account numbers are typically stored in CSV files because they provide structured tabular data that's easy to parse and import. CSV is the standard format for parameter files and test data. Other formats like .out, .txt, or .xls are not the primary format for account data.
-
Sashelp.PrdSale
-
Sasuser.MySales
-
Profits.Quarter1
-
all of the above
D
Correct answer
Explanation
SAS datasets stored in librefs other than Work (such as Sashelp, Sasuser, and user-defined libraries like Profits) are permanent files. The Work library is exclusively reserved for temporary datasets. Because all three options specify datasets located in permanent libraries, the option indicating 'all of the above' is correct.
-
a.proc contents data=area51.all nods;
-
a.proc contents data=area51 all nods;
-
a.proc contents data=area51 all noobs;
-
a.proc contents data=area51 all.nods;
A
Correct answer
Explanation
To print a summary of all SAS datasets in a library without their individual descriptors, use the data=libref._all_ syntax combined with the nods (no details) option. Other options either omit the period prefix or use incorrect option keywords like 'noobs'.
B
Correct answer
Explanation
Android application packages use the .apk (Android Package) file extension for distribution and installation. Other choices like .exe are designed for Windows executables, while .dvk, .and, and dk represent invalid or non-existent file formats for Android apps.
-
FCLOSE
-
GET_LINE
-
IS_OPEN
-
1,2
-
All of the above
D
Correct answer
Explanation
The INVALID_FILEHANDLE exception is raised by UTL_FILE procedures like FCLOSE and GET_LINE when they receive an invalid or uninitialized file handle. Conversely, the IS_OPEN function evaluates whether a handle is open and returns a boolean value instead of raising this exception, making the combination 1,2 correct.
-
INVALID_OFFSET
-
VALUE_ERROR
-
ACCESS_DENIED
-
INVALID_MAXLINE_SIZE
-
INVALID_FILENAME
D
Correct answer
Explanation
INVALID_MAXLINE_SIZE is a valid UTL_FILE exception raised when the MAX_LINESIZE parameter in FOPEN or FOPEN_NCHAR exceeds implementation limits. Other valid exceptions include INVALID_PATH, INVALID_MODE, INVALID_FILEHANDLE, and WRITE_ERROR, but INVALID_OFFSET, VALUE_ERROR, and ACCESS_DENIED are not standard UTL_FILE exceptions.
B
Correct answer
Explanation
UTL_FILE can read files on Windows systems, but only if the Oracle database server is running on Windows and the directory is properly configured in the DIRECTORY object and utl_file_dir parameter. The question likely tests whether you understand UTL_FILE operates server-side, not client-side, so it depends on the server OS, not the client environment.
C
Correct answer
Explanation
SFT outbox retention period is set to 30 days as a standard configuration. This balances the need for audit trails with storage management - keeping files long enough for troubleshooting but not indefinitely. The other options (10, 15, 40) are not standard SFT retention values.
-
&TXLATE=YES and &TDATTYP=TEXT
-
&TXLATE=YES and &TDATTYP=BINARY
-
&TXLATE=NO and &TDATTYP=TEXT
-
&TXLATE=NO and &TDATTYP=BINARY
D
Correct answer
Explanation
For binary mode file transmission via SFT (Secure File Transfer), you must disable translation (&TXLATE=NO) and specify the data type as binary (&TDATTYP=BINARY). Translation converts data between character sets (e.g., EBCDIC to ASCII), which would corrupt binary files. The other combinations either enable translation when binary is needed or specify TEXT type incorrectly.