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
Report an error
The more specific you are, the faster it gets fixed. A source beats an opinion.
Prefer email? [email protected]
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.
Discussion
Stuck on an option, or know a faster way to get there? Ask or explain it here.
No comments yet. Be the first to explain this one.
Exams that ask Computer Science and IT questions like this
Computer Science and IT is on 85 papers prepared for on TestUstad, and all of them draw the same bank, so this question is worth knowing for every one of them.
More Databases questions
Which of the following is NOT a file extension for a database file?
The process of getting data from DBMS:
Which of the following is NOT a file type from a usage point of view?
Which software is used to maintain the database by manipulating the data, record, and files?
Which of the following data models is used to store data in the form of tables/relations?
The process of storing and retrieval of data from files is called