Computer File Systems

In SQLite3 and Android best practices, large files like bitmaps or audio files are typically NOT stored directly within database tables as BLOBs. Instead, they're stored in the file system, and only the file path or URI is stored in the database. This approach is more efficient, avoids database bloating, and is easier to manage.

Environment.getExternalStorageDirectory() returns the path to the primary shared/external storage directory. This is the standard Android API for accessing SD card storage. Context does not have a getStorageDirectory() method, and Environment.getStorageDirectory() does not exist.

The 'stat' command displays detailed file status information including permissions, size, ownership, timestamps, and inode details. 'cat meminfo' would display memory info, not file status. 'file ' shows file type, not comprehensive status. 'All the above' is incorrect since only one option is correct.

.AVI (Audio Video Interleave) is a well-known PC video file format introduced by Microsoft in 1992. .MP3 is an audio format (not video). .MVE is a less common video format used in some games, but .VDO is not a standard PC video extension. Among these, .AVI is the most established PC video file extension.

The default permission for a regular file in Unix/Linux is 644 (rw-r--r--), not 655. The 644 setting means owner has read/write, group and others have read-only. The umask typically defaults to 022, which subtracts from 666 to yield 644.

In Oracle databases, redo log files can be multiplexed - meaning multiple copies of the same redo log group can be maintained simultaneously on different disks to protect against disk failure. The parameter file (spfile or pfile) is a single configuration file. Data files cannot be multiplexed - they are the actual storage for database data. The alert.log is a single text file that records database events and cannot be multiplexed.

In Windows Server 2003, the default IIS log location is C:\WINDOWS\system32\LogFiles\W3SVC1, where W3SVC1 represents the default website's instance ID. Each website has its own W3SVC# subdirectory. The path structure is consistent across IIS 6.0 installations.

Flat files are used in ETL processes to balance the extraction and loading operations (staging area concept) and to resolve performance issues by providing an intermediate storage format that can be processed efficiently. They are not a dummy rule, and ease of maintenance is not their primary technical purpose.

IIS log files are stored by default in the system directory under LogFiles. For IIS 7 and later versions, the path C:\WINDOWS\system32\LogFiles\W3SVC1 is correct, where W3SVC1 represents the website identifier.

The strings command extracts and displays printable ASCII/Unicode strings from binary files, making it ideal for examining compiled executables to see embedded text, error messages, and configuration paths without executing code. file command only shows file type, ./a.out executes the binary, and None is meaningless.

In Android, openFileOutput() is the standard Context method used to open and write a private file associated with the application's internal storage. getSharedPreferences() and getPreferences() access preference files, while putBoolean() writes boolean preferences.

Web.config files are optional - applications can run without them using inherited settings. Machine.config is required as it defines the base configuration for the entire .NET framework on a machine. This hierarchical design allows optional application-specific overrides of required framework-level defaults.

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.