ICT Digital Tools - Database
James has just inserted his grade for a quiz into a new database table. Which operation has James just performed?
Adding a record
Which of the following is an advantage of using a database to manage information?
Data is protected against accidental corruption.
You are preparing the monthly sales report. There are some outstanding sales representatives that brought in a majority of the sales revenue for the month. What functionality can you use to make these large numbers and the corresponding sales representatives' names stand out on your report?
Conditional Formatting.
Which of the following will reference a unique column in another table?
Foreign key
You have been managing a database of classes, teachers, and students. The Altheltics department has asked you to include information about sports that the students participate in. They have provided a list of sports, and the students who participate, for you to import into your existing database. What will this create?
A table
Martha works for a company that uses databases regularly. Her boss tells her to delete from the database some products that are discontinued. Which type of query does Martha need to use to delete specific records from the database?
Action query
Which operation will alter the "look and feel" of a report?
Adding a report theme
You are reviewing a table of Student information. The table has the following fields: Student ID, First, Middle, Last, Age, Grade and Homeroom. Which command can enable you to change the order of the records to display all students in alphabetical order by their last name and then in order by their first name?
Advanced Sort/Filter
Study this example of a database. Which field uses the Number format?
Age
As an advertising agent, your job is to help your clients identify who their best clients are, where these customers are located, and what kind of commercials or advertisement would appeal to these customers. What resource offers you all of this information?
Big data
Sophia is a marketing executive. Part of her job is to analyze the advertising data that her company collects to help her provide product suggestions to customers. Which of the following is Sophia using?
Big data
Which of the following is used by advertisers to determine the best method to reach their target markets?
Big data
Study this example of a database table. Students need to be organized into lines to get on their bus for the ride home. What field would you use to sort the table, to help organize students for their trip?
Bus #
Mary has created a table that contains the following fields of information: Class Number, Class Description, Room Assignment, Assignment Date and Teacher ID. Which field would require a text data type?
Class Description
Keisha is a Science Supervisor for all the science teachers in the district. She wants to track all the classes taught by each teacher during school year. What information would be the most helpful for Keisha to have in her database to help her with her tracking?
Class dates, Class Title and Name of Teacher.
Your team is complaining about entering data into your table using the Datasheet view. They are asking your help to make data entry easier. Which database component can you use to help your team with data entry?
Form
Your relational database tracks your cookie sales to your local customers. A member of your staff has received a request to remove a customer from the Customers table. What is the first step taken before the customer record is removed?
Confirm that the customer record can be deleted without adversely affecting any other objects in the database.
As part of a research project about World War I, you are recording facts and statistics about each country's economy and social structure. Your information may be in a variety of formats: numbers, text, graphics, audio and video. In a relational database, data types can:
Consist of multiple data types, including text, numbers, graphics, sound clips and video.
You are helping a friend build a query for his database. His database has five tables and no table relationships exist. You add three tables to the query. Before you can proceed with selecting fields for the query, which task must you complete?
Creating a table join
Nadia is creating a table of financial transactions. In each record, she will capture the date and type of transaction, the person who recorded it and the amount. Which data type should she set for the field containing the transaction amount?
Currency
Many-to-many relationships between tables are created using a junction table. Which table in the Relationships window below is the junction table? The figure shows a Relationships window. Aircraft Technical specifications table has Aircraft, Length, Height, Wingspan, Weight, Cruising Speed, Range, Engine and Capacity attributes where Aircraft is shown in bold. Customers table has Airline, Aircraft, Quantity, and Order Date where Airline is shown selected. Airlines table has Airline, Type and Base attributes where Airline is shown in bold. Engines table has Engine, Manufacturer, Thrust and Type attributes where Engine is shown in bold. Relationships are showns between the tables. Figure A: Relationships window
Customers
Three people are tracking the results of a single survey. They share their results in different file types via email but the compiled results are inconsistent and questionable. What feature of a database would improve this tracking process?
Data can be protected against accidental changes.
Which statement is true about the data types that can be used in relational databases?
Data can consist of multiple data types, including text, numbers, graphics, sound clips and video.
Databases used by organizations such as Google, Amazon, and Facebook are typically referred to as "big data." What does "big data" mean?
Data sets that cannot be stored or processed using traditional database software
Data is first collected, then reviewed and revised as needed. Lastly, questions or "queries" are asked about the data to inform decisions or provide insights like "which language classes have more than 30 students" or "how many countries involved in World War I had a population of less than 1 million people at the time of the war". Which tool allows a user to perform all of these tasks - collecting, editing and questioning data?
Database
Which tool allows a user to store organized information that can easily be accessed, edited and queried?
Database
Which type of software is considered the most difficult to learn?
Database software
You have a large collection of related data. You want to use a relational database but your partner wants to use a spreadsheet. Which of the following would you share with your partner as an advantage of using databases instead of spreadsheets?
Databases remove the need for redundant data.
Mrs. Leonard maintains a large database of student information. She has identified two student records that have the same name, same enrolled courses, but slightly different student numbers. Only one of them has related quarterly grading records. What should Mrs. Leonard do?
Delete the record that does not have any quarterly grades.
Mary maintains a large database of customer information. A user has identified two company records that have the same name, same address, but different customer IDs. Only one of them has related sales transaction records. What should Mary do?
Delete the record that does not have any sales transactions.
Steve has been given a list of products that are no longer being manufactured by his company. He needs to update the product database. What task will he be performing?
Deleting records
Which database error commonly occurs when a user is creating a database that can result in data errors?
Entering the wrong data type in a field
You are reviewing a collection of data about cookie sales for the Good Cookie Company. You need to group the data by month, calculate the total sales, define the average sales per quarter and show your results in a chart. Which application would be the best for performing all of these tasks?
Excel
As you build your database, you need to define the types of information tracked in each table. This information would appear across the top of the Datasheet view. Which database component is used to define your information by data type?
Field
Study this example of a database. Which database component is shown outlined in black?
Field
The information in your table is not appearing correctly. You entered the date "10/1/2015" but what appears is the number "42278". Which database component should be inspected to determine why the data does not display correctly?
Field
Which database component is used to organize information by data type?
Field
Which term describes a single entry of information of a particular data type in a database table?
Field
Entering data into a database can be a daunting task if related data needs to be entered into multiple tables at the same time. What database components can be customized to make the data entry easier?
Forms
A Groups and Totals report is used to group information by one or more fields. In most reports, the fields being used to group the data will be displayed above the records that are contained in the group. What is the name of report section that stores and displays these fields in a report?
Group Header.
You are including email addresses in your student information table. When someone clicks on the email address, it should open a new email message and populate the To field with the selected email address. What data type should be selected to enable this functionality?
Hyperlink
Lena needs to connect two tables in her database using database keys. In her first table, she has the following student information: First Name, Last Name, ID, Grade Level. The second table contains class information: Student ID, Class Number, Class Description, Room number. Which field is Lena's primary key for student information?
ID
Study this example of a database. Which field is sorted in numerical order?
ID
What kinds of data types can be stored in relational databases?
Images
Liam and Robin are working together to update their database of student information. Robin has collected twenty new names and stored them in a MS Excel spreadsheet. What must Liam do to add Robin's records to the Students table?
Import the records from the spreadsheet and append them to the Students table.
Brian has converted a spreadsheet into a database. Which operation did he perform?
Importing
Which statement is true about the functions of relational databases?
Information can be related among multiple tables.
Several individuals on your team have entered incorrect phone numbers in your Customers table. In some cases, area codes have been forgotten. For others, the dashes have been replaced with periods. What field property can help reduce these data entry errors?
Input Mask
What kind of data would an art gallery retail store need to store in a database?
Inventory, prices, sales, customer information
You work for Google as a data analyst, researching and reviewing "big data" to better match a user's interests to the advertisements shown on the search results pages. Which answer below best defines the "big data" you are working with?
Large amounts of user-specific search criteria collected over time that cannot be stored or analyzed using traditional database tools.
Which type of database relationship allows one record in Table A to relate to many matching records in Table B, and vice versa?
Many-to-many
Johann is creating a database field which will store descriptive text about products. Which data type should he set for this field?
Memo
Which of the following is an advantage of using databases instead of spreadsheets?
Multiple people can use the same database data at a time.
You have been tasked with building a database to record and store information for your PTA. The database will contain information about parents, children, teachers, events and fund raising efforts. What attributes of your database define it as a "relational database"?
Multiple tables with common fields that are joined to form relationships
Your local bank uses a complex database management system to keep track of all its clients, their accounts and daily transactions. If you were an analyst working for the bank, what application would you use to question the bank's database about the transactions made by one client in New Jersey?
MySQL
When entering a student's information in a table, you must enter a Name, Street Address, City, State, Zip code and Phone number. If you enter this information for a student, how many records have you created?
One
Miranda is creating a database field that has money values. Which data type should she set for this field?
One-to-many
Which type of database relationship allows one record in Table A to relate to many matching records in Table B, and many records in Table B to relate to only one matching record in Table A?
One-to-many
Paul works for a very large company that uses database applications every day. What database application would most likely be used in the company that Paul works for?
Oracle
Daniel works at a hospital. He is creating a database for his patient care department. Which type of information would be included in his database?
Patient allergy notes
Which of the following is a unique identifier that is assigned to a field when a user creates a database table?
Primary key
Rajesh wants to compile a list of Italian language teachers and the students registered in each class. He has stored all the teacher, student and class information separately. Which of the following would Rajesh use to compile his list?
Query
Which of the following allows a user to create a table or report based on specific fields within a database?
Query
Which of the following is used to retrieve specific information from a database?
Query
Which of the following pulls information from several tables and displays the output in a separate table?
Query
Which data type may contain text, numbers and/or certain special characters?
Text
Your advertising manager needs your help. He wants a list of the largest orders received last month. The list of information should include the products purchased and their total quantities. The manager doesn't need the names of the customers just yet but might after he reviews your data. What Access object will you use to produce the information for the advertising manager?
Query
Entering student information into the Datasheet view of a table creates a new row for each new student added. Each row in a table is also known as a ________.
Record
Study this example of a database. Which database component is shown outlined in black? Student Information table is shown with ID, Name, Birthdate, Age, Favorite Color. Various data is entered. 3, Billy J., 12/25/2000, 14, Red is outlined horizontally. Figure A: Example of a Database Table
Record
Which database component is commonly referred to as a table row within a database?
Record
Which term describes a single entity composed of several data types in a database table?
Record
Which statement is true about records when they are deleted from a database table?
Records are removed completely from the table.
Which of the following consists of multiple tables of information that are related through common fields?
Relational database
You are working with a team to compile student and teacher information. This information will be used to connect teachers to students based on classes taken and home addresses. Which software would be the best choice to help with this compilation task?
Relational database
Jennifer needs to create a presentation that summarizes the data in her database. Which of the following does she need to create?
Report
You have compiled a list of customers with the largest orders in the fourth quarter. Your manager would like to see your list in an easy-to-read format. What do you need to create to satisfy your manager's request?
Report
You have developed a database about the favorite music of the students in your school. It has been populated with several thousand records. Now you need to provide information on the most popular types of music. Which database component can you use to provide this information?
Report
You need to share information from your database with your supervisor. Your supervisor is asking for something she can easily read that groups the information with totals beneath each group and shows the company's logo. What Access object will you use to produce the information for your supervisor?
Report
Jason is taking a Web programming class in college. He is learning a programming language that allows users to create and manage databases. Which language is Jason learning in his class?
SQL
Louis will be using his database to support his new web-based trading card shop. The database will need to insert, update and delete information about his customers, the trading cards he buys and sells and orders for the cards themselves. What language will he use to access and modify the information in his database through his website?
SQL
Which language is used to develop and manage databases?
SQL
Which operation allows you to arrange database records in alphabetical order?
Sorting
Marion wants to store her science experiment results in one space inside of a database. She wants to be able to quickly review past results, filter by experiment date, and sort her results in multiple orders. What Access object should Marion chose that best meets her needs?
Table
Alan is building a query with the two tables show below. His results must include the measurements of the aircraft, the airline interested in purchasing the aircraft, the number of aircrafts ordered and the date the order was placed. Select the correct fields Alan should add to his query to obtain his results.
Table A: Aircraft, Length, Height, Wingspan Table B: Airline, Quantity, Order Date
Principal Spencer has a database that includes the quarterly grades of the students enrolled in her school. She needs to print report cards to give to teachers to distribute to students so that they can be taken home. Which field should she sort her list by to quickly print and distribute the report cards during home room?
Teacher name
Which is a function (use) of a relational database for a school?
Teachers can organize students by grade level and class period.
You have a table containing information about each course offered at your school. Within each record you want to capture a brief description of the course - less than 200 characters. Which data type should you select for your course description field?
Text
Brandon is creating a database that includes all of his friends' names, birthdates and ages. Which three data types does Brandon need to use?
Text, Date/Time and Number
Antonio wants to create a structured report that presents his sales information organized by sales divisions and then in order by the sales reps according to their total sales. What command would step Antonio through building his report?
The Report Wizard button in the Create tab.
You create a select query to pull information together from your Customers and Orders tables. The query contains five fields from the Customers table and four fields from Orders. It also contains the criteria to show only customers from NY and orders placed during the October 2015. When you save the query, what are you saving?
The SQL coding of the fields selected, their source tables, and the criteria.
Which of the following occurs when you delete a record in the database?
The record is permanently deleted and cannot be retrieved.
There are two tables in your database: Students and Identification Resources. Each student only has one identification resource and only one identification resource can be associated with each student. What is unique about the relationship between these two tables?
The relationship is created only if both of the related fields are primary keys.
Mr. Daniels is the basketball coach at school. Which of the following would be his best use of a database?
Track student academic eligibility by teacher.
Justine was reviewing a database report she generated for last month's cookie sales. One order was for 1,000 boxes of cookies - an extremely large request compared to all the other orders. Justine looked into the order and discovered the actual quantity ordered was 100 not 1,000 and changed that value in her database. What task did Justine complete?
Updating a record
Lisa changes her home address in a database field to her new address. This is an example of what type of operation?
Updating a record
Antonio is creating a report. He wants to sort and total the information pulled from the database. Which operation would allow him to manipulate the data this way?
Using Control Tools in the Report Wizard
Lynn is creating a database query. She forgets to use a closing parenthesis ")". Now her query will not run. Which type of error did Lynn make?
Using the wrong syntax for a query
Blake is creating a database field which will indicate whether a student has passed the previous class or not. Which data type should he set for this field?
Yes/No
Spencer has a database of 2000 customers. He needs to print mailing labels. He can get a discount on the postage, if he delivers the labeled mail in an organized way. Which field should he sort his list by, to take advantage of the discount?
Zip/postal code
Yes/No, Date/Time and Number are examples of:
data types.