Question 1

With a(n) ____________________, only one location in the organization uses the new system - so that it can be tested.

Accepted Answer

The answer of With a(n) ____________________, only one location in...

Question 2

Which of the following kinds of backup are used by organizations such as hospitals, communications companies, and financial institutions?

Accepted Answer

A) dynamic 
B) interactive 
C) collaborative 
D) continuous

Question 3

A macro is a series of statements that instructs a program or app how to complete a task.

Accepted Answer

A) True 
 B)False

Question 4

Case 11-1
​
In your new role at your job, you have inherited a project that needs to be completed quickly. Your first task, you decide, is to identify the proper method to develop the software.
-The manager for the eastern division sales force is upset because she needs this software to track current sales. However, the project has not started. What type of software development should you use?

Accepted Answer

A)  rapid application development 
B)  quick software development 
C)  accessible development 
D)  verifiable development

Question 5

Which of the following is a huge database that stores and manages the data required to analyze historical and current transactions?

Accepted Answer

A) data distribution 
B) data marketing 
C) data warehouse 
D) data analysis

Question 6

A data mart defines how users view the organization of the data.

Accepted Answer

A) True 
 B)False

Question 7

Which of the following is a request for specific data from a database?

Accepted Answer

A) query 
B) index 
C) ask 
D) inquiry

Question 8

Which of the following statements is NOT true about object-oriented databases (OODBs)?

Accepted Answer

A) A voice mail system is an example of a groupware database. 
B) An object is an item that contains data, as well as the actions that read or process the data. 
C) An OODB stores unstructured data more efficiently than a relational database. 
D) OODBs can store more types of data and access it faster than relational databases.

Question 9

Case 11-1
​
In your new role at your job, you have inherited a project that needs to be completed quickly. Your first task, you decide, is to identify the proper method to develop the software.
-Once you have decided with the software development team the method you will use, you need to choose a type of programming language. What type of programming language will be best suited with your method?

Accepted Answer

A)  XML 
B)  object-oriented 
C)  mySql 
D)  HTML

Question 10

With the database approach, most data items are stored in multiple files, which greatly reduces duplicate data.

Accepted Answer

A) True 
 B)False

Question 11

You create a computer-aided design database that stores data including a list of components of an item being designed, the relationship among the components, and previous versions of the design drafts. Which data model did you use?

Accepted Answer

A) object-oriented 
B) object-relational 
C) relational 
D) multidimensional

Question 12

Which of the following is a database that stores data in tables that consist of rows and columns?

Accepted Answer

A) object-oriented 
B) tabular 
C) relational 
D) attribute-based

Question 13

Your database was damaged due to hardware failure. What can you use to restore it?

Accepted Answer

A) a backup 
B) imaging software 
C) restoration hardware 
D) a wizard

Question 14

Critical Thinking Questions
Case 11-2
In your database course, your instructor has given you a small database that has a lot of invalid data, issuing the challenge to you that you work to apply validation rules to the data and determine what checks need to be applied in order to restore integrity to the data.
-A quick scan of the data in the First Name field in the database yields the numbers 3 and 7 and an asterisk. What kind of check should you run on this field?

Accepted Answer

A)  completeness check 
B)  alphabetic check 
C)  consistency check 
D)  check digit

Question 15

____________________ unneeded records reduces the size of files, thereby freeing up storage space.

Accepted Answer

The answer of ____________________ unneeded records reduces the size of...

Question 16

Which of the following kinds of values is the one that a DBMS initially displays in a field?

Accepted Answer

A) query 
B) start 
C) initial 
D) default

Question 17

In a rollforward, the DBMS uses the log to undo any changes made to the database during a certain period.

Accepted Answer

A) True 
 B)False

Question 18

What is the smallest unit of data the computer can process?

Accepted Answer

A) log 
B) bit 
C) reg 
D) byte

Question 19

Which of the following is an item that contains data, as well as the actions that read or process the data?

Accepted Answer

A) object 
B) hyperlink 
C) action link 
D) event

Question 20

Which of the following consists of rules and standards that define how a database organizes data?

Accepted Answer

A) data standard 
B) data model 
C) rules-based integration 
D) object-relation

Exam 11: Building Solutions

With a(n) ____________________, only one location in the organization uses the new system - so that it can be tested.

Which of the following kinds of backup are used by organizations such as hospitals, communications companies, and financial institutions?

A macro is a series of statements that instructs a program or app how to complete a task.

Which of the following is a huge database that stores and manages the data required to analyze historical and current transactions?

A data mart defines how users view the organization of the data.

Which of the following is a request for specific data from a database?

Which of the following statements is NOT true about object-oriented databases (OODBs) ?

With the database approach, most data items are stored in multiple files, which greatly reduces duplicate data.

You create a computer-aided design database that stores data including a list of components of an item being designed, the relationship among the components, and previous versions of the design drafts. Which data model did you use?

Which of the following is a database that stores data in tables that consist of rows and columns?

Your database was damaged due to hardware failure. What can you use to restore it?

____________________ unneeded records reduces the size of files, thereby freeing up storage space.

Which of the following kinds of values is the one that a DBMS initially displays in a field?

In a rollforward, the DBMS uses the log to undo any changes made to the database during a certain period.

What is the smallest unit of data the computer can process?

Which of the following is an item that contains data, as well as the actions that read or process the data?

Which of the following consists of rules and standards that define how a database organizes data?