Question 1

To ensure reliability and integrity, SQL databases conform to four specific properties. Which of the following is NOT one of those four properties?
A)​atomicity
B)​durability
C) ​isolation
D) ​currency

Accepted Answer

The four specific properties that ensure reliability and integrity in SQL databases are atomicity, durability, isolation and consistency. "Currency" is not one of these four properties.

Question 2

A database is a collection of integrated and related _____.
A)fields
B)attributes
C) records
D) files

Accepted Answer

The answer of A database is a collection of integrated...

Question 3

Kyle works for National Sporting Goods, where he manages critical data elements, such as identifying and acquiring new data sources, creating consistent reference data, and analyzing data for quality. Kyle is a _______.
A)​data steward
B)​data administrator
C) ​database administrator
D) ​data manager

Accepted Answer

Kyle's role involves managing critical data elements, such as identifying and acquiring new data sources, creating consistent reference data, and analyzing data for quality. This aligns with the responsibilities of a data steward, who is responsible for ensuring that the organization's data assets are properly managed and governed. Data administrators and database administrators may have more technical responsibilities related to the operation and maintenance of databases, while data managers may have broader responsibilities related to data strategy and governance.

Question 4

A ______ is a collection of instructions and commands used to define and describe data and relationships in a specific database.
A)data dictionary
B)schema
C) data definition language
D) data manipulation language

Accepted Answer

The answer of A ______ is a collection of instructions...

Question 5

The smallest piece of data used by a computer is a(n) _____.
A)entity
B)byte
C) bit
D) character

Accepted Answer

A bit is the smallest unit of measurement in computer data. It represents a single binary digit of either 0 or 1. Bytes consist of multiple bits grouped together, typically 8 bits to a byte. Entities and characters are broader terms that can encompass multiple bits or bytes.

Question 6

A collection of fields all related to a single object, activity, or individual is a(n) _____.
A)record
B)file
C) attribute
D) character

Accepted Answer

A record is a collection of related fields that describe a single object, activity, or individual. Therefore, choice A is the best answer. Choice B (file) refers to a collection of records, choice C (attribute) refers to a specific characteristic of a field or record, and choice D (character) refers to a single letter or symbol in a field.

Question 7

Suppose a new tech startup wants to define the data model. They would then ____.
A)collect and cleanse the data
B)define user access privileges
C) create the entity-relationship model
D) acquire a new database management system

Accepted Answer

Defining the data model involves creating the entity-relationship model that illustrates the relationships between various entities in the database. Collecting and cleansing data is a separate step, while defining user access privileges and acquiring a new database management system may come later in the process.

Question 8

______ use basic graphical symbols to show an organization of and relationships between data.

Accepted Answer

The answer of ______ use basic graphical symbols to show...

Question 9

mySQL is a popular ____________.

Accepted Answer

The answer of mySQL is a popular ____________....

Question 10

At Coast-to-Coast Moving and Van Lines, Ryan is responsible for managing the flow of the company's data, from initial acquisition of new data to deletion of old, outdated data. Ryan is involved in ___________.
A)data stewardship
B)data lifecycle management
C) database administration
D) data management

Accepted Answer

Ryan's responsibility involves managing the entire lifecycle of the company's data, from acquisition to deletion. This falls under the category of data lifecycle management.

Question 11

In the relational database model, each row of a table represents a(n) _____.

Accepted Answer

The answer of In the relational database model, each row...

Question 12

Data modeling done at the level of an entire enterprise is called _____.

Accepted Answer

The answer of Data modeling done at the level of...

Question 13

_____ is an approach that starts by investigating the general data and information needs of an organization at the strategic level and then examines more specific data and information needs for the functional areas and departments within the organization.
A)Data selecting
B)Enterprise data modeling
C) Data cleansing
D) Social graph analysis
​

Accepted Answer

This description matches the approach of enterprise data modeling, which involves analyzing the data needs of an entire organization and then breaking them down into functional areas and departments. Data selecting involves choosing specific datasets for analysis, data cleansing involves preparing data for analysis by removing errors or inconsistencies, and social graph analysis is a technique for studying relationships between individuals or entities in a network.

Question 14

