Question 1

Traditional database applications programs are ________.

Accepted Answer

A)   browser-based and display dynamic content
B)   written in languages such as html5 and JavaScript
C)   entirely dependent on the database server for application logic
D)   thick applications that need to be installed on users' computersE) B) and D)
F) A) and B)

Question 2

________ are used by users to read, insert, modify, and delete data in a database.

Accepted Answer

A)   Reports
B)   Forms
C)   Queries
D)   DBMSE) B) and D)
F) B) and C)

Question 3

Locking must be used to coordinate the activities of users in order to prevent the lost-update problem.

Accepted Answer

A) True 
 B)False

Question 4

A spreadsheet can be used to store data if the structure of a list is simple.

Accepted Answer

A) True 
 B)False

Question 5

Explain the different types of database applications.

Accepted Answer

Database applications fall into two broa...

Question 6

What is the purpose of a database?

Accepted Answer

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

Question 7

Browser-based applications ________.

Accepted Answer

A)   need to be pre-installed 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) C) and D)
F) B) and D)

Question 8

________ is the process of converting a data model into tables, relationships, and data constraints.

Accepted Answer

A)   Database design
B)   Database querying
C)   Data mining
D)   Database aggregationE) A) and C)
F) All of the above

Question 9

One of the developmental tasks of a database administrator is to create a system to record and manage the resolution of problems.

Accepted Answer

A) True 
 B)False

Question 10

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

Question 11

Brad, a project manager, wants to build a database to integrate information about employees and tasks that they handle. Brad wants to track information such as task name, percentage completed, and employee name. These aspects that Brad wants to track are called ________.

Accepted Answer

A)   identifiers
B)   records
C)   primary keys
D)   entitiesE) B) and D)
F) None of the above

Question 12

Which of the following is true of N:M relationships?

Accepted Answer

A)   They are the same as N:N relationships.
B)   They represent minimum cardinalities in a relationship.
C)   They are also called one-to-many relationships.
D)   They can have more than one entity on each side of the relationship.E) All of the above
F) B) and D)

Question 13

Attributes are used to describe characteristics of entities.

Accepted Answer

A) True 
 B)False

Question 14

________ are the final judges as to what data the database should contain and how the records in that database should be related to one another.

Accepted Answer

A)   Administrators
B)   Developers
C)   Users
D)   DesignersE) B) and C)
F) A) and B)

Question 15

The general goal of normalization is to construct tables such that every table has a single topic or theme.

Accepted Answer

A) True 
 B)False

Question 16

Metadata are ________.

Accepted Answer

A)   code used for server-side processing
B)   error logs of databases
C)   data that describe data
D)   encrypted data transmissionsE) B) and C)
F) A) and B)

Question 17

Which of the following is a nonrelational data store developed by Amazon?

Accepted Answer

A)   Cassandra
B)   Dynamo
C)   SharePoint
D)   BigtableE) B) and C)
F) A) and C)

Question 18

Relational databases represent relationships using ________.

Accepted Answer

A)   foreign keys
B)   file systems
C)   metadata
D)   unique identifiersE) A) and B)
F) A) and C)

Question 19

Which of the following is an international standard language for processing a database?

Accepted Answer

A)   Cassandra
B)   DB2
C)   SQL
D)   MS AccessE) A) and D)
F) All of the above

Question 20

Which of the following database administration tasks is related to adaptation?

Accepted Answer

A)   monitoring backup procedures
B)   conducting training for users
C)   monitoring database performance
D)   managing configuration changes in systemsE) B) and D)
F) A) and D)

Exam 5: Database Processing

The general goal of normalization is to construct tables such that every table has a single topic or theme.

Correct AnswerverifiedShow Answer

________ are the final judges as to what data the database should contain and how the records in that database should be related to one another.

Correct AnswerverifiedShow Answer

One of the developmental tasks of a database administrator is to create a system to record and manage the resolution of problems.

Correct AnswerverifiedShow Answer

Which of the following is a nonrelational data store developed by Amazon?

Correct AnswerverifiedShow Answer

________ are used by users to read, insert, modify, and delete data in a database.

Correct AnswerverifiedShow Answer

Relational databases represent relationships using ________.

Correct AnswerverifiedShow Answer

A spreadsheet can be used to store data if the structure of a list is simple.

Correct AnswerverifiedShow Answer

Explain the different types of database applications.

Correct AnswerverifiedDatabase applications fall into two broa...View AnswerShow Answer

Which of the following database administration tasks is related to adaptation?

Correct AnswerverifiedShow Answer

Which of the following is an international standard language for processing a database?

Correct AnswerverifiedShow Answer

Metadata are ________.

Correct AnswerverifiedShow Answer

A data model is a ________.

Correct AnswerverifiedShow Answer

Brad, a project manager, wants to build a database to integrate information about employees and tasks that they handle. Brad wants to track information such as task name, percentage completed, and employee name. These aspects that Brad wants to track are called ________.

Correct AnswerverifiedShow Answer

Which of the following is true of N:M relationships?

Correct AnswerverifiedShow Answer

________ is the process of converting a data model into tables, relationships, and data constraints.

Correct AnswerverifiedShow Answer

Attributes are used to describe characteristics of entities.

Correct AnswerverifiedShow Answer

Browser-based applications ________.

Correct AnswerverifiedShow Answer

Traditional database applications programs are ________.

Correct AnswerverifiedShow Answer

What is the purpose of a database?

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

Locking must be used to coordinate the activities of users in order to prevent the lost-update problem.

Correct AnswerverifiedShow 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
Database applications fall into two broa...
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

Correct Answer
verified
The purpose of a database is to keep tra...
View Answer

Correct Answer
verified