ISM4210 QUIZZES (Post Midterm)

All of the following are advantages to cloud-based computing EXCEPT:

ACID support for database as a service.

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

Application partitioning

A data management platform service is called:

Database-as-a-service

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

The database driver

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

Transaction

In packaged data models, all subtype/supertype relationships follow the ________ and ________ rules.

total specialization; overlap

VarChar2 would be appropriate for a user that wanted a text datatype for LastName that would only consume the required space.

true

A(n) ________ is often developed by identifying a form or report that a user needs on a regular basis.

user view

In SQL, a(n) ________ subquery is a type of subquery in which processing the inner query depends on data from the outer query.

Correlated

If the DBA wishes to describe all tables in the database, which data dictionary view should be accessed in Oracle?

DBA_TABLES

What does the following SQL statement do? DELETE FROM Customer_T WHERE state = 'HI';

Deletes all records from Customer_t where the state is equal to HI

A ________ is a temporary table used in the FROM clause of an SQL query.

Derived table

When a user creates a virtual table it is called a(n):

Dynamic view

The record log is a record of the essential data for each transaction that has been processed against the database.

F

Specifications for transactions do not need to be reviewed quickly.

FALSE

Three-factor authentication is most often implemented with a credit card.

FALSE - Smart card*

A data stewardship program does not help to involve the organization in data quality.

False

Completeness means that all data that must have a value does not have a value

False

Data which arrive via XML and B2B channels is always guaranteed to be accurate. Group of answer choices

False

Master data management is the disciplines, technologies, and methods to ensure the currency, meaning, and quality of data within one subject area.

False

The transaction log contains before and after images of records that have been modified.

False

Which of the following questions is answered by the SQL statement? SELECT COUNT (Product_Description) FROM Product_T;

How many products have product descriptions in the Product Table?

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

JavaScript Object Notation (JSON).

A student can attend five classes, each with a different professor. Each professor has 30 students. The relationship of students to professors is a ________ relationship.

Many-to-many

The number of entity types that participate in a Unary relationship is:

One

All of the following are well-accepted characteristics of transactions EXCEPT:

Persistence

In the ________ approach, one consolidated record is maintained, and all applications draw on that one actual "golden" record.

Persistent

A cloud computing approach in which the service consists of infrastructure resources and additional tools that enable application and solution data management solution developers to reach a high level of productivity is called:

Platform-as-a-service.

All of the following are key components of a web application EXCEPT:All of the following are key components of a web application EXCEPT:

Processing logic server

Which of the following violates the atomic property of relations?

Sam Hinz

Which of the following is NOT a common distribution logic for two-tiered server environments?

Tall client

A trigger can be used as a security measure in which of the following ways?

To cause special handling procedures to be executed

Specifying database access policies is done during the database implementation phase.

True

In the figure below, which attribute is derived?

[Years_Employed]

The following statement is an example of: CREATE TABLE Customer_t ( CustNmbr number(11,0), CreditLimit number(6,2), CustStart date, CustEnd date, PERIOD for Custperiod(CustStart,CustEnd));

an application time period table. Incorrect answers: a materialized view. a system-versioned table. a dynamic view.

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

define physical storage

Getting poor data from a supplier is a(n) ________ reason for deteriorated data quality

external data source

When all multivalued attributes have been removed from a relation, it is said to be in:

first normal form.

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

heap file organization.

A join in which rows that do not have matching values in common columns are still included in the result table is called a(n):

outer join

Sarbanes-Oxley Act was enacted to ensure the integrity of:

public companies' financial statements.

A departmental multi-tiered client/server database is stored on a central device called a:

server

All of the following are disadvantages to cloud-based computing EXCEPT: a) the visibility of costs of data management is better. b) the promise of elasticity is not fulfilled because the model will not adapt to changing requirements. c) live migration from one environment to another is a challenge. d) DBaaS is still struggling to provide ACID properties of databases.

the visibility of costs of data management is better.

Subtypes should be used when:

there are attributes that apply to some but not all instances of an entity type.