Exam (elaborations)

Sophia Introduction to Relational Databases Milestone one, score 33/36, 92%

0 purchase

Course
Sophia introduction to relational databases

Institution
Sophia Introduction To Relational Databases

Sophia Introduction to Relational Databases Milestone one, score 33/36, 92% 33 / 36  that's 92% RETAKE  33 questions were answered correctly . 3 questions were answered incorrectly . In each milestone, you may want or need to use the databaseand query tool to answer some of the...

[Show more]

Preview 4 out of 40 pages

View example

Uploaded on October 7, 2023
Number of pages 40
Written in 2023/2024
Type Exam (elaborations)
Contains Questions & answers

sophia introduction to relational databases milest

Course
Sophia introduction to relational databases

LectDan

Member since 2 year 185 documents sold

$11.49

Add to cart

Add to wishlist

100% satisfaction guarantee
Immediately available after payment
Both online and in PDF
No strings attached

UNIT 1 — MILESTONE 1

33/36

33/36  that's 92% RETAKE

 33 questions were answered correctly.
3 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/

Identify the correctly constructed ALTER TABLE statement to
add a UNIQUE constraint to the column reference_number with
the constraint name reference_number_unique on the table
called 'document'.

ALTER TABLE document ADD
CONSTRAINT reference_number

UNIQUE (reference_number);

ALTER TABLE document ADD
CONSTRAINT
  reference_number_unique
UNIQUE (reference_number);

ALTER TABLE document ADD
UNIQUE reference_number


, CONSTRAINT
UNIT 1(reference_number_unique);
— MILESTONE 1

33/36
ALTER TABLE document ADD
CONSTRAINT reference_number
 UNIQUE
(reference_number_unique);

RATIONALE
Common mistakes with adding the UNIQUE constraint to an
existing column include not having ( ) around the column names,
omitting the keyword UNIQUE, incorrectly spelling the column
name, and not including the constraint name.

CONCEPT
 UNIQUE to Validate Data

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/

Using the SELECT statement, query the track table to find the
total cost of the tracks on album_id 5, rounded to the nearest
dollar.

14


, UNIT

114.9
— MILESTONE 1

33/36
14.85


15
 

RATIONALE
Common mistakes when using the ROUND function include not
selecting the right column, not including the precision level,
omitting the ( ) around the column/function, and failing to add in the
filter conditions.

CONCEPT
 ROUND to Round Numbers

Report an issue with this question

3 


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/

Using the AND or OR statement, filter the employee table for
employees who live in the city Lethbridge or have IT within their
title.

Identify the first name of the 2nd record.

Michael


, UNIT 1Robert
— MILESTONE 1
 

33/36
Laura
 

King


RATIONALE
Common mistakes include using the = instead of LIKE when
utilizing wild cards, filtering the wrong column of data, using the
wrong data table, omitting the single quotes around the data, and
forgetting to include the wild cards in all parts of the string rather
than just on one end. Another common mistake when using the
AND and OR statements is selecting the incorrect option; the AND
operator should be used when both conditions need to apply
whereas the OR operator should be used when only one condition
of the two should apply.

CONCEPT
 Multiple Filters

Report an issue with this question

4 


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/

Using the WHERE clause, filter the employee table to include
individuals that report to Andrew Adams, who has an
employee_id of 1.

Identify the title of the 2nd individual listed.

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.

Can Stuvia be trusted?

4.6 stars on Google & Trustpilot (+1000 reviews)

69052 documents were sold in the last 30 days

Founded in 2010, the go-to place to buy study notes for 15 years now

Start selling

Exam (elaborations)

Sophia Introduction to Relational Databases Milestone one, score 33/36, 92%

Document information

Subjects

Written for

Seller

Reviews received

Content preview