Question 1

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

Accepted Answer

A)  faster than average
B)  slower than average
C)  about average
D)  No growth is expected.E) B) and C)
F) None of the above

Question 2

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

Accepted Answer

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.E) C) and D)
F) A) and D)

Question 3

Which of the following statements is correct?

Accepted Answer

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.E) B) and D)
F) B) and C)

Question 4

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

Accepted Answer

A)  database
B)  entity
C)  code file
D)  flat fileE) A) and B)
F) A) and C)

Question 5

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

Accepted Answer

A database administrator manages databas...

Question 6

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

Accepted Answer

A fundamental goal of a DBMS is to turn ...

Question 7

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

Accepted Answer

A)  TherapyCode
B)  SessionNum
C)  SessionType
D)  PatientNumE) None of the above
F) All of the above

Question 8

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

Accepted Answer

A) True 
 B)False

Question 9

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

Accepted Answer

A)  data independence
B)  redundancy
C)  data integrity
D)  securityE) C) and D)
F) A) and D)

Question 10

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

Accepted Answer

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.E) A) and C)
F) None of the above

Question 11

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

Accepted Answer

A)  entity-relationship (E-R)  diagram
B)  algorithm
C)  encryption diagram
D)  metadataE) C) and D)
F) A) and B)

Question 12

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

Accepted Answer

A) True 
 B)False

Question 13

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

Accepted Answer

A)  a form
B)  an orphan record
C)  a unique value
D)  a common fieldE) None of the above
F) A) and B)

Question 14

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

Accepted Answer

Sports Physical Therapy could collect bl...

Question 15

An attribute is known as a row in most databases.

Accepted Answer

A) True 
 B)False

Question 16

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

Accepted Answer

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

Question 17

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

Accepted Answer

A)  spreadsheet
B)  macro
C)  report
D)  formE) B) and D)
F) None of the above

Question 18

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

Accepted Answer

A)  flat file
B)  attribute
C)  relational database
D)  spreadsheetE) B) and D)
F) B) and C)

Question 19

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

Accepted Answer

A)  ClassName
B)  ReservationID
C)  BirthDate
D)  InstructorIDE) B) and C)
F) A) and C)

Question 20

Which of the following is a drawback of flat files?

Accepted Answer

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.E) None of the above
F) All of the above

Exam 9: Database Industry Trends

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

Correct AnswerverifiedSports Physical Therapy could collect bl...View AnswerShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Which of the following is a drawback of flat files?

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedA fundamental goal of a DBMS is to turn ...View AnswerShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedA database administrator manages databas...View AnswerShow Answer

An attribute is known as a row in most databases.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Which of the following statements is correct?

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Correct Answer
verified
Sports Physical Therapy could collect bl...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
A fundamental goal of a DBMS is to turn ...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
A database administrator manages databas...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified