Introduction to Computer Concepts Final CHAPTER 12 STUDY SET

True or False: Data privacy refers to protecting data against destruction and misuse—both intentional and accidental.

False

True or False:Normalization is an important process that occurs during database maintenance.

False

What is a characteristic of client-server database system with n-tier architecture?

The program code used to access the database can be separate from the database

True or False:A report can be designed to include all the records located in its associated table, or it can be designed to include just the results of a query.

True

True or False:Middleware for cloud database applications is commonly written as scripts.

True

True or False:The use of in-memory databases is growing because of the lower cost of RAM today and the need for faster processing.

True

What type of database can store and retrieve both XML data and relational data?

a hybrid XML/relational database

What tool does a database management system (DBMS) use to ensure that data entered into a table does not violate any of its assigned properties?

data dictionary

What term refers to the accuracy of data?

data integrity

The process of describing the properties of the data that will be stored in a database is called data _____.

definition

What organizational method arranges data on a storage medium that uses a hashing algorithm to specify the exact storage location?

direct organization

What type of database system divides data among multiple databases on multiple computers that are connected via a network?

distributed database system

In a database table, a record (also called a row) is a collection of related _____.

fields

One of the most significant disadvantages of the database system management (DBMS) approach is _____.

increased vulnerability

What term applies to a type of database that is optimized for data warehouse applications?

multidimensional

What type of relationship exists between two tables when one entity is related to only one other entity of a particular type?

one to one

Because a student's birth date is not necessarily unique, it is not an appropriate field to use as a _____.

primary key

The finished specifications for a table (the fields and the properties for those fields) are commonly referred to as the table _____.

structure

In a relational database, the primary key is the field in a table that is used to relate that table to other _____.

tables

Text, number, currency, and date/time are examples of data _____.

types