The problem of synonyms occurs in:
Correct answer: C. Indexed sequential files
- A. Sequential files
- B. Direct or random files
- C. Indexed sequential files
- D. Master files
Explanation
The correct answer is C. Indexed sequential files.Indexed sequential files (ISAM) use an indexing technique to improve the speed of data retrieval. However, this indexing mechanism can introduce the issue of synonyms.Synonyms arise when multiple records have the same value in the key field used for indexing. While each record itself might be unique (containing different data in other fields), the indexing scheme may not be able to differentiate between them based solely on the key field. This can result in retrieving incorrect records during searches.Here's why the other options are incorrect:A. Sequential files: Sequential files process data records in a linear order, one after the other. The concept of synonyms doesn't apply to sequential file organization because data isn't retrieved using an index based on a key field.B. Direct or random files: Direct or random access files allow direct access to any data record using its physical address (like a record number). Similar to sequential files, there's no indexing mechanism susceptible to synonyms in this approach.D. Master files: A master file is a central repository that stores essential data records. It doesn't have a specific file organization structure and can be implemented using various file types, including sequential, indexed sequential, or direct access files. So, the concept of synonyms is not inherently tied to master files themselves
Last updated
About Databases
Databases cover tables, records, fields, keys and relationships, together with database management systems and relational database design. The subject includes primary and foreign keys, normalization, SQL commands such as SELECT, INSERT, UPDATE and DELETE, queries, forms and reports, while distinguishing a database from a spreadsheet used for simple tabular data.
Practise Databases
210 free Databases MCQs from Computer Science and IT, each with the correct answer and an explanation. Unlimited attempts, no account needed.
Exams that ask Computer Science and IT questions like this
Computer Science and IT is on 40 papers prepared for on TestUstad, and all of them draw the same bank, so this question is worth knowing for every one of them.
Related questions
A category of data or information that describes an entity is called
A collection of data that include name, address, phone number etc, of a person:
A collection of raw facts and figures is called:
A constraint between two attributes is called a(n)
A database containing all student in a class would store Roll no of student in: