Sophia Database
MILESTONE 3 RETAKE GUIDE
Southern New Hampshire University
Actual Questions & Verified Answers with Rationales
100% Guarantee Pass
,5/31/22, 11:32 PM Sophia :: Welcome
Score 13/21
13/21 that's 62%
Retake
13 questions were answered correctly.
8 questions were answered incorrectly.
Milestone Tips
Remember that Milestones are open-book.
Take the Practice Milestone before taking the Milestone.
Take the Milestone at a time and in a place where you can be focused and undisturbed for the entire
Milestone time limit.
Milestone Retake
UNIT
You are3 — one
allowed MILESTONE
retake per Milestone. 3
The retake score will replace your original score.
Make sure you're ready. Review our list of Milestone Tips.
Retake Now Maybe Later
Milestone Retake
Before you begin, please make sure you're in a place where you can be focused and undisturbed for the entire
Milestone time limit.
Begin Retake
Cancel
1. Milestone Retakes
Sophia allows one retake per Milestone. If you ever want to retake a Milestone, click this button.
Got it
1
https://app.sophia.org/spcc/introduction-to-relational-databases/milestone_take_feedbacks/14440362 1/19
, 5/31/22, 11:32 PM Sophia :: Welcome
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 statements will grant insert permissions on the track table to all users?
GRANT INSERT ON public to track;
GRANT INSERT ON track TO public;
GRANT INSERT ON track TO ALL;
GRANT INSERT ON 'track' TO 'public';
RATIONALE
Common mistakes when granting privileges to roles include using quotes around the table or role name, not
using commas between privileges, including the incorrect privileges, and using the incorrect syntax.
CONCEPT
GRANT to Assign Privileges
Report an issue with this question
Reported. Thanks for your feedback.
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 statements represents a correctly structured transaction?
BEGIN
UPDATE track
set name = 'A New Road'
where track_id = 5;
insert into artist (artist_id, name) values (900, 'Special Artist' );
insert into genre (genre_id, name) values (30, 'Funk' );
COMMIT;
https://app.sophia.org/spcc/introduction-to-relational-databases/milestone_take_feedbacks/14440362 2/19
MILESTONE 3 RETAKE GUIDE
Southern New Hampshire University
Actual Questions & Verified Answers with Rationales
100% Guarantee Pass
,5/31/22, 11:32 PM Sophia :: Welcome
Score 13/21
13/21 that's 62%
Retake
13 questions were answered correctly.
8 questions were answered incorrectly.
Milestone Tips
Remember that Milestones are open-book.
Take the Practice Milestone before taking the Milestone.
Take the Milestone at a time and in a place where you can be focused and undisturbed for the entire
Milestone time limit.
Milestone Retake
UNIT
You are3 — one
allowed MILESTONE
retake per Milestone. 3
The retake score will replace your original score.
Make sure you're ready. Review our list of Milestone Tips.
Retake Now Maybe Later
Milestone Retake
Before you begin, please make sure you're in a place where you can be focused and undisturbed for the entire
Milestone time limit.
Begin Retake
Cancel
1. Milestone Retakes
Sophia allows one retake per Milestone. If you ever want to retake a Milestone, click this button.
Got it
1
https://app.sophia.org/spcc/introduction-to-relational-databases/milestone_take_feedbacks/14440362 1/19
, 5/31/22, 11:32 PM Sophia :: Welcome
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 statements will grant insert permissions on the track table to all users?
GRANT INSERT ON public to track;
GRANT INSERT ON track TO public;
GRANT INSERT ON track TO ALL;
GRANT INSERT ON 'track' TO 'public';
RATIONALE
Common mistakes when granting privileges to roles include using quotes around the table or role name, not
using commas between privileges, including the incorrect privileges, and using the incorrect syntax.
CONCEPT
GRANT to Assign Privileges
Report an issue with this question
Reported. Thanks for your feedback.
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 statements represents a correctly structured transaction?
BEGIN
UPDATE track
set name = 'A New Road'
where track_id = 5;
insert into artist (artist_id, name) values (900, 'Special Artist' );
insert into genre (genre_id, name) values (30, 'Funk' );
COMMIT;
https://app.sophia.org/spcc/introduction-to-relational-databases/milestone_take_feedbacks/14440362 2/19
