Computer Science/IT MCQs
Topic Notes: Computer Science/IT
MCQs and preparation resources for competitive exams, covering important concepts, past papers, and detailed explanations.
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
4921
Which type of database stores data in two-dimensional tables?
Answer:
Relational
Relational databases organize data into tables, which consist of rows and columns, allowing for flexible relationships between different data sets.
4922
The key used to uniquely identify a record in a database table is:
Answer:
Primary key
The primary key is a unique identifier for each record in a database table, ensuring that no two rows are identical.
4923
A regular subquery is processed:
Answer:
From the bottom up
In SQL, the innermost subquery is executed first, and its result is used by the outer query, continuing until the outermost query is processed.
4924
What is a key difference between a `UNIQUE` constraint and a `PRIMARY KEY` constraint?
Answer:
A `PRIMARY KEY` does not allow NULL values, while a `UNIQUE` constraint can allow one NULL value.
The main difference is that a primary key constraint is a combination of `UNIQUE` and `NOT NULL`. A unique constraint enforces uniqueness but typically allows a single `NULL` value in the column.
4925
In the relational model, what is a tuple?
Answer:
A row in a table.
In the formal terminology of the relational model, a row in a table is called a tuple. It represents a single, implicitly structured data item in a table, consisting of a set of attribute values.
4926
Denormalization introduces ______ in a controlled manner.
Answer:
Redundancy
The core idea of denormalization is to strategically add redundant data to the database. This is a controlled process designed to improve performance, unlike the uncontrolled redundancy that normalization aims to eliminate.
4927
The logical level of data abstraction describes:
Answer:
The entire database structure for a community of users.
The logical level (or conceptual level) describes what data is stored in the database and what relationships exist among that data. It hides the details of physical storage structures and concentrates on describing the entire database.
4928
What is an insertion anomaly?
Answer:
The inability to insert data about one entity without inserting data about another unrelated entity.
An insertion anomaly occurs when you cannot add a new record to the database because a required attribute value is not yet known. For example, you cannot add a new course if no students are enrolled in it yet.
4929
What does the `GROUP BY` clause do?
Answer:
It groups rows that have the same values into summary rows.
The `GROUP BY` statement groups rows that have the same values in specified columns into summary rows, like "find the number of customers in each country". It is often used with aggregate functions (`COUNT`, `MAX`, `MIN`, `SUM`, `AVG`).
4930
A(n) _ is a collection of related data organized for easy access, management, updating, grouping, and summarizing.
Answer:
Database
A database is a structured set of data held in a computer, especially one that is accessible in various ways.