Database quiz

Which term refers to a structured collection of data that is stored through a computer system?

What is the software used by end-users and client-side applications to access the data in a database called?

What is the term for the process of defining data models and is an essential step in designing a database?

What is a logical unit of work performed on a database called?

Which type of data model is the most technically detailed?

Which one of these is NOT a measure of database reliability?

Which type of memory refers to storage that retains data even when not powered?

What is the purpose of an operation in a database transaction?

Which term is used to represent a rectangle or a rounded rectangle in an ER Diagram?

What does a solid line represent in an ER Diagram?

What is the purpose of an ER Diagram?

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?

Which type of database does not enforce relationships within the data?

What is the primary key in the Song table of a relational database?

Which type of database uses a table format for data modeling?

What is the primary key in the Playlist table of a NOSQL database?

Which type of database does not store data in tables?

What is the purpose of a primary key in a relational database?

Which type of database uses a flexible schema and can easily scale to high request throughput and large data sizes?

What is the most common type of NOSQL database?

Which type of database design technique stores data in a non-redundant and consistent schema?

What is the cardinality of the parent to the embedded elements in an embedded schema?

Which type of schema is more efficient for fetching playlists with song information when checking if a song is already in an existing playlist?

What is the purpose of denormalization in database design?

Which approach stores two copies of the song's information, once in the Song table and again in the Playlist table?

What is the primary advantage of denormalization in a database?

What does denormalization mean in the context of a database?

In the denormalized schema, where are the redundant copies of the song's title, artist, and album stored?

What is the primary trade-off of adding redundant copies of data within a database?

What is the purpose of denormalization in a database?

Which term refers to the physical implementation of a database model to a specific database platform?

What is the process of defining data models and is an essential step in designing a database called?

What is the term for a logical unit of work performed on a database?

What is the purpose of denormalization in a database?

Which type of database is commonly used for online transaction processing (OLTP) and online analytical processing (OLAP)?

What is the primary key in the Song table of a relational database?

Which type of database stores data in a non-tabular format and is often referred to as a non-relational database?

What is the purpose of denormalization in database design?

Which type of data model provides the most detailed information about data structure, including entities, attributes, and relationships?

What is the measure of a database's integrity, safety, and recoverability called?

Which type of memory retains data even when not powered?

What is the purpose of a primary key in a relational database?

Which type of database design technique eliminates inconsistencies during write and modify operations?

What is the cardinality of the parent to the embedded elements in an embedded schema?

Which type of schema is more efficient for fetching playlists with song information when checking if a song is already in an existing playlist?

What is the primary advantage of denormalization in a database?

Which one of these is true about ER diagrams?

Which one of these is true about attributes in an ER diagram?

Which one of these is true about relationships in an ER diagram?

Which one of these is true about cardinality and modality in an ER diagram?

Which type of database design technique stores data in a non-redundant and consistent schema?

What is the cardinality of the parent to the embedded elements in an embedded 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?

What is the purpose of denormalization in database design?

Which approach stores two copies of the song's information, once in the Song table and again in the Playlist table?

What is the purpose of a primary key in a relational database?

Which type of database uses a table format for data modeling?

Which type of database does not store data in tables?

What is the primary trade-off of adding redundant copies of data within a database?

What is the purpose of an ER Diagram?