Question 1

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) form 
A) spreadsheet 
B) macro 
C) report 
D) form

Question 2

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

Accepted Answer

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

Question 3

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) spreadsheet 
A) flat file 
B) attribute 
C) relational database 
D) spreadsheet

Question 4

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) security 
A) data independence 
B) redundancy 
C) data integrity 
D) security

Question 5

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

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 presentations 
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 7

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 8

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

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

Accepted Answer

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

Question 10

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. 
A) faster than average 
B) slower than average 
C) about average 
D) No growth is expected.

Question 11

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

An attribute is known as a row in most databases.

Accepted Answer

A) True 
 B)False

Question 13

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 14

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 field 
A) a form 
B) an orphan record 
C) a unique value 
D) a common field

Question 15

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) metadata 
A) entity-relationship (E-R) diagram 
B) algorithm 
C) encryption diagram 
D) metadata

Question 16

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

Accepted Answer

A) True 
 B)False

Question 17

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 file 
A) database 
B) entity 
C) code file 
D) flat file

Question 18

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 19

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

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

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

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

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

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

Which of the following is a drawback of flat files?

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

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

Which of the following statements is correct?

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

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

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

An attribute is known as a row in most databases.

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

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

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

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

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

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

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

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

Introduction to Database Management

The Relational Model: Introduction, Qbe, and Relational Algebra

The Relational Model: SQL

The Relational Model: Advanced Topics

Database Design: Normalization

Database Design: Relationships

Database Management Systems Processes and Services

Database Industry Careers

Filters

Exam 9: Database Industry Trends

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

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

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

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

Which of the following is a drawback of flat files?

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

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

Which of the following statements is correct?

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

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

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

An attribute is known as a row in most databases.

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

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

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

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

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

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

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

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

Introduction to Database Management

The Relational Model: Introduction, Qbe, and Relational Algebra

The Relational Model: SQL

The Relational Model: Advanced Topics

Database Design: Normalization

Database Design: Relationships

Database Management Systems Processes and Services

Database Industry Careers

Filters