Sophia Introduction to Relational Databases UNIT 3 — MILESTONE 3
72 views 0 purchase
Course
Sophia Introduction to Relational Databases
Institution
Sophia Introduction To Relational Databases
Sophia Introduction to Relational Databases Milestone_3.
16/21 that's 76%
In each milestone, you may want or need to use the database and query tool to answer some of the questions. We suggest you open the tool in another browser tab while you are working on this assessment.
Whi...
sophia introduction to relational databases milest
Written for
Sophia Introduction to Relational Databases
All documents for this subject (9)
Seller
Follow
LectDan
Reviews received
Content preview
UNIT 3 — MILESTONE
3
16/2
Sophia Introduction to Relational Databases
1
Milestone_3.
16/21 that's 76%
This Milestone has been retaken.
16 questions were answered correctly. 5 questions were
answered incorrectly.
1
In each milestone, you may want or need to use the database
and query tool to answer some of the questions. We suggest
you open the tool in another browser tab while you are working
on this assessment.
https://postgres.sophia.org/
Which type of backup would result in the fastest to RESTORE?
Nightly backup
Incremental backup
Full backup
, Differential backup
RATIONALE
,Full backups are a full copy of the entire data set. Although they
areUNIT
the best3protection,
— MILESTONEthey are time-consuming and quite large to
3 Incremental backups only back up the data that has changed
store.
since the previous backup, even if it's another incremental backup.
16/2
These file sizes are the smallest out of the lot. Differential backups
1
are similar to incremental backups, but they start with a full
backup and include data since the prior full backup. At most, there
are only 2 backups to restore from.
CONCEPT
Backup Methods
Report an issue with this question
2
In each milestone, you may want or need to use the database
and query tool to answer some of the questions. We suggest
you open the tool in another browser tab while you are working
on this assessment.
https://postgres.sophia.org/
Which of the following scenarios reflects the
durability property?
The product quantity starts at 200.
Transaction 1 runs to read the quantity of the
product to be updated.
Transaction 2 runs in parallel to read the
quantity of the product to be updated.
Transaction 1 updates the product quantity to
reduce it by 100.
Transaction 2 updates the product quantity to
reduce it by 5.
, 6. The product quantity ends
UNIT 3at— MILESTONE 3
195.
16/21
1. A fairly large update is
made to the products table.
2. The update is saved to
the logs.
3. The update starts to then
save to the disk.
4. The system fails midway
through.
5. When the system starts back
up, the committed transactions
that haven't been written to disk
are written.
1. User 1 has $500 in their
online account.
2. User 2 has $300 in their online
account.
3. User 1 sends user 2 $100.
4. User 1 has $400 in
their account.
5. User 2 has $300 in their
account.
5. The transaction is reverted.
1. Transaction 1 reads a
product's cost which is set at
$100.
2. Transaction 1 updates the
product to set the price to
$90.
3. Transaction 2 reads the
same product's cost and sees
$100.
4. Transaction 1 commits the cost.
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 or Stuvia-credit 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 LectDan. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $11.49. You're not tied to anything after your purchase.
