FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 11: Behind the Scenes: Databases and Information Systems

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 21

Multiple Choice

Review LaterAdd Note

Review Later

To ensure that there are no duplicate records in a database table, you need to establish a ________.

A) query
B) primary key
C) relationship
D) foreign key

Correct Answer

verified

Show Answer

Question 22

Multiple Choice

Review LaterAdd Note

Review Later

________ is used to ensure that data is organized most efficiently in a database.

A) Consistency checking
B) Validation
C) Normalization
D) Range checking

Correct Answer

verified

Show Answer

Question 23

True/False

Review LaterAdd Note

The acronym BLOB stands for Bidirectional Large Objects.

Most databases can import electronic data from other software applications.

To establish a relationship between two tables, the primary key in one table is associated with the ________ in the other table.

Big data analytics is usually associated with ________ services.

A(n) ________ check ensures that all required fields in a database have data entered in them.

Data mining analyzes and investigates large amounts of data with the intention of discovering significant patterns or trends.

________ is the process by which great amounts of data are analyzed and investigated for significant patterns or trends within the data.

Which field property dictates whether the completeness check will trigger an error?

________ involves taking data from your database and putting it into an electronic file in a format that another external application or database can recognize.

________ logic enables the interjection of experiential learning into the equation by considering probabilities.

________ fields hold things such as pictures and video clips.

A ________ check would be used in a field to restrict the fines for speeding violations so that they fall between $50 and $250.

A(n) ________ provides a view of data fields to be filled in with appropriate labels to assist a user in entering data into the database.

Match each of the following terms to its definition:

The data in a data warehouse is ________, meaning it does not all pertain to one period in time.

________ systems include expert systems and natural language processing as part of a DSS.

Data ________ helps to ensure data integrity by maintaining information in only one place.

A group of related fields is called a ________.