Deck 3: Database Systems and Big Data

Question 1

Two sets of fields can have a common primary key.

Answer 1

False

Question 2

An attribute is a general class of people, places, or things for which data is collected, stored, and maintained.

Answer 2

False

Question 3

Carlos is working with an existing database, but he wants to eliminate some of the columns in the table to create a new, more streamlined database. He will use projection to create his new database.

Answer 3

True

Question 4

A field is typically a name, number, or combination of characters that describes an aspect of a business object.

Question 5

A database, a database management system, and the application programs that use the data, make up a database environment.

Question 6

Organizations can collect many types of data from a wide variety of sources, but typically they only collect structured data that fits neatly into traditional relational database management systems.

Question 7

Some of the key factors in database design are content, access, structure, archiving, and security.

Question 8

One of the primary advantages of a relational database is that it allows tables to be linked to reduce data redundancy and allow data to be organized more logically.

Question 9

A database administrator (DBA) must have a clear understanding of the fundamental business of an organization, be proficient in the use of selected database management systems, and stay abreast of emerging technologies and new design approaches.

Question 10

Today, most organizations use the traditional approach to data management, where multiple information systems share a pool of related data.

Question 11

The relational model describes data using a standard tabular format; all data elements are placed in three-dimensional tables called relations, which are the logical equivalent of files.

Question 12

In the context of the relational database model, projecting involves eliminating columns in a table.

Question 13

The database approach to managing data is superior to the file-based approach.

Question 14

In the context of the relational database model, selecting involves combining two or more tables.

Question 15

A database management system (DBMS) serves as an interface between an application program and a database.

Question 16

The relational database model is currently the most widely used.

Question 17

Data modeling usually involves setting a specific business goal and then analyzing the data and information needed to reach that goal.

Question 18

A collection of data fields that are all related to one object, activity, or individual is called a file.

Question 19

For each data item, a data dictionary usually contains information such as the name of the data item, the range of values that can be used, and the amount of storage needed for the item.

Question 20

Suppose a manager wishes to analyze historical trends in sales. He would use the online transaction processing (OLTP) system.

Question 21

You would use Query by Example, if _____.

A)you wish to use a visual approach to query building
B)you build a query from an example
C) you use a template for reports
D) wish teach SQL with examples

Question 22

Starting from monthly sales data, if you wish to get weekly sales data, use the ___ feature.

A)roll up
B)drill down
C) slice and dice
D) extract data

Question 23

Two of the major challenges business users face when using big data are finding the information they need to make decisions and knowing that the data they have is valid.

Question 24

A relational model splits the information up into many two dimensional data structures.

Question 25

For the ____ operation, it is required that the the two tables have a common attribute.

A)delete
B)select
C) project
D) join

Question 26

Suppose you wish to find what tables are in a database, what fields they have, and how they are related you would review the _____.

A)SQL commands
B)attributes
C) schema
D) sample data

Question 27

A database administrator (DBA) is an important nontechnical position responsible for defining and implementing consistent principles for a variety of data issues, including setting data standards and data definitions that apply across all the databases in an organization.

Question 28

Sometimes a database can contain "bad data," meaning incomplete, incorrect, inaccurate, or irrelevant records, which can be corrected or deleted through data cleansing.

Question 29

A(n) _____ is a field or set of fields in a record that uniquely identifies the record.

A)attribute
B)entity
C) primary key
D) data item

Question 30

A database must reflect the business processes of an organization.

Question 31

_____ is the term used to describe enormous and complex data collections that traditional data management software, hardware, and analysis processes are incapable of handling.

A)Data warehouse
B)Data mart
C) Big data
D) Knowledge base

Question 32

An enterprise data model is created only for documentation, but is otherwise inconsequential.

Question 33

After entering data into a relational database, users can make all of the following basic data manipulations except:

A)​projecting
B)​organizing
C) ​selecting
D) ​joining

Question 34

Unstructured data comes from sources such as word-processing documents and scientific research.

Question 35

In the _____ process, all of the data from various sources is converted into a single format suitable for processing.

A)extract
B)transform
C) load
D) consolidate

Question 36

If "color" is an attribute, then "green" is a data item.

Question 37

_____ is a special-purpose programming language for accessing and manipulating data stored in a relational database.

A)Query by Example (QBE)
B)Access
C) Structured Query Language (SQL)
D) Java

Question 38

A _____ is a subset of a data warehouse that is used by small- and medium-sized businesses and departments within large companies to support decision making.

A)data dictionary
B)data model
C) data mart
D) data mine

Question 39

With _____, the database is stored on a service provider's server and accessed by the client over a network, typically the Internet.

A)Internet access
B)Database as a Service
C) Software as a Service
D) Oracle

Question 40

DBMSs are used primarily for modeling data.

Question 41

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

Question 42

A database is a collection of integrated and related _____.

A)fields
B)attributes
C) records
D) files

Question 43

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

Question 44

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

Question 45

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

A)entity
B)byte
C) bit
D) character

Question 46

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

A)record
B)file
C) attribute
D) character

Question 47

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

Question 48

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

Question 49

mySQL is a popular ____________.

Question 50

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

Question 51

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

Question 52

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

Question 53

_____ 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
​

Question 54

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

Question 55

_____ 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.

Question 56

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

A)selecting
B)joining
C) projecting
D) linking

Question 57

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

Question 58

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

Question 59

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

Question 60

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.

Question 61

The ____ model database makes it easy to develop queries that involve joining two tables.

Question 62

In a relational database model, _____ involves combining two or more tables.

Question 63

The _____ model has become the most popular database model.

Question 64

_____ is the process of detecting and then correcting or deleting incomplete, incorrect, inaccurate, irrelevant records that reside in a database.

Question 65

If an organization is taking a "store everything" approach to data, it will save all the data in its raw and unaltered form in a _____.

Question 66

A _____ provides a means to store and retrieve data that is modeled using some means other than the simple two-dimensional tabular relations used in relational databases.

Question 67

Oracle, IBM DB2, Microsoft SQL Server, Microsoft Access, MySQL, and Sybas are databases based on the _____ model.

Question 68

The _____ is a specific language, provided with a database management system (DBMS) that allows users to access and modify the data, to make queries, and to generate reports.

Question 69

A(n) _____ is a database management system that stores the entire database in random access memory (RAM).

Question 70

Suppose we have a table that stores student data. In that table we have a field - Student ID - that uniquely identifies each student. This field is known as the ____.

Question 71

A major advantage of NoSQL databases is the ability to spread data over multiple servers so that each server contains only a subset of the total data, a characteristic that is known as _____

Question 72

Most of the data that an organization must deal with is _____ data, meaning that it is not organized in any predefined manner.

Question 73

A(n) _____ is a collection of instructions and commands used to define and describe data and relationships in a specific database.

Question 74

A(n) ______ is an individual responsible for defining and implementing consistent principles for a variety of data issues.

Question 75

A(n) _____ is a detailed description of all data used in a database.

Question 76

While building a data warehouse, you are converting dates to months. This second step in the ETL process is known as ______.

Question 77

In a relational database model, the range of allowable values for a data attribute is called its _____.

Question 78

In the context of a database management system (DBMS), a(n) _____ interacts with other programs or applications and only indirectly interacts with people or users.

Question 79

If you wish to develop expertise in database management, you must learn popular language known as ______.

Question 80

A(n) _____ is a field or set of fields that uniquely identify a record.