Computer Concepts Module 13 Exam 2023 Questions and
Answers (Verified Answers)
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
A database backup can include information on who made what changes and when
since the previous database backup.
true
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
What characteristic of Big Data indicates how closely that data matches reality?
veracity
Which of the following is a key aspect of database security according to the CIA triad
security model? Choose two.
Availability and Integrity
Morgan needs to hire someone to help implement a business intelligence system for her
company. What type of professional would be the best fit for this job?
data analyst
Which data repository type is most likely to include database tables and primary keys in
its internal data structure?
data warehouse
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
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
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
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
Darcie has hired a programmer to make some custom changes to a DBMS she plans to
move her business database to. What kind of DBMS is she using?
open source
Which data type would be best suited to a field that lists customer email addresses?
hyperlink
Casey is looking for a free, open-source RDBMS for his company. Which of the
following best meets these requirements?
PostgreSQL
Answers (Verified Answers)
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
A database backup can include information on who made what changes and when
since the previous database backup.
true
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
What characteristic of Big Data indicates how closely that data matches reality?
veracity
Which of the following is a key aspect of database security according to the CIA triad
security model? Choose two.
Availability and Integrity
Morgan needs to hire someone to help implement a business intelligence system for her
company. What type of professional would be the best fit for this job?
data analyst
Which data repository type is most likely to include database tables and primary keys in
its internal data structure?
data warehouse
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
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
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
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
Darcie has hired a programmer to make some custom changes to a DBMS she plans to
move her business database to. What kind of DBMS is she using?
open source
Which data type would be best suited to a field that lists customer email addresses?
hyperlink
Casey is looking for a free, open-source RDBMS for his company. Which of the
following best meets these requirements?
PostgreSQL
