Exam 11: Building Solutions

List the four tests that systems analysts and users develop.

One application that uses multidimensional databases is an object-oriented database.

In the database pictured in the accompanying figure, which of the following is a combination of one or more related characters or bytes and is the smallest unit of data a user accesses?

In which of the following databases is the physical location of the server on which it is stored is transparent and often unknown, to the user?

A data model defines how the operating system actually arranges the data on the disk.

Key fields link data together in a database.

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. The instructor tells you that this is a mailing database, and yet you can see at a glance that there are some records with no data in the city field. What kind of check should you run on this field?

Which recovery technique is more expensive, but provides recovery of damaged data in a matter of seconds?

For a computer to produce correct information, the data that is input into a database must have integrity.

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 an item that contains data, as well as the actions that read or process the data?

Which term does a user of a relational database use to refer to a file?

A(n) ____________________ is an environment that allows software developers to test their programs with fictitious data without adversely affecting other programs, information systems, or data.

The purpose of the ____________________ is to construct, or build, the new or modified system and then deliver it to the users.

What database term is used to describe a request for specific data from the database?

Which of the following does NOT improve with the database approach?

Which of the following privileges for data involve establishing who can enter new data, change existing data, delete unwanted data, and view data?

Whereas a relational database can store more than two dimensions, a multidimensional database is a two-dimensional table.

What is another term used for data dictionary?

What was Megan's Law designed to do?