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.