pg. 1
ISTM 210 EXAM PREP LATEST 2024 -2025 TESTBANK
COMPLETE 450 ACTUAL EXAM QUESTIONS WITH
CORRECT DETAILED ANSWERS (VERIFIED ANSWERS)
GRADED A+
What is SQL? - Correct Answer - structure query language Most widely used for databases, just like creating a query
What is SQL used for? - Correct Answer - Retrieving, storing, manipulating data, inquiry data
what is the main purpose of a database management system? - Correct Answer - To create, read, update, and delete data while controlling access and security
Which of the following is a disadvantage of using Microsoft access? - Correct Answer - Can be overwhelming to a new user and not good for MacBooks
What is an advantage of using Microsoft access? - Correct Answer - Easy integration with other software tablet, friendly interface widely popular among businesses
What is the purpose of the backstage view in Microsoft Access? - Correct Answer - To create, open, save, print, enclosed database files
- / 4
pg. 2 In Microsoft access which view allows you to delete records from a table, think of all views and all objects - Correct Answer - Data sheet view
In the context of Microsoft access, which of the following are examples of database objects - Correct Answer - Tables, queries, forms, reports
What does a table in a database represent? - Correct Answer - A collection of records(rows) and fields(columns) representing an entity
Which of the following describes an entity in a database - Correct Answer - A person place thing or event about which information is stored
What consists of external hard drive? - Correct Answer - Thumb drive
-CON: If lose, the data is gone
-PRO: Saves data
When creating a database what are some things you need to think about? - Correct Answer - - Needs to be accurate (real-time) (save as .accdb) (.laccdb means locked)
- security & privacy
- what type of information will you collect? (First name, last name,
- keep details of when you sell stuff
- needs to be accurate
- updated in real time to keep track of supplies
addresses, cc info?)
What is DBMS? What will it allow you to do? - Correct Answer - -Database Management System 2 / 4
pg. 3
- Allows you to create different types of tables, reports, queries, & forms
- allows you to manipulate & control data
- helps prevent redundant info (cause businesses to lose money)
- placed on network (everyone uses)
What is a database? - Correct Answer - - collection of data for business use
- need to know business to know what info needs to be included in
- file cabinets & files
database
What do databases allow you to do? - Correct Answer - Enter, access info, and analyze data
Database maintains info about various types: - Correct Answer - -Objects: inventory
-events: transactions or sales take place
-people: customers, suppliers, employees
-places: location of purchase & sales
DBMS allows for many decisions and options when creating: - Correct
Answer - -add -modify -update -delete
While allowing the user to: - Correct Answer - -control access
- lock down security 3 / 4
pg. 4
- maintain data
- controls data
Microsoft Access Advantages (used by small businesses) - Correct Answer
- -security
-organization -tablet friendly -easy to install -import data from excel or other software -allows you to create validation rules -redundancy -more than one user that can access it at a time
Microsoft Access disadvantages - Correct Answer - -Mac can't use -multiple users can delete or change info -can be overwhelming for new users
- primary functions of a DBMS? - Correct Answer - • Database structure
- / 4
-create tables & within those fields you create relationships among different tables -easy to add new records and change field values -delete records -allows you to querie the data -has a built in report -allows you to create forms -protects data