study guide for data base certification

 Question 1 Which tool allows a user to store organized information that can easily be accessed, edited and queried?

• database
• spreadsheet
• exel
• onenote

Question 2 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?

• teacher contacts
• pacient allergy notes
• his lunch
• his dinner 

Question 3 Which operation allows you to arrange database records in alphabetical order? 

• sorting 
• order 
• aphabet order 
• none of the above 

Which database component is commonly referred to as a table row within a database?TitleRecordFieldColumn

• title 
• record 
• field 
• column

Question 5 Lisa changes her home address in a database field to her new address. This is an example of what type of operation?

• creating a record 
• updating a record 
• deleting a record 
• adding a record 

question 6 Which of the following is used by advertisers to determine the best method to reach their target markets?

• mass mailing 
• email
• big data
• flyers 

Question 7 Which of the following is an advantage of using databases instead of spreadsheets?

• mutiplal pepole can use it at the same time 
• none of the above 
• one person can use it at a time 
• two pepole can use at the same time 

Question 8 Which type of software is considered the most difficult to learn?

• data base 
• spread sheet 
• exel 

Question 9 Which of the following allows a user to create a table based on specific fields within a database?  

• primary key 
• forien key
• query
• none of the above 

Question 10 Which of the following consists of multiple tables of information that are related through common fields?

• age 
• height 
• realational databases 
• all of the above