60 Questions
Which term refers to a structured collection of data that is stored through a computer system?
Database
What is the software used by end-users and client-side applications to access the data in a database called?
Database management system
What is the term for the process of defining data models and is an essential step in designing a database?
Data modeling
What is a logical unit of work performed on a database called?
Transaction
Which type of data model is the most technically detailed?
Physical data model
Which one of these is NOT a measure of database reliability?
Availability
Which type of memory refers to storage that retains data even when not powered?
Non-volatile memory
What is the purpose of an operation in a database transaction?
To complete the transaction
Which term is used to represent a rectangle or a rounded rectangle in an ER Diagram?
Entity
What does a solid line represent in an ER Diagram?
A strong relationship
What is the purpose of an ER Diagram?
To illustrate a data model that can be converted into a database schema
What is the maximum number of elements of an entity that can be associated with the elements in another entity in a one-to-many relationship?
Multiple
Which type of database does not enforce relationships within the data?
NOSQL database
What is the primary key in the Song table of a relational database?
song_id
Which type of database uses a table format for data modeling?
Relational database
What is the primary key in the Playlist table of a NOSQL database?
playlist_id
Which type of database does not store data in tables?
NOSQL database
What is the purpose of a primary key in a relational database?
To uniquely identify each row of a table
Which type of database uses a flexible schema and can easily scale to high request throughput and large data sizes?
NOSQL database
What is the most common type of NOSQL database?
Key-value database
Which type of database design technique stores data in a non-redundant and consistent schema?
Normalization
What is the cardinality of the parent to the embedded elements in an embedded schema?
One-to-few
Which type of schema is more efficient for fetching playlists with song information when checking if a song is already in an existing playlist?
Non-embedded schema
What is the purpose of denormalization in database design?
To improve query performance
Which approach stores two copies of the song's information, once in the Song table and again in the Playlist table?
Denormalized approach
What is the primary advantage of denormalization in a database?
Improved read performance
What does denormalization mean in the context of a database?
Combining data by grouping or embedding
In the denormalized schema, where are the redundant copies of the song's title, artist, and album stored?
Playlist table
What is the primary trade-off of adding redundant copies of data within a database?
Decreased write performance
What is the purpose of denormalization in a database?
To improve read performance
Which term refers to the physical implementation of a database model to a specific database platform?
Database schema
What is the process of defining data models and is an essential step in designing a database called?
Data modeling
What is the term for a logical unit of work performed on a database?
Database transaction
What is the purpose of denormalization in a database?
To improve performance by reducing data redundancy
Which type of database is commonly used for online transaction processing (OLTP) and online analytical processing (OLAP)?
Relational database
What is the primary key in the Song table of a relational database?
song_id
Which type of database stores data in a non-tabular format and is often referred to as a non-relational database?
NOSQL database
What is the purpose of denormalization in database design?
To improve query performance
Which type of data model provides the most detailed information about data structure, including entities, attributes, and relationships?
Physical data model
What is the measure of a database's integrity, safety, and recoverability called?
Reliability
Which type of memory retains data even when not powered?
Non-volatile memory
What is the purpose of a primary key in a relational database?
To uniquely identify a record in a table
Which type of database design technique eliminates inconsistencies during write and modify operations?
Normalization
What is the cardinality of the parent to the embedded elements in an embedded schema?
One-to-few
Which type of schema is more efficient for fetching playlists with song information when checking if a song is already in an existing playlist?
Non-embedded schema
What is the primary advantage of denormalization in a database?
Improved query performance
Which one of these is true about ER diagrams?
ER diagrams are used to design databases conceptually
Which one of these is true about attributes in an ER diagram?
Attributes can be denoted as primary keys or foreign keys
Which one of these is true about relationships in an ER diagram?
A solid line represents a strong (identifying) relationship
Which one of these is true about cardinality and modality in an ER diagram?
Cardinality refers to the maximum number of elements associated with another entity
Which type of database design technique stores data in a non-redundant and consistent schema?
Normalized schema
What is the cardinality of the parent to the embedded elements in an embedded schema?
One-to-One
What is the maximum number of elements of an entity that can be associated with the elements in another entity in a one-to-many relationship?
Unlimited
What is the purpose of denormalization in database design?
To improve write performance
Which approach stores two copies of the song's information, once in the Song table and again in the Playlist table?
Denormalized approach
What is the purpose of a primary key in a relational database?
To uniquely identify records
Which type of database uses a table format for data modeling?
Relational database
Which type of database does not store data in tables?
NOSQL database
What is the primary trade-off of adding redundant copies of data within a database?
Increased complexity and maintenance
What is the purpose of an ER Diagram?
To visualize relationships within data in a relational database
Test your knowledge of database terminology with this quiz! Explore terms like structured collection of data, software for accessing data, defining data models, and more.
Make Your Own Quizzes and Flashcards
Convert your notes into interactive study material.
Get started for free