DATA 630: Applied Database Management (100%
Guaranteed)
Historically, what has driven many information technology developments? correct answers Data
needs
What is data modeling primarily used for? correct answers To represent relationships between
business entities
In data-related terms, what is an entity? correct answers A thing in the real world with an
independent existence
What is a record in storage-related terms? correct answers A group of related fields
What is the primary feature of a database management system?
Efficient data handling. It stores data in an organized manner.
Data security and access control.
It allows for easy access and manipulation of data.
Minimize Data redundancy. It reduces data duplication.
All of the above correct answers ALL
In a binary relationship, how many entities are involved? correct answers TWO
What can be seen as a disadvantage of data redundancy?
Wastes storage space
Leads to data inconsistencies
Both A and B
Neither A nor B correct answers BOTH A & B
Which of the following best defines an attribute in database terms? correct answers A
characteristic or property of an entity
Which of the following best describes a ternary relationship? correct answers A relationship
among three entities
Which of these is NOT a storage-related term?
Entity
Field
Record
File correct answers Entity
Historically, why did the development of database management systems arise?
To manage increasing volumes of business data
To develop modern computers
To facilitate online shopping
, To improve graphics in computer games correct answers To manage increasing volumes of
business data
What best describes the essence of data modeling?
Diagramming the business environment
Programming the database
Storing data in a physical location
Encrypting sensitive data correct answers Diagramming the business environment
Which relationship allows both entities to have multiple instances related to multiple instances of
the other entity?
One-to-one
One-to-many
Many-to-many
Unary correct answers Many-to-many
Which of these is an accurate description of a record in a database?
A collection of related databases
A specific characteristic of an entity
A group of related fields representing an entity
A diagram showing relationships between entities correct answers A group of related fields
representing an entity
True/ False: Candidate keys can have null values in a relational database correct answers False
True/False: In a one-to-many relationship, the many side typically contains a foreign key
referencing the primary key on the one side. correct answers True
True/False: The select operator and project operator in relational algebra serve the same purpose
and can be used interchangeably. correct answers False
In relational database terms, which of the following best describes a 'relation'?
A row in a table
A set of tuples
A database key
A database query correct answers A set of tuples
How is a many-to-many relationship implemented in a relational database? Using two foreign
keys
Using a junction table
Using a primary key on both sides
It is not possible to implement correct answers Using a junction table
What does the project operator do in relational algebra?
It filters records based on conditions
It merges attributes based on a common attribute
Guaranteed)
Historically, what has driven many information technology developments? correct answers Data
needs
What is data modeling primarily used for? correct answers To represent relationships between
business entities
In data-related terms, what is an entity? correct answers A thing in the real world with an
independent existence
What is a record in storage-related terms? correct answers A group of related fields
What is the primary feature of a database management system?
Efficient data handling. It stores data in an organized manner.
Data security and access control.
It allows for easy access and manipulation of data.
Minimize Data redundancy. It reduces data duplication.
All of the above correct answers ALL
In a binary relationship, how many entities are involved? correct answers TWO
What can be seen as a disadvantage of data redundancy?
Wastes storage space
Leads to data inconsistencies
Both A and B
Neither A nor B correct answers BOTH A & B
Which of the following best defines an attribute in database terms? correct answers A
characteristic or property of an entity
Which of the following best describes a ternary relationship? correct answers A relationship
among three entities
Which of these is NOT a storage-related term?
Entity
Field
Record
File correct answers Entity
Historically, why did the development of database management systems arise?
To manage increasing volumes of business data
To develop modern computers
To facilitate online shopping
, To improve graphics in computer games correct answers To manage increasing volumes of
business data
What best describes the essence of data modeling?
Diagramming the business environment
Programming the database
Storing data in a physical location
Encrypting sensitive data correct answers Diagramming the business environment
Which relationship allows both entities to have multiple instances related to multiple instances of
the other entity?
One-to-one
One-to-many
Many-to-many
Unary correct answers Many-to-many
Which of these is an accurate description of a record in a database?
A collection of related databases
A specific characteristic of an entity
A group of related fields representing an entity
A diagram showing relationships between entities correct answers A group of related fields
representing an entity
True/ False: Candidate keys can have null values in a relational database correct answers False
True/False: In a one-to-many relationship, the many side typically contains a foreign key
referencing the primary key on the one side. correct answers True
True/False: The select operator and project operator in relational algebra serve the same purpose
and can be used interchangeably. correct answers False
In relational database terms, which of the following best describes a 'relation'?
A row in a table
A set of tuples
A database key
A database query correct answers A set of tuples
How is a many-to-many relationship implemented in a relational database? Using two foreign
keys
Using a junction table
Using a primary key on both sides
It is not possible to implement correct answers Using a junction table
What does the project operator do in relational algebra?
It filters records based on conditions
It merges attributes based on a common attribute
