ISTM EXAM 3 QUESTIONS AND ANSWERS
What is Data Visualization ? - Answers -Graphic display of the results of data mining,
analytics and BI in general, typically in real time.
What is a primary key ? - Answers -the attribute of coordinator of attributes that
uniquely identifies a specific row in a table
What is a Entity ? - Answers -Anything about which a organization wishes to store data
What is a Update Anomaly ? - Answers -When you have inconsistent data, because
you have to update the data in multiple places
What is a Insert Anomaly ? - Answers -Putting in a is difficult
What is a Delete Anomaly ? - Answers -Certain attributes are lost because of the
deletion of other attributes
Why do we want normalized databases ? - Answers -So our data is consistent
-Redundancy is minimalized and controlled
-So we don't have to mess with Anomalies
What is Referential Integrity ? - Answers -If you use something as a foreign key their
must be a associated record that has the foreign key as a private key
What is VOAL ? - Answers -Virtual Open Access Lab
Why use VOAL? - Answers -So you can use Access on your Mac, but you have to save
your Access files to your student drive
What is Access? - Answers -A Database Management System (DBMS)
Why does TAMU like Feral Cats ? - Answers -Because it keeps the rat population in
check
What is Database Software ? - Answers -Well-thought out collection of computer files
called tables that consist of rows and columns
What is File X? - Answers -Uploads file and secure it via an email mechanism
-encrypts files
-not a longterm storage solution (gets deleted in 3 days
What is GIGO? (abbreviation) - Answers -Garbage In, Garbage Out
,What is SQL? (abbreviation) - Answers -Structured Query Language
How do database designers construct databases ? - Answers -Using Entity
Relationship Diagrams (ER)
What is ERM? - Answers -a database modeling method to construct a theoretical and
conceptual representation of data to produce a schema
What is the most important collection of files on a database? - Answers -Tables
What is a SQL ? - Answers -A widely used standard computing language for databases
What is a email sign-in signature ? - Answers -A security measure that digitally verifies
that you know its from the correct person
Why did Prof P use FileX ? - Answers -To get our original scores for our grades
because she had a messed up answer key
What are the types of files that exist in a databases ? - Answers -1)Tables
2)Reports
3)Saved Query Files
4)Forms
How are databases created ? - Answers -By using software known as Database
Management Systems (DBMS)
What are Tables ? - Answers -Records (rows) separated by fields (columns) that can
be queried (questioned) to produce subsets of info.
Where does a database hold their Data ? - Answers -In tables
Business databases are always distributed on a computer network for multiple users -
Answers -True
What are reports ? - Answers -They display database info. on screen or on paper
What are forms ? - Answers -Overlay data tables and queries for more specific views of
data
What are saved query files? - Answers -files used to find specific populations (subsets)
within databases
What is a database schema? - Answers -A "map" of data tables and their relationships
to one another
, What is a ERM ? (Layman) - Answers -A picture of a database's tables and how they
relate to each other
What is the equivalent to fields ? - Answers -attributes
What is a One to Many relationship ? - Answers -A type of cardinality that refers to the
relationship between 2 entities
What is SQL ? (according to the book) - Answers -A standard computer language for
relational databases as it allows a programmer to manipulate and query data
What are data validation rules ? - Answers -Rules that help ensure a data's integrity
What does a good DBMS do ? - Answers -avoid Data Redundancy
What is the most widely used database ? - Answers -Oracle
What is the Origin of a Relational Database Model ? - Answers --1970
-Edgar F. Codd
-Departed from this tradition by insisting that applications should search for data by
content, rather than by following links.
What does a Field Mask do ? - Answers -Restrict Data Input
How does SQL work ? - Answers -SELECT Title
FROM Book
WHERE Price > 100
ORDER By Title
What are some SQL statements ? - Answers -APPEND
DELETE
UPDATE
SELECT
What software did Abby's first suggest after Microsoft Word? - Answers -Microsoft
Excel
What database did Zach choose? - Answers -Microsoft Access
A column in a table is called what? - Answers -Field
Where does a database hold data? - Answers -Tables
What was Zach's database "filter?" - Answers -Complete or Incomplete
What does the acronym REO mean? - Answers -Real Estate Owned
What is Data Visualization ? - Answers -Graphic display of the results of data mining,
analytics and BI in general, typically in real time.
What is a primary key ? - Answers -the attribute of coordinator of attributes that
uniquely identifies a specific row in a table
What is a Entity ? - Answers -Anything about which a organization wishes to store data
What is a Update Anomaly ? - Answers -When you have inconsistent data, because
you have to update the data in multiple places
What is a Insert Anomaly ? - Answers -Putting in a is difficult
What is a Delete Anomaly ? - Answers -Certain attributes are lost because of the
deletion of other attributes
Why do we want normalized databases ? - Answers -So our data is consistent
-Redundancy is minimalized and controlled
-So we don't have to mess with Anomalies
What is Referential Integrity ? - Answers -If you use something as a foreign key their
must be a associated record that has the foreign key as a private key
What is VOAL ? - Answers -Virtual Open Access Lab
Why use VOAL? - Answers -So you can use Access on your Mac, but you have to save
your Access files to your student drive
What is Access? - Answers -A Database Management System (DBMS)
Why does TAMU like Feral Cats ? - Answers -Because it keeps the rat population in
check
What is Database Software ? - Answers -Well-thought out collection of computer files
called tables that consist of rows and columns
What is File X? - Answers -Uploads file and secure it via an email mechanism
-encrypts files
-not a longterm storage solution (gets deleted in 3 days
What is GIGO? (abbreviation) - Answers -Garbage In, Garbage Out
,What is SQL? (abbreviation) - Answers -Structured Query Language
How do database designers construct databases ? - Answers -Using Entity
Relationship Diagrams (ER)
What is ERM? - Answers -a database modeling method to construct a theoretical and
conceptual representation of data to produce a schema
What is the most important collection of files on a database? - Answers -Tables
What is a SQL ? - Answers -A widely used standard computing language for databases
What is a email sign-in signature ? - Answers -A security measure that digitally verifies
that you know its from the correct person
Why did Prof P use FileX ? - Answers -To get our original scores for our grades
because she had a messed up answer key
What are the types of files that exist in a databases ? - Answers -1)Tables
2)Reports
3)Saved Query Files
4)Forms
How are databases created ? - Answers -By using software known as Database
Management Systems (DBMS)
What are Tables ? - Answers -Records (rows) separated by fields (columns) that can
be queried (questioned) to produce subsets of info.
Where does a database hold their Data ? - Answers -In tables
Business databases are always distributed on a computer network for multiple users -
Answers -True
What are reports ? - Answers -They display database info. on screen or on paper
What are forms ? - Answers -Overlay data tables and queries for more specific views of
data
What are saved query files? - Answers -files used to find specific populations (subsets)
within databases
What is a database schema? - Answers -A "map" of data tables and their relationships
to one another
, What is a ERM ? (Layman) - Answers -A picture of a database's tables and how they
relate to each other
What is the equivalent to fields ? - Answers -attributes
What is a One to Many relationship ? - Answers -A type of cardinality that refers to the
relationship between 2 entities
What is SQL ? (according to the book) - Answers -A standard computer language for
relational databases as it allows a programmer to manipulate and query data
What are data validation rules ? - Answers -Rules that help ensure a data's integrity
What does a good DBMS do ? - Answers -avoid Data Redundancy
What is the most widely used database ? - Answers -Oracle
What is the Origin of a Relational Database Model ? - Answers --1970
-Edgar F. Codd
-Departed from this tradition by insisting that applications should search for data by
content, rather than by following links.
What does a Field Mask do ? - Answers -Restrict Data Input
How does SQL work ? - Answers -SELECT Title
FROM Book
WHERE Price > 100
ORDER By Title
What are some SQL statements ? - Answers -APPEND
DELETE
UPDATE
SELECT
What software did Abby's first suggest after Microsoft Word? - Answers -Microsoft
Excel
What database did Zach choose? - Answers -Microsoft Access
A column in a table is called what? - Answers -Field
Where does a database hold data? - Answers -Tables
What was Zach's database "filter?" - Answers -Complete or Incomplete
What does the acronym REO mean? - Answers -Real Estate Owned
