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.

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?

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

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?

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?

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?

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