Question 1

A logical representation of database data, called the data model, is constructed by developers after building a database.

Accepted Answer

A) True 
 B)False

Question 2

One of the functions of a DBMS is to provide tools to assist in the administration of a database.

Accepted Answer

A) True 
 B)False

Question 3

Explain the role of users in the database development process.

Accepted Answer

A database is a model of how the users v...

Question 4

Browser-based applications ________.

Accepted Answer

A)  are thick-client applications
B)  can display only static content
C)  support graphical queries
D)  process queries using C++E) B) and D)
F) A) and B)

Question 5

A data model is a ________.

Accepted Answer

A)  logical representation of database data
B)  repository of unprocessed data
C)  collection of isolated databases
D)  set of programs used to retrieve dataE) A) and B)
F) None of the above

Question 6

Which of the following data elements is placed higher than records in the database hierarchy?

Accepted Answer

A)  file
B)  field
C)  character
D)  byteE) A) and B)
F) A) and C)

Question 7

Which of the following is true of traditional database application programs?

Accepted Answer

A)  Application forms, reports, and queries are displayed and processed using a browser application.
B)  The application logic is contained in a program on the client-side computer.
C)  They are written in object-oriented languages such as C++ and VisualBasic.
D)  They are thin-client applications that need not be preinstalled on the users' computers.E) A) and C)
F) A) and B)

Question 8

What is the purpose of a database?

Accepted Answer

The purpose of a database is to keep tra...

Question 9

A data integrity problem will occur only if ________.

Accepted Answer

A)  a database has multiple administrators
B)  data are duplicated in a database
C)  the database is very complex
D)  there are complex relationships between entities in a databaseE) B) and C)
F) A) and B)

Question 10

The easiest time to change the database structure is after the data modeling stage.

Accepted Answer

A) True 
 B)False

Question 11

Ryan, a database administrator, is in the process of designing his company's database. Which of the following would Ryan have had to create before he began designing?

Accepted Answer

A)  data aggregator
B)  query model
C)  data model
D)  data applicationE) C) and D)
F) All of the above

Question 12

A(n) ________ is a request for data from a database.

Accepted Answer

A)  form
B)  report
C)  query
D)  applicationE) C) and D)
F) None of the above

Question 13

Browser applications are thin-client applications that need to be preinstalled on the users' computers.

Accepted Answer

A) True 
 B)False

Question 14

The modification or deletion of data in a database is an example of ________ operations of a database management system.

Accepted Answer

A)  statistical
B)  analytical
C)  administrative
D)  processingE) A) and B)
F) A) and C)

Question 15

Which of the following is true about the database development process?

Accepted Answer

A)  The database structure is easy to change during the data modeling stage.
B)  Changing a relationship from 1:N to N:M in an existing database is a complex and lengthy process.
C)  User review of the data model is avoided as it is not helpful in data modeling.
D)  Databases are easier to develop than spreadsheets.E) None of the above
F) A) and B)

Question 16

A group of similar rows or records is known as ________.

Accepted Answer

A)  a prototype
B)  a file
C)  a field
D)  an attributeE) A) and D)
F) All of the above

Question 17

Heidi, an accountant, completed three mandatory training sessions in the last quarter. She needs to update her training record in the company's database. Which of the following elements will help Heidi modify her data?

Accepted Answer

A)  reports
B)  forms
C)  queries
D)  operationsE) All of the above
F) B) and D)

Question 18

The forked lines on the lines representing relationship between two related entities are referred to as ________.

Accepted Answer

A)  identifiers
B)  foreign keys
C)  crow's feet
D)  entitiesE) A) and D)
F) All of the above

Question 19

Explain the functioning of browser applications.

Accepted Answer

Browser applications are thin-client app...

Question 20

Browser-based applications ________.

Accepted Answer

A)  need to be preinstalled on the users' computers
B)  run within a corporate network that is protected from the Internet
C)  eliminate the need to check for data consistency
D)  are more vulnerable to security threats than are traditional applicationsE) B) and D)
F) C) and D)

Exam 5: Database Processing

One of the functions of a DBMS is to provide tools to assist in the administration of a database.

Correct AnswerverifiedShow Answer

Ryan, a database administrator, is in the process of designing his company's database. Which of the following would Ryan have had to create before he began designing?

Correct AnswerverifiedShow Answer

Which of the following is true of traditional database application programs?

Correct AnswerverifiedShow Answer

Browser applications are thin-client applications that need to be preinstalled on the users' computers.

Correct AnswerverifiedShow Answer

Explain the role of users in the database development process.

Correct AnswerverifiedA database is a model of how the users v...View AnswerShow Answer

Which of the following data elements is placed higher than records in the database hierarchy?

Correct AnswerverifiedShow Answer

Browser-based applications ________.

Correct AnswerverifiedShow Answer

The modification or deletion of data in a database is an example of ________ operations of a database management system.

Correct AnswerverifiedShow Answer

A group of similar rows or records is known as ________.

Correct AnswerverifiedShow Answer

What is the purpose of a database?

Correct AnswerverifiedThe purpose of a database is to keep tra...View AnswerShow Answer

A data integrity problem will occur only if ________.

Correct AnswerverifiedShow Answer

Which of the following is true about the database development process?

Correct AnswerverifiedShow Answer

Browser-based applications ________.

Correct AnswerverifiedShow Answer

The easiest time to change the database structure is after the data modeling stage.

Correct AnswerverifiedShow Answer

A(n) ________ is a request for data from a database.

Correct AnswerverifiedShow Answer

The forked lines on the lines representing relationship between two related entities are referred to as ________.

Correct AnswerverifiedShow Answer

Heidi, an accountant, completed three mandatory training sessions in the last quarter. She needs to update her training record in the company's database. Which of the following elements will help Heidi modify her data?

Correct AnswerverifiedShow Answer

A data model is a ________.

Correct AnswerverifiedShow Answer

A logical representation of database data, called the data model, is constructed by developers after building a database.

Correct AnswerverifiedShow Answer

Explain the functioning of browser applications.

Correct AnswerverifiedBrowser applications are thin-client app...View AnswerShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
A database is a model of how the users v...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
The purpose of a database is to keep tra...
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
Browser applications are thin-client app...
View Answer