Relational databases - Study guides, Class notes & Summaries

Introduction to Relational Databases Milestone 1 Retake Questions and Answers (Score 33/36) Latest. 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 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. Identify the correctly constructed ALTER TABLE statement to add a UNIQUE const...

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. Which type of backup would result in the fastest to RESTORE? Nightly backup Incremental backup Full backup Differential backup

WGU CS1011 Sophia Introduction to Relational Databases Milestone 2 Retake Questions and Answers Score 20/25. 20/25  that's 80% RETAKE  20 questions were answered correctly. 4 questions were answered incorrectly. 1 question was skipped. These were marked incorrect. 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. Which of the fol...

Which of the following queries will use a subquery to find the rows in the invoice table in the country USA that have the invoice total larger than the average of invoices of those in the country Canada?
a.)
SELECT * FROM invoice
WHERE total >
(SELECT AVG(total) FROM invoice
WHERE billing_country = 'Canada') AND billing_country = 'USA';
b.)
SELECT * FROM invoice
WHERE total >
(SELECT AVG(total) FROM invoice
WHERE billing_country = 'USA') AND billing_...

Sophia Introduction to Relational Databases Milestone 2, Answered

Sophia Introduction to Relational Databases Milestone 2, Answered

Schema The definition of how data in a database will be organized. - Create - Read - Update - Delete The basis of interacting with databases can be defined using the CRUD acronym. What does CRUD stand for? Brainpower 0:02 / 0:15 DATE: YYYY-MM-DD DATETIME: YYYY-MM-DD HH:MM:SS What is the DATE datatype syntax? What is the DATETIME datatype syntax? It will have 3 numbers before the decimal and 2 after. What does DECIMAL(3,2) indicate? Stored Procedures ...

Sophia Introduction to Relational Databases Milestone_3. (Score 95%)

Sophia Introduction to Relational Databases Milestone 1, Answered

All invoices from USA will require a fee paid to an external organization for 10% of the total. Which of the following statements would query the sum of the total of the invoices in the country USA and calculate 10% of it?
a.)
SELECT AVG(total*.10) AS calculated_fee FROM invoice
WHERE billing_country = 'USA';
b.)
SELECT total(SUM)*.10 AS calculated_fee FROM invoice
WHERE billing_country = 'USA';
c.)
SELECT SUM(total)*.10 AS calculated_fee FROM invoice
WHERE bill...