Introduction to Computing MCQs with Answers
Practice important Introduction to Computing MCQs with answers and explanations.
Multiple Choice Questions
Q2181: Fill in the blank: The lack of efficiency due to redundancy in a relational database can lead to multiple tuples containing the same __________.
- A: Employee identification number
- B: Job title
- C: Skill code
- D: Job identification code
View Answer
A
Q2182: Fill in the blank: To avoid losing job-related information when an employee is deleted, the relational database design should include a separate __________ relation.
- A: Employee
- B: Job
- C: Assignment
- D: Department
View Answer
B
Q2183: Fill in the blank: Combining employee, job, and assignment information into a single relation can cause issues with __________.
- A: Database performance
- B: Data integrity
- C: Complexity
- D: Redundancy
View Answer
D
Q2184: What operation is used to retrieve specific tuples from a relation?
- A: Projection
- B: Selection
- C: Joins
- D: Union
View Answer
B
Q2185: What does selecting tuples with a certain department from the JOB relation result in?
- A: A relation containing one tuple
- B: A relation containing several tuples
- C: A relation with no tuples
- D: A relation with duplicate tuples
View Answer
B
Q2186: When retrieving information about an employee from the EMPLOYEE relation, what is the result?
- A: A relation with several tuples
- B: A relation with no tuples
- C: A relation with one tuple
- D: A relation with a summary of data
View Answer
C
Q2187: Which relational operation would be used to obtain a list of job titles in a certain department?
- A: Projection
- B: Selection
- C: Joins
- D: Union
View Answer
B
Q2188: What is the primary purpose of the SELECT operation in relational databases?
- A: To combine tuples from multiple relations
- B: To retrieve specific tuples based on criteria
- C: To update existing tuples
- D: To delete tuples
View Answer
D
Q2189: Fill in the blank: When you select tuples from a relation based on a certain attribute value, you create a new __________ that consists of tuples meeting the criteria.
- A: Relation
- B: Table
- C: View
- D: Subset
View Answer
B
Q2190: Fill in the blank: Retrieving all job titles from the JOB relation for a given department results in a relation with __________ tuples.
- A: No
- B: One
- C: Multiple
- D: Zero
View Answer
C