Question 1

How are entities represented in a relational database?

Accepted Answer

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

Question 2

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

Accepted Answer

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

Question 3

Which type of rule prevents the creation of orphan records?

Accepted Answer

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

Question 4

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

Accepted Answer

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

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

Accepted Answer

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

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

Accepted Answer

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

Question 7

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

Accepted Answer

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

Question 8

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

Accepted Answer

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

Question 9

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

Accepted Answer

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

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

Accepted Answer

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

Question 11

Which of the following is a popular software stack?

Accepted Answer

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

Question 12

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

Accepted Answer

A) True 
 B)False

Question 13

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

Accepted Answer

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

Question 14

List nine advantages of a properly designed relational database.

Accepted Answer

Better information is provided.
Data and

Question 15

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

Accepted Answer

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

Question 16

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

Accepted Answer

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

Question 17

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

Accepted Answer

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

Question 18

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

Accepted Answer

Access is an appropriate choice as a DBM

Question 19

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

Accepted Answer

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

Question 20

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

Accepted Answer

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

How are entities represented in a relational database?

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

Which type of rule prevents the creation of orphan records?

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

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

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

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

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

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

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

Which of the following is a popular software stack?

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

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

List nine advantages of a properly designed relational database.

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

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

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

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

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

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

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

How are entities represented in a relational database?

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

Which type of rule prevents the creation of orphan records?

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

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

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

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

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

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

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

Which of the following is a popular software stack?

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

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

List nine advantages of a properly designed relational database.

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

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

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

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

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

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

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