Question 1

An example of _________ data is the 1 million transactions generated by Walmart sales registers every hour.​

Accepted Answer

The answer of  An example of _________ data is the...

Question 2

__________ is a file system developed in 2005 that handles millions of files distributed across multiple server nodes.​

Accepted Answer

The answer of  __________ is a file system developed in...

Question 3

The term __________ refers to huge collections of data that are difficult to process, analyze, and manage using conventional database tools.​

Accepted Answer

The answer of  The term __________ refers to huge collections...

Question 4

The term __________ is used to refer to a group of technologies for managing databases that do not adhere to the relational model and standard SQL query language.​

Accepted Answer

The answer of  The term __________ is used to refer...

Question 5

In a key-value database, each data item has a key that is a unique identifier similar to a relational database key​

Accepted Answer

In a key-value database, each data item is identified by a unique key. This key is similar to a primary key in a relational database, but there is no fixed schema in a key-value database.

Question 6

The entire Internet contains about a zettabyte of data.​

Accepted Answer

The answer of  The entire Internet contains about a zettabyte...

Question 7

An emerging computing platform that is likely to drive innovation and disruption through the next decade called __________ has massive scale, not only in cloud-based hardware technology, but also in the vast amount of data that will be generated, consumed, and analyzed.​ 
A) ​The 3rd platform 
B) ​NoSQL 
C) ​SQL 
D) ​BLOB

Accepted Answer

The description of massive scale in cloud-based hardware technology and vast amounts of data being generated, consumed, and analyzed are characteristics of the 3rd platform, which includes technologies such as cloud computing, big data analytics, and the Internet of Things (IoT). NoSQL and SQL are database technologies, while BLOB stands for Binary Large Object, which refers to a data type used for storing large amounts of data, such as images or videos, in a database.

Question 8

When joining two tables using SQL, the convention is to use ______ notation for field names.​

Accepted Answer

The answer of  When joining two tables using SQL, the...

Question 9

Dynamic scaling for database servers can be a challenge because the additional sharding has to be handled on the fly by the DBMS.​

Accepted Answer

Dynamic scaling for database servers can be a challenge because it requires the DBMS to split the data into smaller chunks or shards, and this process has to be done on the fly without disrupting the service. This can be complex and resource-intensive, and not all DBMSs are equally capable of handling dynamic scaling. Therefore, it is a true statement that dynamic scaling for database servers can be a challenge.

Question 10

The simplest structure for storing data in a(n) _________  database is the key-value data model.​

Accepted Answer

The answer of  The simplest structure for storing data in...

Question 11

The process of dividing a database into distributed subsets is called ________.​

Accepted Answer

The answer of  The process of dividing a database into...

Question 12

____________ scaling (or autoscaling) ensures acceptable database throughput by scaling out as necessary to handle peak loads.​

Accepted Answer

The answer of  ____________ scaling (or autoscaling) ensures acceptable database...

Question 13

The SQL ________ command allows you to temporarily join and simultaneously access the data in more than one table.​ 
A) ​MERGE 
B) ​JOIN 
C) ​SELECT 
D) ​UPDATE

Accepted Answer

The JOIN command allows you to combine data from two or more tables into a single table, based on a related column between them. MERGE and UPDATE are used to modify data in a table, and SELECT is used to retrieve data from a table.

Question 14

Ten terabytes offer enough storage capacity to hold the printed collection of the Library of Congress.​

Accepted Answer

According to the Library of Congress, their printed collection contains approximately 10 terabytes of data. Therefore, ten terabytes would offer enough storage capacity to hold their entire printed collection.

Question 15

Relational databases are organized according to a(n) _________, which is simply the blueprint for its structure.​

Accepted Answer

The answer of  Relational databases are organized according to a(n)...

Question 16

SQL is banned from the NoSQL technology collection.​

Accepted Answer

SQL is a completely separate technology from NoSQL and is not banned from the NoSQL technology collection. NoSQL databases use different models and structures for data storage and retrieval compared to SQL databases.

Question 17

_________-density data refers to large volumes of very detailed data in which many of the details are not important.​

Accepted Answer

The answer of  _________-density data refers to large volumes of...

Question 18

Relational databases store unstructured data.​

Accepted Answer

Relational databases store structured data in tables with defined columns and data types. They do not store unstructured data such as images, videos, or documents. However, some relational database management systems (RDMBS) such as SQL Server and Oracle have extensions and features to work with unstructured data, but they are not stored as part of a traditional relational database structure.

Question 19

A __________ solution for data storage adds resources to a single device, while a __________ solution adds more devices to a system.​ 
A) ​SQL, NoSQL 
B) ​structured, unstructured 
C) ​scale out, scale up 
D) ​scale up, scale out

Accepted Answer

The answer of  A __________ solution for data storage adds...

Question 20

1024 Zettabytes = 1 _______.​

Accepted Answer

The answer of  1024 Zettabytes = 1 _______.​...

Quiz 10: Databases Database Basics

An example of _________ data is the 1 million transactions generated by Walmart sales registers every hour.

__________ is a file system developed in 2005 that handles millions of files distributed across multiple server nodes.

The term __________ refers to huge collections of data that are difficult to process, analyze, and manage using conventional database tools.

The term __________ is used to refer to a group of technologies for managing databases that do not adhere to the relational model and standard SQL query language.

In a key-value database, each data item has a key that is a unique identifier similar to a relational database key

The entire Internet contains about a zettabyte of data.

An emerging computing platform that is likely to drive innovation and disruption through the next decade called __________ has massive scale, not only in cloud-based hardware technology, but also in the vast amount of data that will be generated, consumed, and analyzed.

When joining two tables using SQL, the convention is to use ______ notation for field names.

Dynamic scaling for database servers can be a challenge because the additional sharding has to be handled on the fly by the DBMS.

The simplest structure for storing data in a(n) _________ database is the key-value data model.

The process of dividing a database into distributed subsets is called ________.

____________ scaling (or autoscaling) ensures acceptable database throughput by scaling out as necessary to handle peak loads.

The SQL ________ command allows you to temporarily join and simultaneously access the data in more than one table.

Ten terabytes offer enough storage capacity to hold the printed collection of the Library of Congress.

Relational databases are organized according to a(n) _________, which is simply the blueprint for its structure.

SQL is banned from the NoSQL technology collection.

_________-density data refers to large volumes of very detailed data in which many of the details are not important.

Relational databases store unstructured data.

A solution for data storage adds resources to a single device, while a solution adds more devices to a system.

1024 Zettabytes = 1 _______.