Final DB design

thin client.

A PC configured to handle user interfaces with limited local storage is called a(n):

NoSQL.

A class of database technology used to store textual and other unstructured data is called:

database server.

A computer that provides database storage and access in a client/server environment is called a(n):

data warehouse that is limited in scope.

A data mart is a(n):

JavaScript Object Notation (JSON).

A data-interchange format easily for humans to read and machines to parse and process is called:

data type.

A detailed coding scheme recognized by system software for representing organizational data is called a(n):

heap file organization.

A file organization where files are not stored in any particular order is considered a:

data replication.

A form of denormalization where the same data are purposely stored in multiple places in the database is called:

parallel query processing.

A method that speeds query processing by running a query at the same time against several partitions of a table using multiprocessors is called:

normalized relations.

A requirement to begin designing physical files and databases is:

transaction.

A sequence of steps that constitute a well-defined business activity is called a:

dimension

A star schema contains both fact and ________ tables.

pointer

A(n) ________ is a field of data used to locate a related field or record.

hashing algorithm

A(n) ________ is a routine that converts a primary key value into a record address.

descriptive analytics.

Allowing users to dive deeper into the view of data with online analytical processing (OLAP) is an important part of:

BLOB.

An appropriate datatype for adding a sound clip would be:

CHAR.

An appropriate datatype for one wanting a fixed-length type for last name would include:

snowflake schema.

An expanded version of a star schema in which all of the tables are fully normalized is called a(n):

range control.

An integrity control supported by a DBMS is:

predictive analytics.

Application of statistical and computational methods to predict data events is:

provides a virtual view of integrated data without actually creating one centralized database.

Data federation is a technique which:

transaction volumes.

Database access frequencies are estimated from:

prescriptive

Descriptive, predictive, and ________ are the three main types of analytics.

descriptions

Designing physical files requires ________ of where and when data are used in various ways.

horizontal partitioning.

Distributing the rows of data into separate files is called:

once a transaction is committed, no subsequent failure of the database can reverse the effect of the transaction.

Durability means that:

drill down.

Going from a summary view to progressively lower levels of detail is called data:

the database driver.

How the database results are read into memory is determined by:

any database constraints that must be true before the transaction must also be true after the transaction.

In order for a transaction to be consistent:

Hashed

In which type of file is multiple key retrieval not possible?

targeting market communications to specific customers.

One of the best known uses of data analytics in business is:

A data warehouse centralizes data that are scattered throughout disparate operational systems and makes them readily available for decision support applications.

Operational and informational systems are generally separated because of which of the following factors?

IIS.

The LAMP stack consists of all of the following EXCEPT:

informational processing.

The analysis of data or information to support decision making is called:

model-view-controller.

The architecture that most applications use that separates the business logic, presentation logic, and database logic is called:

application logic components

The client/server architectures that have evolved can be distinguished by the distribution of ________ across clients and servers.

exploratory.

The goal of data mining related to analyzing data for unexpected relationships is:

the recognition of the differences between transactional systems and informational systems.

The key discovery that triggered the development of data warehouses was:

grain.

The level of detail in a fact table determined by the intersection of all the components of the primary key, including all foreign keys and any other primary key elements, is called the:

descriptive analytics.

The oldest form of analytics is:

Data are immediately transformed and loaded into the warehouse.

The real-time data warehouse is characterized by which of the following?

field.

The smallest unit of application data recognized by system software is a:

default value.

The value a field will assume unless the user enters an explicit value for an instance of that field is called a:

prescriptive analytics.

When an organization must decide on optimization and simulation tools to make things happen it is using:

descriptive analytics.

When online analytical processing (OLAP) studies last year's sales, this represents:

data in the warehouse contain a time dimension so that they may be used to study trends and changes.

When we consider data in the data warehouse to be time variant, we mean:

Target marketing

Which of the following data-mining applications identifies customers for promotional activity?

Businesses need an integrated view of company information.

Which of the following factors drive the need for data warehousing?

Improve data integrity

Which of the following is an objective of selecting a data type?

define physical storage.

Which of the following is not a basic step to accessing a database from an application:

Hashed

Which type of file is easiest to update?

Sequential

Which type of file is most efficient with storage space?

tablespace.

Within Oracle, the named set of storage elements in which physical files for database tables may be stored is called a(n):

Word processing programs

________ are not used for querying and analyzing data stored in data warehouses.

Big data

________ is an ill-defined term applied to databases where size strains the ability of commonly used relational DBMSs to manage the data.

Personal privacy

________ is arguably the most common concern by individuals regarding big data analytics.

Application partitioning

________ is the process of assigning pieces of application code to clients or servers.

Middleware

________ is/are any of several classes of software that allow an application to interoperate with other software without requiring the user to understand all software involved.

An application server

provides the building blocks for creating dynamic web sites and web-based applications.