Exam 11: Databases

What are the repercussions when a database security breach occurs in a legitimate organization?

A(n) ____ file uses a uniform format to store data for each person or thing in the file.

The United States has some of the strongest privacy regulations in the developed world.

In SQL, the CHANGE command changes data in a field.

Database ____ software allows any remote computer or network workstation to access data in a database.

Which of the following has the most limited versatility?

Which of the following is NOT true of XML?

Some relational database management systems (RDBMSs) allow the database server to receive queries in the form of XML commands.

The hyperlink data type stores data that can have one of two values.

ChoicePoint was duped into distributing personal information for more than ____ people.

A(n) ____________________ database stores data in a collection of related tables.

A report ____ contains the outline or general specifications for a report, including such elements as the report title, fields to include, fields to subtotal/total, and report format specifications.

Explain five things you can do to protect yourself from vulnerability to database security breaches.

Differentiate between a variable-length field and a fixed-length field.

A(n) ____________________ is a procedure that monitors and records user activity within a database.

Critical Thinking questions (Multiple Choice) If a single data management tool can be used to maintain many different files and databases, it must support data ____.

Case 3 There is the database designer and the people who enter the data. Sometimes this is the same person, but in Kate's large banking firm, the actual database entries are not made by the people who designed the database. A data entry operator might enter a telephone number as 555-555-7777, (555) 555-7777, or 1-555-555-7777. If multiple data entry operators enter telephone numbers in different reports, it becomes difficult to produce nicely formatted reports or locate a particular telephone number. To make sure that a field contains all unique values, Kate can set up the database using a ____ so that the database will search every existing record to make sure the new value does not duplicate an existing value in that field.