FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 11: Information and Data Management

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 31

Multiple Choice

Review LaterAdd Note

Review Later

COGNITIVE ASSESSMENT What is the process that large databases use to find patterns and relationships among data?

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

Correct Answer

verified

Show Answer

Question 32

Multiple Choice

Review LaterAdd Note

Review Later

Which of the following languages consists of simple, English-like statements that allow users to specify the data to display, print, or store?

A) report
B) query
C) specification
D) inquiry

Correct Answer

verified

Show Answer

Question 33

True/False

Review LaterAdd Note

In a relational database, the only data redundancy (duplication) exists in the common columns (fields) used for relationships.

Which kind of database stores data in dimensions?

COGNITIVE ASSESSMENT Which of the following statements is not true about relational databases?

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

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

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

COGNITIVE ASSESSMENT What is another name for a database analyst?

As shown in the accompanying figure, which of the following is a query language that allows users to manage, update, and retrieve data?

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?

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

Query by example uses a graphical user interface that assists users with retrieving data.

COGNITIVE ASSESSMENT You are creating a database for your computer club. Most of the students live in your town, Durham. How can you make Durham appear initially in the field to make data entry easier?

In a relational database, users can set up a relationship between tables at any time, but the tables must have a common row or field.

COGNITIVE ASSESSMENT 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?

The ____________________ identifies users' access privileges, defines the relationships among data, and decides on the proper placement of fields.

In a file processing system, each department or area in an organization shares files collectively.

COGNITIVE ASSESSMENT If you are running a check to ensure that a required field contains data, or the correct minimum number of characters, what kind of check are you running?

Which of the following is a collection of related records, as shown in the accompanying figure, stored on storage media such as a hard drive or optical disc?