Haley's employer has asked her to review tens of thousands of social media posts about their company's products and compile this data into a database. In terms of the characteristics of big data, Haley is dealing with ________.
A)​volume
B)​variety
C) ​velocity
D) ​veracity

Accepted Answer

The answer of Haley's employer has asked her to review...

Question 15

_____ is a method of dealing with a situation in which two or more users or applications need to access the same record at the same time.

Accepted Answer

The answer of _____ is a method of dealing with...

Question 16

The action of including only some columns for output while retrieving data is known as ____.
A)selecting
B)joining
C) projecting
D) linking

Accepted Answer

The action of including only some columns for output while retrieving data is known as projecting. The SELECT statement in SQL is used for projecting in which we can specify the specific columns we want to retrieve from the database.

Question 17

Together, bits, characters, fields, records, files, and databases form the ______.

Accepted Answer

The answer of Together, bits, characters, fields, records, files, and...

Question 18

Each attribute in a relational database model can be constrained to a range of allowable values called a _____.
A)bandwidth
B)scope
C) slot
D) domain

Accepted Answer

In a relational database model, each attribute can be constrained to a range of allowable values called a domain. The domain specifies the data type and any additional constraints on the data, such as minimum and maximum values, allowable characters, or allowed input formats.

Question 19

The position of a _____ is a non-technical position responsible for defining and implementing consistent principles for setting data standards and data definitions that apply across all the databases in an organization.
A)data analyst
B)data administrator
C) database administrator
D) data owner

Accepted Answer

The position of a data administrator is responsible for defining and implementing consistent principles for setting data standards and data definitions that apply across all the databases in an organization. A data analyst typically analyzes data to provide insights or inform business decisions, a database administrator is responsible for managing and maintaining specific databases, and a data owner is typically a business unit or individual responsible for the accuracy and integrity of specific data sets.

Question 20

Which of the following statements is true of a database?
A)It is accessed primarily for use by an organization's database administrator and data administrator.
B)It provides an essential foundation for an organization's knowledge management and artificial intelligence systems.
C) It is a collection of unstructured data.
D) It helps companies analyze information to open new market opportunities.

Accepted Answer

A database is a structured collection of data that allows organizations to store, manage, and retrieve information efficiently. One of the primary functions of a database is to help companies analyze information to identify trends and opportunities for growth in their markets. Additionally, databases can be used by a variety of stakeholders across an organization and are not solely accessed by database and data administrators. While databases can support knowledge management and artificial intelligence systems, they provide structured data rather than unstructured data.

Quiz 3: Database Systems and Big Data

To ensure reliability and integrity, SQL databases conform to four specific properties. Which of the following is NOT one of those four properties?

A database is a collection of integrated and related _____.

Kyle works for National Sporting Goods, where he manages critical data elements, such as identifying and acquiring new data sources, creating consistent reference data, and analyzing data for quality. Kyle is a _______.

A ______ is a collection of instructions and commands used to define and describe data and relationships in a specific database.

The smallest piece of data used by a computer is a(n) _____.

A collection of fields all related to a single object, activity, or individual is a(n) _____.

Suppose a new tech startup wants to define the data model. They would then ____.

______ use basic graphical symbols to show an organization of and relationships between data.

mySQL is a popular ____________.

At Coast-to-Coast Moving and Van Lines, Ryan is responsible for managing the flow of the company's data, from initial acquisition of new data to deletion of old, outdated data. Ryan is involved in ___________.

In the relational database model, each row of a table represents a(n) _____.

Data modeling done at the level of an entire enterprise is called _____.

_____ is an approach that starts by investigating the general data and information needs of an organization at the strategic level and then examines more specific data and information needs for the functional areas and departments within the organization.

Haley's employer has asked her to review tens of thousands of social media posts about their company's products and compile this data into a database. In terms of the characteristics of big data, Haley is dealing with ________.

_____ is a method of dealing with a situation in which two or more users or applications need to access the same record at the same time.

The action of including only some columns for output while retrieving data is known as ____.

Together, bits, characters, fields, records, files, and databases form the ______.

Each attribute in a relational database model can be constrained to a range of allowable values called a _____.

The position of a _____ is a non-technical position responsible for defining and implementing consistent principles for setting data standards and data definitions that apply across all the databases in an organization.

Which of the following statements is true of a database?