ISTM 210 Exam 3 [2026/2027] | UPDATED ACTUAL
Exam Question and Answer | 100% Verified
Answers
• Database Management Systems (DBMS) -✓✓ -The software systems used to create
databases
-First DBMS - filing Cabinets. They organize information based on a set of rules.
• Referential Integrity Rule -✓✓ ensures that foreign keys must refer to an entity that
exists
• Oracle -✓✓ the worlds most widely used database
• entities -✓✓ specific things stored in databases
• fields -✓✓ attributes which make up the columns of the database - must contain a
name and data type
• short text -✓✓ used to store most data that won't be treated like a number (used in
calculations) such as text, telephone numbers, zip codes, etc.
• long text -✓✓ used to store larger amounts of text
• number -✓✓ used to store positive and negative numbers
• date/time -✓✓ used to store date or time information
• currency -✓✓ Number data type that places a currency symbol ($) in front of the
number.
• autonumber -✓✓ Access will automatically insert that value for the field when a new
record is added to a table.
• yes/no -✓✓ used to store data that has only two possible values such as yes or no,
true or false, and on or off.
• OLE Object -✓✓ used to store files created by other programs such as Word or Excel
documents, picture files, or sound files
• Hyperlink -✓✓ used to store links to websites or other folders/files on your computer
• Attachment -✓✓ used to store files for a database record
, • calculated -✓✓ used to create a field that is generated by a formula
• lookup wizard -✓✓ used to simplify data entry. A lookup-field will present the user a list
of items to choose from when entering a new record. These values can even come from
another table in the database
• field size -✓✓ this determines how large the field will be. For numbers this effects how
large the numbers stored in the field can be and the precision (number of digits to the
right of the decimal place that will be stored). The field size for a Text field determines
how many characters will be stored in that field for each record.
• input mask -✓✓ this is used to set rules for how the data will be entered for the field
• default value -✓✓ this is used to have Access automatically set a starting value for a
field when a new record is added to the table
• validation rule/validation text -✓✓ used to have Access check values when they are
entered into a table to make sure they fit a specific rule
• required -✓✓ this property is used make sure that a value is entered for a field when a
new record is added to a table
• foreign key -✓✓ attribute that is a primary key in another table
• update anomaly -✓✓ there can be problems updating the data if it's not set up
correctly
• insert anomaly -✓✓ database tables not set up well for the user to insert something
• delete anomaly -✓✓ delete records and lose all information about an entity
• normalized -✓✓ no anomalies
• normalization -✓✓ -Normalizing data means that your data is typically organized into
the fields and records of a relational database.
-Normalizing provides the standard data format required to analyze data.
• one-to-one relationship -✓✓ represents the situation where a record from one table
can only be associated with one record from the other table
• one-to-many relationship -✓✓ a single record from one table could be associated with
more than one record from the other table, but a record from the second table can only
be associated with one record from the first table (MOST COMMON)
Exam Question and Answer | 100% Verified
Answers
• Database Management Systems (DBMS) -✓✓ -The software systems used to create
databases
-First DBMS - filing Cabinets. They organize information based on a set of rules.
• Referential Integrity Rule -✓✓ ensures that foreign keys must refer to an entity that
exists
• Oracle -✓✓ the worlds most widely used database
• entities -✓✓ specific things stored in databases
• fields -✓✓ attributes which make up the columns of the database - must contain a
name and data type
• short text -✓✓ used to store most data that won't be treated like a number (used in
calculations) such as text, telephone numbers, zip codes, etc.
• long text -✓✓ used to store larger amounts of text
• number -✓✓ used to store positive and negative numbers
• date/time -✓✓ used to store date or time information
• currency -✓✓ Number data type that places a currency symbol ($) in front of the
number.
• autonumber -✓✓ Access will automatically insert that value for the field when a new
record is added to a table.
• yes/no -✓✓ used to store data that has only two possible values such as yes or no,
true or false, and on or off.
• OLE Object -✓✓ used to store files created by other programs such as Word or Excel
documents, picture files, or sound files
• Hyperlink -✓✓ used to store links to websites or other folders/files on your computer
• Attachment -✓✓ used to store files for a database record
, • calculated -✓✓ used to create a field that is generated by a formula
• lookup wizard -✓✓ used to simplify data entry. A lookup-field will present the user a list
of items to choose from when entering a new record. These values can even come from
another table in the database
• field size -✓✓ this determines how large the field will be. For numbers this effects how
large the numbers stored in the field can be and the precision (number of digits to the
right of the decimal place that will be stored). The field size for a Text field determines
how many characters will be stored in that field for each record.
• input mask -✓✓ this is used to set rules for how the data will be entered for the field
• default value -✓✓ this is used to have Access automatically set a starting value for a
field when a new record is added to the table
• validation rule/validation text -✓✓ used to have Access check values when they are
entered into a table to make sure they fit a specific rule
• required -✓✓ this property is used make sure that a value is entered for a field when a
new record is added to a table
• foreign key -✓✓ attribute that is a primary key in another table
• update anomaly -✓✓ there can be problems updating the data if it's not set up
correctly
• insert anomaly -✓✓ database tables not set up well for the user to insert something
• delete anomaly -✓✓ delete records and lose all information about an entity
• normalized -✓✓ no anomalies
• normalization -✓✓ -Normalizing data means that your data is typically organized into
the fields and records of a relational database.
-Normalizing provides the standard data format required to analyze data.
• one-to-one relationship -✓✓ represents the situation where a record from one table
can only be associated with one record from the other table
• one-to-many relationship -✓✓ a single record from one table could be associated with
more than one record from the other table, but a record from the second table can only
be associated with one record from the first table (MOST COMMON)
