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
4791
Which conceptual model is used to describe the data, relationships, and constraints for a database at a high level?
Answer:
Entity-Relationship (ER) Model
The ER model is a high-level conceptual data model. It is used in the database design phase to create a visual and logical representation of the system's requirements before it is translated into a specific database implementation like the relational model.
4792
What feature enables record search in databases?
Answer:
Query
Queries allow users to extract specific data based on defined conditions. [cite: 288]
4793
In an Entity-Relationship (ER) diagram, what does a rectangle represent?
Answer:
An entity set
In standard ER notation, a rectangle is used to represent an entity set, which is a collection of similar entities (e.g., a set of all students or all employees).
4794
A `DOMAIN` constraint specifies the:
Answer:
Set of permissible values for a column.
Domain integrity ensures that all values in a column are from a defined set of valid values. This can be enforced using data types, CHECK constraints, and NOT NULL constraints.
4795
In the terminology of the relational model, a single row of a table is also known as a:
Answer:
Tuple
In the formal relational model, a row is called a tuple. It represents a single, implicitly structured data item in a table.
4796
To remove all records from a table named 'Sales' without deleting the table structure itself, which command is generally the most efficient?
Answer:
`TRUNCATE TABLE Sales;`
`TRUNCATE TABLE` is a DDL command that quickly removes all rows from a table. It is much faster than `DELETE` because it doesn't log each row deletion and typically cannot be rolled back.
4797
A field or a collection of fields in a table that uniquely identifies each record is called a:
Answer:
Primary Key
The primary key is a special relational database table column (or set of columns) designated to uniquely identify all table records. A primary key’s main features are that it must contain a unique value for each row of data and it cannot contain null values.
4798
What key links records from one database table to another?
Answer:
Foreign key
A foreign key is a key in one table that refers to the primary key in another table, creating a link or relationship between them.
4799
Information can be transferred between the DBMS and a:
Answer:
All of the above
Most modern Database Management Systems are designed for interoperability. They typically provide export and import functions that allow data to be easily transferred to and from other types of applications, including spreadsheets, word processors, and graphics programs.
4800
To remove specific rows from a table that meet a certain condition, you would use the:
Answer:
`DELETE` command
The `DELETE` command is a DML statement used to remove one or more rows from a table. A `WHERE` clause is used to specify a condition to select the rows to be deleted.