ISDS 351 Final Exam – comprehensive practice questions with answers and final
revision material
What is a database? Why are they necessary? - correct answer ✔✔Integrated Collection of
Logically Related Data
-Data is independent of Application Program and Storage Device
Character - correct answer ✔✔Any single letter, number, symbol, or punctuation mark. (bytes)
Field - correct answer ✔✔Primary key and foreign key
Record - correct answer ✔✔•Related Fields with Attributes and Length (rows)
Table - correct answer ✔✔Same as file
File - correct answer ✔✔Grouping of Records with Classification
Primary Key - correct answer ✔✔A field (or group of fields) that uniquely identifies a given
entity in a table
Foreign key - correct answer ✔✔A primary key of one table that appears as an attribute in
another table and acts to provide a logical relationship between the two tables
Referential Integrity - correct answer ✔✔A value cannot exist unless it exists in its parent table
(another entity)
Metadata - correct answer ✔✔Data that describes data, provides more complete description
,Components of a data base? - correct answer ✔✔Table, Relationships, Metadata
Data integrity - correct answer ✔✔
What is a NoSQL DBMS? - correct answer ✔✔NoSQL DBMS (Not Relational DBMS)
•Supports very high transaction rates
•Relatively simple data structures
•Replicated on many servers in the cloud
Examples
•Dynamo (Amazon)
•Bigtable (Google)
•Cassandra (Facebook, Uber)
Will NoSQL Replace Relational DBMS Products? - correct answer ✔✔No, they can coexist and
compliment each other
What is BI systems? - correct answer ✔✔Various applications, practices, and technologies to
support improved decision making
•Employed by organizations to make and act on predictions about future conditions
Most widely used BI software - correct answer ✔✔IBM, Oracle, Microsoft, SAP
Components of BI - correct answer ✔✔ETL, Data warehouse, tools
ETL - correct answer ✔✔Extract, Transform, Load
, Data warehouse - correct answer ✔✔stores large amounts of historical data in a form that
readily supports analysis and management decision making
Tools - correct answer ✔✔•Spreadsheets
-Perform operations on the data based on formulas created by the end user
-Create useful reports and graphs based on that data
-"What if" analysis
•Reporting and Querying Tools
-Present data in an easy to understand fashion
-Enable end users to make their own data requests and format the results without the need for
additional help from the IT organization
•Data mining
How do organizations use data warehouses and data marts to acquire data? - correct answer
✔✔
data mart - correct answer ✔✔Smaller version of a data warehouse
What is data mining? - correct answer ✔✔the process of analyzing data to extract information
not offered by the raw data alone
Data mining tool - correct answer ✔✔uses a variety of techniques to find patterns and
relationships in large volumes of information and infers rules that predict future behavior and
guide decision making
-Classification
-Estimation
-Affinity grouping
-Clustering
revision material
What is a database? Why are they necessary? - correct answer ✔✔Integrated Collection of
Logically Related Data
-Data is independent of Application Program and Storage Device
Character - correct answer ✔✔Any single letter, number, symbol, or punctuation mark. (bytes)
Field - correct answer ✔✔Primary key and foreign key
Record - correct answer ✔✔•Related Fields with Attributes and Length (rows)
Table - correct answer ✔✔Same as file
File - correct answer ✔✔Grouping of Records with Classification
Primary Key - correct answer ✔✔A field (or group of fields) that uniquely identifies a given
entity in a table
Foreign key - correct answer ✔✔A primary key of one table that appears as an attribute in
another table and acts to provide a logical relationship between the two tables
Referential Integrity - correct answer ✔✔A value cannot exist unless it exists in its parent table
(another entity)
Metadata - correct answer ✔✔Data that describes data, provides more complete description
,Components of a data base? - correct answer ✔✔Table, Relationships, Metadata
Data integrity - correct answer ✔✔
What is a NoSQL DBMS? - correct answer ✔✔NoSQL DBMS (Not Relational DBMS)
•Supports very high transaction rates
•Relatively simple data structures
•Replicated on many servers in the cloud
Examples
•Dynamo (Amazon)
•Bigtable (Google)
•Cassandra (Facebook, Uber)
Will NoSQL Replace Relational DBMS Products? - correct answer ✔✔No, they can coexist and
compliment each other
What is BI systems? - correct answer ✔✔Various applications, practices, and technologies to
support improved decision making
•Employed by organizations to make and act on predictions about future conditions
Most widely used BI software - correct answer ✔✔IBM, Oracle, Microsoft, SAP
Components of BI - correct answer ✔✔ETL, Data warehouse, tools
ETL - correct answer ✔✔Extract, Transform, Load
, Data warehouse - correct answer ✔✔stores large amounts of historical data in a form that
readily supports analysis and management decision making
Tools - correct answer ✔✔•Spreadsheets
-Perform operations on the data based on formulas created by the end user
-Create useful reports and graphs based on that data
-"What if" analysis
•Reporting and Querying Tools
-Present data in an easy to understand fashion
-Enable end users to make their own data requests and format the results without the need for
additional help from the IT organization
•Data mining
How do organizations use data warehouses and data marts to acquire data? - correct answer
✔✔
data mart - correct answer ✔✔Smaller version of a data warehouse
What is data mining? - correct answer ✔✔the process of analyzing data to extract information
not offered by the raw data alone
Data mining tool - correct answer ✔✔uses a variety of techniques to find patterns and
relationships in large volumes of information and infers rules that predict future behavior and
guide decision making
-Classification
-Estimation
-Affinity grouping
-Clustering
