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 a dynamic mathematical calculation that displays a single value for a specific field called?
Answer:
Aggregate function ·
An aggregate function performs a calculation on a set of values and returns a single summary value. Common examples include SUM, AVG, COUNT, MAX, and MIN.
2
What is the formal term for a collection of related data tables within a database management system?
Answer:
_ Database
A database is defined as an organized collection of structured information or data, typically stored electronically.
3
What is the standard procedure to create a relationship between two tables in a database?
Answer:
of a table
To establish a relationship between two tables in a relational database, you typically drag the primary key from one table and drop it onto the corresponding foreign key in another table.
4
Which of the following is the fundamental building block of a database?
Answer:
Table”
A table is the primary object in a relational database where all data is stored. It organizes information into rows (records) and columns (fields).
5
Which database component serves as the unique identifier for each individual record within a table?
Answer:
Unique Key
In database terminology, a unique key is a constraint that ensures all values in a column or set of columns are distinct.
6
When establishing a relationship, which component is typically dragged from the parent table?
Answer:
parent table
To create a relationship between two tables in a relational database management system, you typically drag the primary key field from the parent table and drop it onto the corresponding foreign key field in the child table.
7
Which type of key is used to uniquely identify each individual record within a database table?
Answer:
Unique Key
A unique key is a constraint that ensures all values in a column are different from one another.
8
What action is performed when you drop a field onto a child table to create a relationship?
Answer:
e done to
In database management software, dragging a primary key from a parent table and dropping it onto a child table is the standard procedure to define a relationship.
9
Which data field type typically occupies 8 bytes of storage space?
Answer:
Date/timeY
In many database management systems, the Date/Time data type is designed to store both date and time information using an 8-byte double-precision floating-point format.
10
Functional Dependendes are. the types of constraints that are based on _ ____,..., :
Answer:
Key
The source answer is option A (Key). Review the stem and options, then update the correct answer in Question Bank if the source key is wrong.