Question 1

Redundancy makes changing data more cumbersome and time-consuming.

Accepted Answer

A) True 
 B)False

Question 2

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

Accepted Answer

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

Question 3

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

Accepted Answer

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

Question 4

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

Accepted Answer

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

Question 5

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

Accepted Answer

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

Question 6

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

Accepted Answer

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

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

Accepted Answer

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

Question 8

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

Accepted Answer

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

Question 9

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

Accepted Answer

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

Question 10

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

Accepted Answer

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

Redundancy makes changing data more cumbersome and time-consuming.

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

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

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

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

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

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

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

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

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

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

Redundancy makes changing data more cumbersome and time-consuming.

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

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

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

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

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

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

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

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

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

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