Module #13 Computer Concepts Exam Questions
and correct answers, complete solution, 2024.
Raphael is working with a table in Access. He needs to see all the records for
customers in Chattanooga so he can check the zip codes in that city. Which
database tool will show only these records in the table?
filter
Mindy needs to run a SQL query that will pull the names and birthdates of all her
students. What should the FROM phrase say in her query?
FROM Students
Melody is building a database for a restaurant. Which pair of tables is least likely
to need a direct relationship with each other?
Customers, Ingredients
Kiera is building a front-end user interface for the database her new website will
use. Which of the following languages is NOT used to build a webpage?
SQL
Which of the following scenarios would most likely rely on Big Data? Choose two.
Evaluating applications for disability benefits and Calculating traffic delays during rush
hour
Kian needs to sort a list of patients by birthdate to show the oldest patients first.
What sort order on the birthdate field will give him this result?
smallest to largest
Dana is creating a table that will show books for sale on a bookstore's website.
Which field in the table would best serve as its primary key?
ProductID
One of Eden's customers has closed his account and moved to a different state.
She needs to change his status to Inactive. What SQL command will accomplish
this task?
UPDATE
Students who complete an online test are not allowed to change their test grades.
What aspect of the CIA triad is at work here?
integrity
Aron is building a website that will require a back-end database. He plans to
connect the web server on his network in a way that it will be easily accessible
from the Internet. He should connect his database server the same way so data in
the database is readily accessible to the web server.
False
Which of the following would most likely be the key paired with a value of
"Canada" in a nonrelational customer database?
country
What kind of database is needed to hold and organize diverse data types, such as
X-ray images and doctors' notes, in a medical database?
Nonrelational database
and correct answers, complete solution, 2024.
Raphael is working with a table in Access. He needs to see all the records for
customers in Chattanooga so he can check the zip codes in that city. Which
database tool will show only these records in the table?
filter
Mindy needs to run a SQL query that will pull the names and birthdates of all her
students. What should the FROM phrase say in her query?
FROM Students
Melody is building a database for a restaurant. Which pair of tables is least likely
to need a direct relationship with each other?
Customers, Ingredients
Kiera is building a front-end user interface for the database her new website will
use. Which of the following languages is NOT used to build a webpage?
SQL
Which of the following scenarios would most likely rely on Big Data? Choose two.
Evaluating applications for disability benefits and Calculating traffic delays during rush
hour
Kian needs to sort a list of patients by birthdate to show the oldest patients first.
What sort order on the birthdate field will give him this result?
smallest to largest
Dana is creating a table that will show books for sale on a bookstore's website.
Which field in the table would best serve as its primary key?
ProductID
One of Eden's customers has closed his account and moved to a different state.
She needs to change his status to Inactive. What SQL command will accomplish
this task?
UPDATE
Students who complete an online test are not allowed to change their test grades.
What aspect of the CIA triad is at work here?
integrity
Aron is building a website that will require a back-end database. He plans to
connect the web server on his network in a way that it will be easily accessible
from the Internet. He should connect his database server the same way so data in
the database is readily accessible to the web server.
False
Which of the following would most likely be the key paired with a value of
"Canada" in a nonrelational customer database?
country
What kind of database is needed to hold and organize diverse data types, such as
X-ray images and doctors' notes, in a medical database?
Nonrelational database
