Introduction to Computing MCQs with Answers
Practice important Introduction to Computing MCQs with answers and explanations.
Chapter: 153
Q2161:
What does the relational database model use to represent data?
A. Files
B. Objects
C. Relations
D. Trees
Correct Answer:
C
Chapter: 153
Q2162:
In the relational database model, what is a row in a relation called?
A. Tuple
B. Attribute
C. Relation
D. Entity
Correct Answer:
A
Chapter: 153
Q2163:
In the relational database model, what are columns in a relation referred to as?
A. Tuples
B. Attributes
C. Relations
D. Entities
Correct Answer:
B
Chapter: 153
Q2164:
What is the primary advantage of using the relational database model?
A. It simplifies the internal database structure
B. It provides a conceptual view of data as tables
C. It optimizes data retrieval speed
D. It encrypts data by default
Correct Answer:
B
Chapter: 153
Q2165:
How does a DBMS interact with a relational database model?
A. By directly manipulating the data storage system
B. By translating conceptual commands into actions on the data storage system
C. By storing data in files
D. By creating visual representations of data
Correct Answer:
B
Chapter: 153
Q2166:
Fill in the blank: In the relational database model, data is portrayed as being stored in rectangular _____ called relations.
A. tables
B. files
C. rows
D. attributes
Correct Answer:
A
Chapter: 153
Q2167:
Fill in the blank: In a relation, a _____ represents a single record or entry, containing information about a particular entity.
A. tuple
B. column
C. relationship
D. field
Correct Answer:
A
Chapter: 153
Q2168:
Fill in the blank: In the relational database model, the term _____ refers to the characteristics or attributes described by each column in a relation.
A. tuple
B. record
C. relation
D. attribute
Correct Answer:
D
Chapter: 153
Q2169:
Fill in the blank: The relational database model allows information to be represented in a format similar to that used by _____ programs.
A. database management system
B. network management system
C. operating system
D. spreadsheet
Correct Answer:
A
Chapter: 153
Q2170:
Fill in the blank: A _____ in the relational database model consists of columns, each of which describes an attribute of the entity represented.
A. tuple
B. relation
C. record
D. file
Correct Answer:
B
Chapter: 154
Q2171:
What is a primary problem with including job-related attributes directly in the employee relation?
A. Redundancy
B. Complexity
C. Normalization
D. Indexing
Correct Answer:
A
Chapter: 154
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
Correct Answer:
A
Chapter: 154
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
Correct Answer:
C
Chapter: 154
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
Correct Answer:
C
Chapter: 154
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
Correct Answer:
A
Chapter: 154
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
Correct Answer:
A
Chapter: 154
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
Correct Answer:
D
Chapter: 154
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
Correct Answer:
A
Chapter: 154
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
Correct Answer:
D
Chapter: 154
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
Correct Answer:
B