CIS CHAPTER 6 HW

अब Quizwiz के साथ अपने होमवर्क और परीक्षाओं को एस करें!

​Microsoft's DBMS that includes​ built-in report generation and reporting is called​ ________.

Access

the structure of relational database​ tables

Each row is a unique record for one of the items in the table and each column is an attribute of the item.

An open source framework for parallel processing across inexpensive computers is called​ ________.

Hadoop

For handling unstructured and​ semi-structured data in vast​ quantities, as well as structured​ data, organizations are using​ _____________.

Hadoop

​________ is the most popular NoSQL DBMS.

Hadoop

What makes a Blockchain system possible and attractive to business​ firms?

Its encryption and authentication processes make it highly secure for storing many kinds of data.

The SQL​ ________ statement allows you to combine two different tables.

JOIN

An emerging​ non-relational database management system is called​ ________.

NoSQL

​________ use a more flexible data model and are designed for big data.

Non-relational database management systems

SQL stands for​ ________.

Structured Query Language

a database management system​ (DBMS) is a software program for​ creating, processing, and​ _____ a database.

administering

Another name for a database field is​ a(n) ________.

attribute

To describe datasets with volumes so huge that they are beyond the ability of typical DBMS to​ capture, store, and​analyze, the term​ __________ is used.

big data

A​ ________ is the smallest component in the computer system data hierarchy.

bit

A​ ________ is a component in the computer system data hierarchy that represents an ASCII character like a​ letter, a​ number, or another symbol.

byte

a spreadsheet is great to manage information about one thing​(e.g., items for​ sale), but a​ _____ is preferred to manage information about more than one thing​ (e.g., items for sale and suppliers of​ items).

data base

The process of detecting and correcting errors in a database is called​ ________.

data cleansing

​A(n) ________ is a collection of data organized to serve many applications efficiently.

database

The corporate function that is responsible for defining and organizing the content of the database as well as database maintenance is​ ________.

database administration

​A(n) ________ enables an organization to centrally manage and organize data.

database management system

A​ ________ is software that enables an organization to centralize​ data, manage them​ efficiently, and provide access to the stored data by application programs.

database management system (dbms)

DBMS have a​ data________ capability that is used to specify the structure of the content of the database.

definition

metadata

describe characteristics of each field

A​ ________ provides the link from one table to another​ table's primary key.

foreign key

The term data​ ________ is used to describe the policies and processes for managing the​ availability, usability,​integrity, and security of the data employed in an enterprise.

governance

Data is considered to be​ ________ when the same attribute has different values.

inconsistent

​A(n) ________ is an important resource for an organization to​ create, illustrating rules on how data is organized and who has access to what data.

information policy

​A(n) ________ specifies the rules of an organization for sharing and disseminating information.

information policy

a database is a collection of​ _____ records.

integrated

The formal process to remove data problems such as repeating groups is called​ ________.

normalization

Although​ "Big Data"​ doesn't refer to a specific amount of​ data, it usually does involve​ ________.

petabytes

Another term for a key field is a​ ________.

primary key

The field that uniquely identifies a row in a relational database table is called a​ ________.

primary key

The unique identifier for all data in a table is called the​ ________.

primary key

The coupling of files used to store information and the application program that updates and maintains those files is called​ ________.

program-data dependence

Another term for a database row is​ a(n) ________.

record

Microsoft SQL Server is a​ ________ for large mainframes and midrange computers

relational DBMS

Which of the following is a distributed database technology that enables firms and organizations to create and verify transactions on a​ peer-to-peer network nearly instantaneously without a central​ authority?

Blockchain

The​ sales, manufacturing, and inventory systems at a bicycle manufacturer use different codes to represent bicycle frame sizes. For​ example, in the sales​ system, a large bike frame is coded with​ "L", while the inventory system codes a large bike frame with​ "LG". This situation illustrates​ ________.

data inconsistency

A(n) ________ is a structured survey of the accuracy and level of completeness of data in an information system.

data quality audit

Data​ cleansing, also known as​ _________, consists of activities for detecting and correcting data in a database that are​ incorrect, incomplete, improperly​ formatted, or redundant.

data scrubbing

Data​ cleansing, working to identify and fix incorrect​ data, is also called​ ________.

data scrubbing

​A(n) ________ is a database that stores historic and current data for the use of decision makers in the organization.

data warehouse

​A(n) ________ database makes it possible to store information across millions of machines in hundreds of data centers around the​ globe, with special​ time-keeping tools to synchronize the data and ensure the data are always consistent.

distributed

A​ person, place, or thing which is stored in a database is called​ a(n) ________.

entity

​A(n) ________ is the most popular method to model a database.

entity-relationship (ER) Model

A record describes​ a(n) ________ which is a​ person, place,​ thing, or event on which we store and maintain information. Each characteristic or quality describing a particular​ ________ is called​ a(n) ________.

entity; entity; attribute

A grouping of characters into a word or group of words is called​ a(n) ________.

field

A​ ________ is a component in the computer system data hierarchy that includes content such as Student ID​ 100, Course IS​ 101, and Grade A.

field

A​ ________ is a component in the computer system data hierarchy that consists of multiple records of the same type.

file

In relational​ databases, the​ ________ operation creates a subset of records in the file that meet stated criteria.

select

The most popular type of database today for PCs as well as for larger computers and mainframes is​ ___________ database.

the relational

All of the following are types of information obtained from data mining EXCEPT​ ________.

web beacons

​________ is another way to facilitate big data analysis and remove bottlenecks normally found in a traditional database.

​In-memory computing


संबंधित स्टडी सेट्स

Sleep and Dreams - Chapter 5, Section 2 - Psych

View Set

class NCLEX questions & prep u: GU med surg

View Set

NCLEX EAQ module 7 nursing roles and attributes

View Set

Chapter 3: Health, Illness, and Disparities

View Set

Abnormal Psychology Chapter 16, Abnormal Psychology Chapter 9, Abnormal Psychology Chapter 15, Abnormal Psychology Chapter 14, Abnormal Psychology Chapter 12, Abnormal Psychology Chapter 6

View Set

Saunders Chapter 22 Risk Conditions Related to pregnancy

View Set

Bipolar disorder mental health exam 3

View Set

LEB 320F Final Exam Unit 7-9 Vocab Terms

View Set