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
111
In database management systems, what term describes a specific property or piece of information that characterizes an entity?
Answer:
Attribute
In the context of relational database design, an attribute represents a specific characteristic or property of an entity. For example, if the entity is 'Student', attributes might include 'Name', 'Age', or 'Student_ID'. These attributes define the data stored within the columns of a table.
112
Which of the following operations is typically not performed by a standard Queue data structure?
Answer:
Retrieving
A queue is a First-In-First-Out (FIFO) data structure that primarily supports insertion (enqueue) at the rear and deletion (dequeue) at the front. While traversing is possible, retrieving an arbitrary element from the middle of a queue is not a standard operation, as it violates the FIFO principle.
113
What is considered the most fundamental data distribution strategy in database systems?
Answer:
Centralized
A centralized strategy is the most basic form of data distribution, where all data is stored at a single, central location. While modern systems often use distributed approaches, the centralized model serves as the foundational architecture for many database management systems.
114
During which phase of the SDLC is the scope and fundamental nature of a business problem identified?
Answer:
the preliminary investigation
The preliminary investigation is the stage where the project team defines the problem, assesses the current system's limitations, and establishes the scope. This ensures that the project team understands the core issues before proceeding to detailed analysis and design.
115
At which stage of the database development lifecycle is the physical organization of data on disk storage determined?
Answer:
Physical design
The physical design phase focuses on how the database is actually implemented on the storage hardware. This includes defining file structures, indexing strategies, and data placement to optimize performance, distinguishing it from the logical design which focuses on the conceptual data model.
116
Which of the following terms refers to a set of conceptual tools used to define the structure and organization of a database?
Answer:
Data model
A data model is an abstract model that organizes elements of data and standardizes how they relate to one another and to the properties of real-world entities. It provides the structural blueprint for database design.
117
When selecting an appropriate file organization method, which of the following factors should be taken into account?
Answer:
All
Choosing a file organization strategy requires balancing multiple competing requirements. Designers must consider the speed of data retrieval, the security of the stored information, and the efficiency of storage space utilization to ensure the system meets both performance and operational needs.
118
Which professional is primarily responsible for acting as a change agent during the implementation of a new system?
Answer:
system analyst
A system analyst acts as a change agent by bridging the gap between business needs and technical solutions. They facilitate communication between stakeholders and developers, ensuring that the new system effectively addresses organizational requirements and promotes successful adoption.
119
Which of the following options is NOT considered a primary component of the physical database design process?
Answer:
Data volume and usage analysis
Physical database design focuses on how data is stored and accessed on physical storage media. While data volume and usage analysis are critical steps in the database development lifecycle, they are typically categorized as part of the requirements gathering or logical design phase rather than the physical design implementation itself.
120
What does a rectangle represent in a standard Entity-Relationship (E-R) diagram?
Answer:
Entity
In E-R diagramming notation, a rectangle is the standard geometric shape used to represent an entity. It serves as a container for the entity name and helps visualize the core objects within the database schema.