TAMU Curtsinger ISTM 210: Final
Exam Questions & Answers (Grade
A+)
When creating a database what are some things you need to think
about? -
correct answer ✅Data [all types of data need to be accurate],
needs to be imputed correctly, database needs to be kept up in real
time/up to date.
What is DBMS? -
correct answer ✅Database Management System
What will DBMS allow you to do? -
correct answer ✅Allows you to create different tables within the
database, manipulate and control the data, and helps prevent
redundant information.
What is a database? -
correct answer ✅A collection of data for business use and
personal use.
What does a database allow a user to do? -
correct answer ✅Input the information, analyze/inspect it, access
it.
,TAMU Curtsinger ISTM 210: Final
Exam Questions & Answers (Grade
A+)
A database maintains information about various types: -
correct answer ✅Objects [inventory]
Events
People [employees and customers]
Places [distributors, warehouses]
DBMS allows.... -
correct answer ✅add, modify, update, and delete
What are the Microsoft Access advantages? -
correct answer ✅It can be encrypted, password protected, cannot
be accessed without that password, tablet friendly, easy to install,
easy to use, you can import the data, create validation rules , helps
avoid redundancy, made for small-medium sized businesses,
convenient storage capacity.
What are the disadvantages of Microsoft Access? -
correct answer ✅Not made for MAC, multi-user (multiple users
can be in there), overwhelming.
,TAMU Curtsinger ISTM 210: Final
Exam Questions & Answers (Grade
A+)
What are the five primary functions of DBMS? -
correct answer ✅1. Having field names (id, last names, first
names) Creating a relationship between tables, creating those in a
table.
2. Easy to add new records, delete records, and change the view of
records.
3. Query allows you to extract the data/information.
4. Built in reports that you can create reports for displaying.
5. Protect the database by security and lock features [password
protection]
Backstage View -
correct answer ✅Allows you to create new databases, save, save
as.
*Navigation Pane
, TAMU Curtsinger ISTM 210: Final
Exam Questions & Answers (Grade
A+)
*most missed question -
correct answer ✅Stores all of your objects you create, you have to
save each one individually.
Tables are called -
correct answer ✅entities [person, place, thing, transaction, and
event]
Rows are called -
correct answer ✅data [separated by fields that are placed in
columns]
Field -
correct answer ✅characteristic of the table.
also called an attribute.
more than a column, it's a way to organize data.
A table is NOT -
correct answer ✅free design
Exam Questions & Answers (Grade
A+)
When creating a database what are some things you need to think
about? -
correct answer ✅Data [all types of data need to be accurate],
needs to be imputed correctly, database needs to be kept up in real
time/up to date.
What is DBMS? -
correct answer ✅Database Management System
What will DBMS allow you to do? -
correct answer ✅Allows you to create different tables within the
database, manipulate and control the data, and helps prevent
redundant information.
What is a database? -
correct answer ✅A collection of data for business use and
personal use.
What does a database allow a user to do? -
correct answer ✅Input the information, analyze/inspect it, access
it.
,TAMU Curtsinger ISTM 210: Final
Exam Questions & Answers (Grade
A+)
A database maintains information about various types: -
correct answer ✅Objects [inventory]
Events
People [employees and customers]
Places [distributors, warehouses]
DBMS allows.... -
correct answer ✅add, modify, update, and delete
What are the Microsoft Access advantages? -
correct answer ✅It can be encrypted, password protected, cannot
be accessed without that password, tablet friendly, easy to install,
easy to use, you can import the data, create validation rules , helps
avoid redundancy, made for small-medium sized businesses,
convenient storage capacity.
What are the disadvantages of Microsoft Access? -
correct answer ✅Not made for MAC, multi-user (multiple users
can be in there), overwhelming.
,TAMU Curtsinger ISTM 210: Final
Exam Questions & Answers (Grade
A+)
What are the five primary functions of DBMS? -
correct answer ✅1. Having field names (id, last names, first
names) Creating a relationship between tables, creating those in a
table.
2. Easy to add new records, delete records, and change the view of
records.
3. Query allows you to extract the data/information.
4. Built in reports that you can create reports for displaying.
5. Protect the database by security and lock features [password
protection]
Backstage View -
correct answer ✅Allows you to create new databases, save, save
as.
*Navigation Pane
, TAMU Curtsinger ISTM 210: Final
Exam Questions & Answers (Grade
A+)
*most missed question -
correct answer ✅Stores all of your objects you create, you have to
save each one individually.
Tables are called -
correct answer ✅entities [person, place, thing, transaction, and
event]
Rows are called -
correct answer ✅data [separated by fields that are placed in
columns]
Field -
correct answer ✅characteristic of the table.
also called an attribute.
more than a column, it's a way to organize data.
A table is NOT -
correct answer ✅free design
