Deck 9: Database Industry Trends

Question 1

Which term can be described as the duplication of data and storing data in multiple locations?

A)data independence
B)redundancy
C)data integrity
D)security

Answer 1

B

Question 2

Which of the following tasks is a data analyst likely to perform?

A)apply an algorithm to find sales trends
B)install software to work with a database
C)design a new database
D)maintain the company database

Answer 2

A

Question 3

An attribute is known as a row in most databases.

Answer 3

False

Question 4

Microsoft Access is well-suited to which of the following cases?

A)A few trusted users work with the database at the same time.
B)The database is very large, containing dozens of tables and thousands of records.
C)Many users work with the database in separate geographical locations.
D)The database has strict security requirements because it is available on the Internet.

Question 5

An employee's last name is an example of an attribute.

Question 6

Which of the following is a screen object used to maintain and view data from a database?

A)spreadsheet
B)macro
C)report
D)form

Question 7

Redundancy refers to the duplication of data, or the storing of the same data in more than one place.

Question 8

What is the term for a collection of data organized in a manner that allows access, retrieval, and use of the data?

A)database
B)entity
C)code file
D)flat file

Question 9

What do two tables use to link related records from each table?

A)a form
B)an orphan record
C)a unique value
D)a common field

Question 10

According to the Bureau of Labor Statistics, what is the job growth outlook for database administrators?

A)faster than average
B)slower than average
C)about average
D)No growth is expected.

Question 11

A database that enforces _____ prevents users from creating orphan records.

A)primary key creation
B)referential integrity
C)data redundancy
D)data security

Question 12

Which of the following is a drawback of flat files?

A)Several users can access the same information at the same time.
B)Flat files ensure that users enter data in a consistent format.
C)Data is organized to meet all integrity constraints.
D)Data partitioned into several separate files can be difficult to summarize.

Question 13

Redundancy makes changing data more cumbersome and time-consuming.

Question 14

A(n) _____ can store information about multiple types of entities and the relationships among the entities.

A)flat file
B)attribute
C)relational database
D)spreadsheet

Question 15

An entity is a person, place, event, item, or other transaction for which you want to store and process data.

Question 16

In the Sports Physical Therapy database, you determine the description of the therapy a patient is receiving by finding the TherapyCode for the patient in the Session table, and then _____.

A)looking up the TherapyCode in the Patient table
B)looking up the TherapyCode in the Therapies table
C)looking up the SessionNum in the Session table
D)looking up the TherapyCode in the Therapist table

Question 17

Which of the following is a problem that data redundancy causes?

A)removal of orphan records
B)increased data independence
C)increased data errors and inconsistencies
D)removal of primary key fields

Question 18

In an organization, who is usually responsible for improving databases to provide efficient and effective access to their information?

A)business owner
B)database administrator (DBA)
C)database supporter (DBS)
D)data-entry clerks

Question 19

Which of the following is a visual way to represent and analyze a database?

A)entity-relationship (E-R) diagram
B)algorithm
C)encryption diagram
D)metadata

Question 20

Which of the following is a reason to store business data in a database rather than a spreadsheet?

A)Spreadsheets have limited text-formatting features.
B)Spreadsheets cannot be backed up.
C)Spreadsheets have limited data sharing and security features.
D)Spreadsheets have strict rules about data consistency.

Question 21

Which of the following is a popular software stack?

A)SQL Server
B)Oracle
C)LAMP
D)DAMP

Question 22

In the Sports Physical Therapy database, which table determines which therapist provided a service to a patient?

A)Patients
B)Session
C)Therapist
D)Therapies

Question 23

In the Sports Physical Therapy database, how can you determine the number of sessions completed by therapist Steven Wilder?

A)In the Therapist table, count the number of values in the SessionNum column for Steven Wilder.
B)In the Session table, count the number of times Steven Wilder appears in the TherapistName column.
C)In the Therapies table, count the number of values in the SessionTherapist column for Steven Wilder.
D)In the Therapist table, find the TherapistID for Steven Wilder, and then count the number of times his TherapistID appears in the Session table.

Question 24

Which of the following statements is correct?

A)In a flat-file environment, data is partitioned into several disjointed systems, lists, and files.
B)User data cannot be combined and shared among authorized users.
C)Database users should each work on their own copy of the database.
D)Controlling redundancy is easier in a flat file than in a database.

