Exam 11: Building Solutions

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?

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

Which of the following is a number(s) or character(s) that is appended to or inserted into a primary key field?

Which of the following kind of checks is a validity check performed on data, which ensures users enter only alphabetic data into a field?

In what kind of recovery does the DBMS use the log to reenter changes made to a database since the last save or backup?

Like a form, a report generator is used to maintain and retrieve data.

____________________ is a common data type that consists of an email address or a web address that links to a webpage on the Internet, for example.

A(n) ____________________ verifies that a required field contains data.

In a forward recovery, the DBMS uses the log to undo any changes made to a database during a certain period, such as an hour.

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

The data in a database is independent of programs that access that data.

Which of the following is a window on the screen that provides areas for entering or modifying data in a database?

Who was the inventor of the relational database model?

Which of the following statements is NOT true about multidimensional databases?

What is the term for the process of comparing data with a set of rules or values to find out if the data is correct?

Which of the following kind of checks is a validity check performed on data, which ensures users enter only numeric data into a field?

A user of a database such as that pictured in the accompanying figure refers to a file as what?

Which of the following is NOT considered a part of file maintenance?

Data integrity is important because computers and people use information to make decisions and take actions.

In the ASCII coding scheme, each byte represents a single ____________________, which can be a number, letter, blank space, punctuation mark, or other symbol.