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
31
In the context of file organization, which method typically utilizes a hashing scheme?
Answer:
direct file organization
Hashing is a technique used in direct (or random) file organization to map a search key directly to a specific physical address on a storage medium. This allows for near-instantaneous retrieval of records without needing to search through a list or index.
32
For which professional role are file specification documents primarily developed?
Answer:
programmers
File specification documents serve as technical blueprints that detail the structure, data types, and constraints of data files.
33
Structured Query Language (SQL) is categorized into which of the following functional sub-languages?
Answer:
All of the above
SQL is a comprehensive language for database management.
34
What is the formal term for a language or notation used to define the structure and form of data?
Answer:
Data definition language
A Data Definition Language (DDL) is a syntax used in database management systems to define, modify, and manage the structure of database objects, such as tables, schemas, and indexes.
35
What is the term for a symbol or sign that specifies operations and values to produce a calculated result?
Answer:
Operator
An operator is a character or symbol that represents an action, such as addition (+), subtraction (-), or multiplication (*). When combined with values (operands), these operators perform calculations to produce a specific result.
36
What term describes a structured collection of data designed to facilitate efficient access, retrieval, and management?
Answer:
Database
A database is a systematically organized collection of structured information or data, typically stored electronically in a computer system, allowing for easy management, updating, and retrieval by various applications.
37
Where is the information gathered during the database development process typically stored?
Answer:
repository
During database development, a repository serves as a central location to store all gathered information, including requirements, design documents, metadata, and models. This ensures consistency and accessibility for the development team.
38
What is the term used to describe the state of data within a database at a specific point in time?
Answer:
Extension
In database theory, the extension refers to the actual set of tuples or data present in the database at a given moment. In contrast, the intension refers to the database schema or the design structure that remains constant over time.
39
Which database management system model is characterized by the concept of ownership or hierarchical relationships?
Answer:
Network database system
A network database system is a type of database model that allows each record to have multiple parent and child records.
40
In the context of database management, a field is defined as a related group of which of the following?
Answer:
records
In database terminology, a field is a single piece of data, while a record is a collection of related fields. Note: This question is technically inaccurate as a field is a collection of characters, not records.