Introduction to Computing MCQs with Answers
Practice important Introduction to Computing MCQs with answers and explanations.
Multiple Choice Questions
Q2171: What is a primary problem with including job-related attributes directly in the employee relation?
- A: Redundancy
- B: Complexity
- C: Normalization
- D: Indexing
View Answer
A
Q2172: What can happen if an employee who holds a unique job is deleted from a relation containing redundancy?
- A: The job information is lost
- B: The employee's information is lost
- C: The department information is lost
- D: The skill code information is lost
View Answer
A
Q2173: How can the issue of redundancy in a relational database be addressed?
- A: By combining multiple concepts in one relation
- B: By using a single table for all information
- C: By redesigning the database into separate relations
- D: By adding more columns to the existing table
View Answer
C
Q2174: Which of the following is NOT a benefit of separating the employee, job, and assignment information into different relations?
- A: Reduced redundancy
- B: Improved efficiency
- C: Complicated query structure
- D: Loss of partial tuple information
View Answer
C
Q2175: What information is repeated in a relation if an employee has held multiple jobs?
- A: Employee's personal information
- B: Job's skill code
- C: Department associated with a job
- D: Job's identification code
View Answer
A
Q2176: In the context of relational databases, what does the term "tuple" refer to?
- A: A row in a table
- B: A column in a table
- C: A unique identifier for a record
- D: A database operation
View Answer
A
Q2177: What attribute is NOT included in the extended relation discussed in the content?
- A: Employee name
- B: Job title
- C: Department Skill code
- D: Employee performance evaluation
View Answer
D
Q2178: What problem arises when using partial tuples in a relational database design?
- A: It introduces complexity in maintaining data
- B: It simplifies data retrieval
- C: Reduces redundancy
- D: Improves data integrity
View Answer
A
Q2179: How does the proposed redesign using three relations solve the redundancy issue?
- A: It combines multiple concepts into a single table
- B: It introduces new columns for additional information
- C: It separates information into distinct categories
- D: It removes all redundant data
View Answer
D
Q2180: What type of information would be retained in the JOB relation according to the proposed redesign?
- A: Employee personal details
- B: Job title and skill code
- C: Assignment dates and department
- D: Employee identification number
View Answer
B