Basic
Designing A Database
Creating/Managing Tables
Complicated
100
Define Big Data
Large amounts of specific search criteria collected over time that cannot be processed with traditional database tools
100
What database component is used to define your information by data type
Field
100
What operation arranges database records in alphabetical order?
Sorting
100
If you were an analyst employed at a bank, which application would you utilize to inquire about the transactions of a single client in New Jersey within the bank's database
MySQL
200
What tool allows a user to collect, edit and question data
Database
200
Which database component can help enter data easily?
Form
200
what happens when delete a record
It is permanently deleted and cannot be retrieved
200
The relationship is created by joining the primary key and foreign key in two different tables
What is a relationship between two tables?
300
Advantage of using a database instead of a spreadsheet
Multiple people can use the database at the same time
300
What references a unique column in another table
Foreign Key
300
When you correct an error in a database, what operation are you preforming?
Updating a record
300
True or False:
Can data types include images in relational databases
True
400
Which language is used to develop and manage databases
SQL
400
What Access object summarizes information that can be easily read
Report
400
What three data types do you need to use to record your friends name, birthday, and age
Text, Date/Time, Number
400
What command helps you build a report in a database
Report Wizard
500
Which attributes pf your database define it as a "relational database"
Multiple tables with common fields that are joined to form relationships
500
When entering a info into a table, you enter, name, Street Address, City, State, Zip Code and Phone #
If you enter this info for one student, how many records have you created
One
500
Which field is sorted in numerical order?
ID
500
When you save a query, what are you saving?
The SQL code for the chosen fields, their source tables, and the conditions.