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...
computer concepts module 13 exam 2023 questions and answers verified answers one of edens customers has closed his account and moved to a different state she needs to change his status to inac
Written for
Computer Concepts Module
All documents for this subject (43)
Seller
Follow
magdamwikash23
Reviews received
Content preview
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
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller magdamwikash23. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for £6.64. You're not tied to anything after your purchase.