A collection of related records in database is known as a .... This is another question I am asked quite frequently. A simple question but students get confused very easily. One reason is that the options are very close, and the other is different sites present different answer. So, for anybody taking reference from websites, it has been hard to settle on an option as correct answer. Thus here I present explanation and correct answer to this question.
The question and provided options are as follows:
a collection of related records in database is known as a
- a) table
- b) database
- c) file
- d) none of the above
Correct Answer: a) Table
Show your love! Share this page!
A collection of related records in database is known as a
In database hierarchy bits and bytes compose characters and numbers which represent the data items. Data items of similar type or attribute makes up a fields. Collection of fields of an entity makes up a record. Collection of records related to a particular subject makes up a table or a file. Collection of tables or files makes up a database.
In many websites that copied questions and answer directly from psexam.com, you'll find 'File' marked as correct answer.
In traditional database systems without tables (eg. flat file database) the term 'file' is used for the collection of related records. Relational Database Management Systems organize data in rows (records) and columns (fields) and call it a table.
Among the given options, we have 'table' and when we get more specific option it should be the correct answer. For questions having option 'File' but no 'Table', the option File is correct answer.
Reference and Proof
- Quizlet - Database and Database Management System
- CourseHero - Solved Exercise (fill in the blanks)
- Wikipedia - Datta Hierarchy