Docsity
Docsity

Prepare for your exams
Prepare for your exams

Study with the several resources on Docsity


Earn points to download
Earn points to download

Earn points by helping other students or get them with a premium plan


Guidelines and tips
Guidelines and tips

ITCS 3160 Final Exam Newest 2025. Questions & Correct Verified Answers. Graded A, Exams of Database Management Systems (DBMS)

ITCS 3160 Final Exam Newest 2025. Questions & Correct Verified Answers. Graded A

Typology: Exams

2024/2025

Available from 07/05/2025

zaza-maica
zaza-maica 🇬🇧

2.2

(5)

3.3K documents

1 / 8

Toggle sidebar

This page cannot be seen from the preview

Don't miss anything!

bg1
1
ITCS 3160 Final Exam Newest 2025.
Questions & Correct Verified Answers.
Graded A
________ facilitates the ability of applications to query relational data along
with associated structured data. – ANS XPath
(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. – ANS True
(T/F) A separate data warehouse causes more contention for resources in
an organization – ANS False
(T/F) Data federation consolidates all data into one database. – ANS False
(T/F) Exclusive locks allow other transactions to read but not update a
record or other resource - ANSFalse
(T/F) Field-level locks are used quite often - ANSFalse
(T/F) Geological logic is the application logic component responsible for
data storage and retrieval. - ANSFalse
(T/F) In some three-tier architectures, most application code is stored on
the application server. - ANSTrue
pf3
pf4
pf5
pf8

Partial preview of the text

Download ITCS 3160 Final Exam Newest 2025. Questions & Correct Verified Answers. Graded A and more Exams Database Management Systems (DBMS) in PDF only on Docsity!

ITCS 3160 Final Exam Newest 2025.

Questions & Correct Verified Answers.

Graded A

________ facilitates the ability of applications to query relational data along with associated structured data. – ANS XPath (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. – ANS True (T/F) A separate data warehouse causes more contention for resources in an organization – ANS False (T/F) Data federation consolidates all data into one database. – ANS False (T/F) Exclusive locks allow other transactions to read but not update a record or other resource - ANSFalse (T/F) Field-level locks are used quite often - ANSFalse (T/F) Geological logic is the application logic component responsible for data storage and retrieval. - ANSFalse (T/F) In some three-tier architectures, most application code is stored on the application server. - ANSTrue

(T/F) Independent data marts do not generally lead to redundant data and efforts. - ANSFalse (T/F) Informational systems are designed to support decision making based on historical point-in-time and prediction data. - ANSTrue (T/F) Lack of secure standards and lack of user acceptance are the major issues that must be resolved with Web services. - ANSFalse (T/F) MapReduce is an algorithm for massive parallel processing utilized by Hadoop. - ANSTrue (T/F) NoSQL focuses on avoidance of replication and minimizing storage space. - ANSFalse (T/F) NoSQL stands for "Not Only SQL" - ANSTrue (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. - ANSTrue (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. - ANSTrue

(T/F) Versioning takes the pessimistic approach to locking. - ANSFalse (T/F) When developing an application, one must decide where it will be placed when it is developed. - ANSFalse (T/F) Word processing documents are commonly stored in a 'document store' NoSQL database model. - ANSFalse A ________ is a procedure for acquiring the necessary locks for a transaction where all necessary locks are acquired before any are released. - ANSTwo-Phase lock A ________ prevents another transaction from reading and therefore updating a record until it is unlocked. - ANSExclusive lock A client PC that is responsible for processing logic, extensive application and business rules logic as well as many DBMS functions is called a: - ANSFat Client A computer that provides database storage and access in a client/server environment is called a: - ANSDatabase Server A data mart is a: - ANSData warehouse that is limited in scope A device to measure or detect fingerprints or signatures is called a __________ device. - ANSBiometric Device

A PC configured to handle user interface with little or no logical storage is called a: - ANSThin Client A star schema contains both fact and _______ tables. - ANSDimension A trigger can be used as a security measure in which of the following ways? - ANSTo cause special handling procedures to be executed. A web server: - ANSProcesses client requests and returns HTML pages to the client An audit trail of database changes is kept by a: - ANSJournalizing facility An open-source DBMS is: - ANSA free source RBMS that provides the functionality of an SQL-compliant DBMS Data quality is important for all of the following reasons EXCEPT: - ANSIt provides a stream of profit Data quality problems can cascade when: - ANSData are copied from legacy systems Data quality ROI stands for: - ANSRisk of Incarceration Data that are accurate, consistent, and available in a timely fashion are considered: - ANSHigh-Quality

The oldest form of analytics is: - ANSDescriptive Analytics The role of a _________ emphasizes integration and coordination of metadata across many data sources. - ANSData warehouse administrator The use of a set of graphical tools that provides users with multidimensional views of their data is called: - ANSon-line analytical processing (OLAP) TQM stands for: - ANSTotal Quality Management When we consider data in the data warehouse to be time-variant, we mean: - ANSData in the warehouse contain a time dimension so that they may be used to study trends and changes. Which of the following advances in information systems contributed to the emergence of data warehousing? - ANSAdvances in middleware products that enables enterprise database connectivity across heterogenous platforms. Which of the following data-mining techniques searches for patterns and correlations in large data sets? - ANSRule Discovery Which of the following functions develop integrity controls - ANSDatabase design

Which of the following functions model business rules. - ANSDatabase analytics Which of the following is an advantage of stored procedures? - ANSPerformance improves for compiles SQL statements. Which of the following is NOT a common distribution logic for two-tiered server environments? Distributed Tall Client Thin Client Fat Client - ANSTall Client Which of the following is true about 3-tier architectures? More technological flexibility Requires a Mac Less scalable than two-tier Increased risk - ANSMore Technological flexibility Which of the following organizational trends does not encourage the need for data warehousing. - ANSDownsizing