MCQ IN COMPUTER SCIENCE & ENGINEERING

Detailed explanation-1: -A file is a collection of records which have common properties. Each file has its own file reference which is unique. The file reference indicates the subject or contexts of the records. A record can be an image, text based or in electronic or physical format.

Detailed explanation-2: -File-a group of related records. Files are frequently classified by the application for which they are primarily used (employee file). A primary key in a file is the field (or fields) whose value identifies a record among others in a data file.

Detailed explanation-3: -The File/Record data type is a compound data type represented by the number 6 in the database dictionary. A file is a set of related records treated as a single unit and is stored on disk. A file is a particular kind of structure, but a structure is not a kind of file.

Detailed explanation-4: -Records in a database or spreadsheet are usually called “rows". A record is a collection of fields, possibly of different data types, typically in a fixed number and sequence.

Detailed explanation-5: -In simplest terms, a record is a fixed number of bytes containing data. Often, a record collects related information that is treated as a unit, such as one item in a database or personnel data about one member of a department.