Question 25

Which of the following are screen objects used to maintain, view, and print data from a database?

A)fields
B)forms
C)data files
D)entities

Question 26

In the Pitt Fitness database, which of the following attributes belongs in the Customers table?

A)ClassName
B)ReservationID
C)BirthDate
D)InstructorID

Question 27

Which of the following is a popular relational database management system?

A)Apache
B)SQL Server
C)Rails
D)PHP

Question 28

What type of software programs are Access, Oracle, DB2, MySQL, and SQL Server?

A)E-R diagrams
B)DBAs
C)data files
D)DBMSs

Question 29

In the Sports Physical Therapy database, which table stores the date of an interaction between a patient and a therapist?

A)Patient
B)Billings
C)Session
D)PatientBillings

Question 30

In the Sports Physical Therapy database, how can you determine which therapist provided the longest amount of time to complete a particular service?

A)In the Therapies table, find the highest value in the UnitOfTime column.
B)In the Session table, find the highest value in the LengthOfSession column.
C)In the Therapies table, find the highest value in the TherapyCode column.
D)In the Session table, find the highest value in the SessionNum column.

Question 31

In the Pitt Fitness database, which table relates classes and instructors?

A)Reservations
B)Customers
C)CustomerReservations
D)ClassInstructors

Question 32

How are entities represented in a relational database?

A)Each entity is stored as a row.
B)Each entity is stored as an attribute.
C)Each entity is stored as a table.
D)Each entity is stored as a column.

Question 33

In the Sports Physical Therapy database, which attribute uniquely identifies each therapy session?

A)TherapyCode
B)SessionNum
C)SessionType
D)PatientNum

Question 34

_________________________ describes the large volume of data produced by every digital process, system, sensor, mobile device, and even social media exchange.

A)Metadata
B)Database management system
C)Software stack
D)Big data

Question 35

Which of the following is a responsibility of a database administrator?

A)improving the efficiency of a database
B)creating projections of future sales
C)supervising an organization's external communications
D)coordinating marketing presentations

Question 36

During which phase does a database developer create the entities, attributes, and relationships between the tables of data?

A)data security
B)database integrity
C)database design
D)database selection

Question 37

Which of the following will be an entity in the JC Consulting database?

A)Client name
B)Estimate
C)Clients
D)Project description

Question 38

Which type of rule prevents the creation of orphan records?

A)redundancy constraint
B)integrity constraint
C)conflict requirement
D)security requirement

Question 39

In the Pitt Fitness database, which attribute uniquely identifies each class?

A)ClassName
B)ClassLocation
C)ClassType
D)ClassID

Question 40

In a large business, who mines a database for information, trends, and insights?

A)data analyst
B)database administrator
C)data entry manager
D)data security expert

Question 41

In the Pitt Fitness database, you can determine which instructor is assigned a particular class by looking in the ____________________ table.

A)ClassInstructors
B)Classes
C)Reservations
D)Instructors

Question 42

In the Pitt Fitness database, which of the following is an attribute in the Instructors entity?

A)InstructorRoom
B)InstructorDescription
C)InstructorCity
D)InstructorFee

Question 43

In the Pitt Fitness database, how can you determine the number of classes offered on Tuesday?

A)In the Classes table, count the occurrences of Tuesday in the Time column.
B)In the ClassInstructors table, count the occurrences of Tuesday in the DayOfWeek column.
C)In the Classes table, count the entries in the Tuesday column.
D)In the Classes table, count the occurrences of Tuesday in the Day column.

Question 44

Explain the key differences between the job description and responsibilities of a database administrator and a data analyst.

Question 45

Discuss why using a relational DBMS provides better information than data stored in multiple flat files.

Question 46

Describe the types of big data Sports Physical Therapy could collect to improve its services and financial performance.

Question 47

Explain when Access is an appropriate choice as a DBMS and when an enterprise-level DBMS system would be more appropriate.

Question 48

List nine advantages of a properly designed relational database.

Question 49

In the Pitt Fitness database, what can you learn by examining the ClassInstructors data?

A)Some classes use more than one instructor.
B)Each class has only one instructor.
C)Each instructor teaches only one class.
D)All the instructors live in Pittsburgh.

Question 50

A(n) _________________________ is a set of rules, calculations, and assumptions used to solve a problem.

A)attribute
B)algorithm
C)integrity constraint
D)form