ITCS 3160 Final Exam
An open-source DBMS is:
A free source RBMS that provides the functionality of an SQL-compliant DBMS
Which of the following advances in information systems contributed to the emergence of data warehousing?
Advances in middleware products that enables enterprise database connectivity across heterogenous platforms.
A device to measure or detect fingerprints or signatures is called a __________ device.
Biometric Device
Data quality problems can cascade when:
Data are copied from legacy systems
When we consider data in the data warehouse to be time-variant, we mean:
Data in the warehouse contain a time dimension so that they may be used to study trends and changes.
The role of a _________ emphasizes integration and coordination of metadata across many data sources.
Data warehouse administrator
A data mart is a:
Data warehouse that is limited in scope
A computer that provides database storage and access in a client/server environment is called a:
Database Server
Which of the following functions model business rules.
Database analytics
Which of the following functions develop integrity controls
Database design
The oldest form of analytics is:
Descriptive Analytics
A star schema contains both fact and _______ tables.
Dimension
Which of the following organizational trends does not encourage the need for data warehousing.
Downsizing
A ________ prevents another transaction from reading and therefore updating a record until it is unlocked.
Exclusive lock
The goal of data mining related to analyzing data for unexpected relationships is:
Exploratory
Datatype conflicts is an example of a _______ reason for deteriorated data quality.
External Data Source
(T/F) A separate data warehouse causes more contention for resources in an organization
False
(T/F) Data federation consolidates all data into one database.
False
(T/F) Exclusive locks allow other transactions to read but not update a record or other resource
False
(T/F) Field-level locks are used quite often
False
(T/F) Geological logic is the application logic component responsible for data storage and retrieval.
False
(T/F) Independent data marts do not generally lead to redundant data and efforts.
False
(T/F) Lack of secure standards and lack of user acceptance are the major issues that must be resolved with Web services.
False
(T/F) NoSQL focuses on avoidance of replication and minimizing storage space.
False
(T/F) Quality data does not have to be unique
False
(T/F) Query Language (SQL) is a set of methodologies, processes, architectures, and technologies that transform raw data into meaningful information.
False
(T/F) Retention to the amount of data is not purged periodically from tables.
False
(T/F) The granularity of locking is not a critical decision in database design
False
(T/F) Total Quality Management (TQM) focuses on deflect correction rather that defect prevention.
False
(T/F) Versioning takes the pessimistic approach to locking.
False
(T/F) When developing an application, one must decide where it will be placed when it is developed.
False
(T/F) Word processing documents are commonly stored in a 'document store' NoSQL database model.
False
A client PC that is responsible for processing logic, extensive application and business rules logic as well as many DBMS functions is called a:
Fat Client
NoSQL focuses on:
Flexibility
Data that are accurate, consistent, and available in a timely fashion are considered:
High-Quality
The analysis of summarized data to support decision making is called:
Informational processing
Data quality is important for all of the following reasons EXCEPT:
It provides a stream of profit
An audit trail of database changes is kept by a:
Journalizing facility
PHP is a popular API for MySQL because of all of the following EXCEPT:
Microsoft Integration
Which of the following is true about 3-tier architectures? More technological flexibility Requires a Mac Less scalable than two-tier Increased risk
More Technological flexibility
Which of the following is an advantage of stored procedures?
Performance improves for compiles SQL statements.
Data that are never physically altered once they are added to the store are called ________ data.
Periodic
A web server:
Processes client requests and returns HTML pages to the client
Sarbanes-Oxley Act was enacted to ensure the integrity of:
Public companies' financial statements
Data that are detailed, current, and intended to be the single, authoritative source of all decision support applications are called ________ data.
Reconciled
Data quality ROI stands for:
Risk of Incarceration
Which of the following data-mining techniques searches for patterns and correlations in large data sets?
Rule Discovery
One simple task of a data quality audit is to:
Statistically profile all files
Which of the following is NOT a common distribution logic for two-tiered server environments? Distributed Tall Client Thin Client Fat Client
Tall Client
A PC configured to handle user interface with little or no logical storage is called a:
Thin Client
A trigger can be used as a security measure in which of the following ways?
To cause special handling procedures to be executed.
TQM stands for:
Total Quality Management
(T/F) A data steward is a person assigned the responsibility of ensuring the organizational applications properly support the organization's enterprise goals for data quality.
True
(T/F) In some three-tier architectures, most application code is stored on the application server.
True
(T/F) Informational systems are designed to support decision making based on historical point-in-time and prediction data.
True
(T/F) MapReduce is an algorithm for massive parallel processing utilized by Hadoop.
True
(T/F) NoSQL stands for "Not Only SQL"
True
(T/F) Open Database Connectivity is an application interface that provides a common language for application programs to access and process SQL databases independent of the particular RDBMS that is accessed.
True
(T/F) Organizations adopt data mart architectures because it is easier to have separate, small data warehouses than to get all organizational parties to agree to one view of the organization in a central data warehouse.
True
(T/F) PHP is a platform for Web development
True
(T/F) The need for data warehousing in an organization is driven by its need for an integrated view of high-quality data.
True
(T/F) The role of database administration is typically a more hands-on, physical involvement with the management of databases.
True
(T/F) The three major types of analytics are: descriptive, predictive, and prescriptive
True
A ________ is a procedure for acquiring the necessary locks for a transaction where all necessary locks are acquired before any are released.
Two-Phase lock
________ facilitates the ability of applications to query relational data along with associated structured data.
XPath
The use of a set of graphical tools that provides users with multidimensional views of their data is called:
on-line analytical processing (OLAP)