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
81
Which component is used to define the specific characteristics or properties of an object in a database model?
Answer:
Attribute
Attributes are the properties or characteristics that describe an entity. For instance, if the entity is a 'Student', its attributes might include 'Name', 'Student_ID', and 'Date_of_Birth', which provide specific details about each instance.
82
In a batch processing environment, which file type is specifically designated for storing the primary, long-term data records?
Answer:
Master files
In batch processing, a master file contains the permanent or semi-permanent data that is updated periodically. Transaction files contain the new data that needs to be processed against the master file to reflect changes, ensuring the master file remains the authoritative source of information.
83
Which category of business reports is specifically designed to highlight deviations from expected performance or operational standards?
Answer:
exception reports
Exception reports are generated to alert management when specific conditions or thresholds are met or exceeded, such as errors or performance issues. They focus on identifying anomalies rather than providing routine data, allowing for targeted intervention and efficient problem-solving in business operations.
84
In the context of data processing, what is the final result produced after processing input data?
Answer:
Information
In computing, data refers to raw facts and figures. When this raw data is processed, organized, and structured by a computer system, it becomes meaningful and useful to the user. This processed output is defined as information. Therefore, information is the result of the data processing cycle.
85
Which of the following terms is also commonly referred to as a data set?
Answer:
File
In computing, a file is essentially a collection of related data records stored together under a single name. Because it acts as a container for a structured collection of information, it is frequently referred to as a data set in various technical contexts.
86
Which of the following file types is typically considered a temporary file?
Answer:
Transaction file
Transaction files are often temporary in nature because they are created to hold data for a specific processing cycle. Once the data has been successfully posted to the master file, the transaction file is often archived or deleted.
87
What is the defining characteristic of a fixed-length field in a database?
Answer:
Constant
A fixed-length field is defined by having a predetermined, unchanging number of characters allocated for each entry. Regardless of the actual data stored, the storage space remains constant, which simplifies data processing and indexing tasks in database management systems.
88
In the context of database structure, what does the name of a person typically represent?
Answer:
Field
In a database table, a field represents a single piece of information or an attribute of an entity. The name of a person is a specific attribute, and therefore, it is stored within a designated field (such as 'First Name' or 'Last Name') in a database record.
89
What is the formal definition for a collection of logically related data?
Answer:
Database
A database is defined as an organized collection of structured, logically related data. It is designed to be easily accessed, managed, and updated, serving as the foundation for information systems and various software applications.
90
How is the concept of distributed data entry defined in information systems?
Answer:
Entered at different locations where it originates
Distributed data entry allows data to be captured and input at the source location where the transaction or event occurs, rather than being sent to a central facility for batch processing, which improves data accuracy and timeliness.