Computer Science - IT MCQs
Topic Notes: Computer Science - IT
<p>MCQs and preparation resources for competitive exams, covering important concepts, past papers, and detailed explanations.</p>
Plato
- Biography: Ancient Greek philosopher (427–347 BCE), student of Socrates and teacher of Aristotle, founder of the Academy in Athens.
- Important Ideas:
- Theory of Forms
- Philosopher-King
- Ideal State
1
What is the term for a collection of related data that is organized and stored together in a computer system?
Answer:
Database
A database is an organized collection of related data that is stored together in a computer system. It allows for efficient storage, retrieval, and management of data, enabling users to access and manipulate information as needed.
2
What is the term for a collection of related files that are organized and stored together in a database system?
Answer:
Database
A database is an organized collection of related files that are stored together in a structured manner.
3
What is the term for a collection of related records that are stored together in a database?
Answer:
File
A file is a collection of related records that are stored together in a database. It serves as a container for data, allowing for efficient storage and retrieval of information.
4
What is the term for a collection of related data fields that together represent a single entity in a database?
Answer:
Record
A record is a collection of related fields that together represent a single entity or item in a database.
5
What is the term for the smallest logical unit of data in a database?
Answer:
Field
In database terminology, a field is the smallest logical data entity. It represents a single piece of information, such as a name, age, or ID number.
6
For which type of application is sequential file organization considered the most appropriate method?
Answer:
payroll
Sequential file organization is highly efficient for batch processing tasks where every record in a file must be accessed in a specific order.
7
What term defines the overall structure and organization of data stored within a database system?
Answer:
Schema
A database schema represents the logical configuration of a database, acting as a blueprint that defines how data is organized, including tables, fields, and the relationships between them.
8
What is the term for a repository designed to store data, typically focused on a specific subject or topic?
Answer:
Databank
A databank is a collection of information or data that is organized and stored in a repository, often focused on a specific subject matter.
9
What term describes a data item that cannot be further subdivided into smaller, meaningful components?
Answer:
Elementary data item
An elementary data item, also known as an atomic data item, is a piece of information that is considered indivisible in the context of a specific data model.
10
What is the term for a field in one table that serves as a primary key in another related table?
Answer:
Foreign key
In relational database management systems, a foreign key is a column or group of columns that provides a link between data in two tables. It acts as a cross-reference between tables by referencing the primary key of another table.