Relational databases - Study guides, Class notes & Summaries

Introduction to Relational Databases CS1011 (SOPH-0047) Sophia Milestone 2 UNIT 2

Western Governors University WGU CS1011 Sophia_Introduction_to_Relational_Databases_Milestone_3

WGU SOPHIA Relational Databases Milestone 4 All Possible Questions and Answers 2024 with complete solutions his is a review of questions that could potentially be on the milestone 4 test. I submitted in word document so you are able to use the CTRL+f keys to find questions easier as there are quite a few

Introduction to Relational Databases CS1011 (SOPH-0047) Sophia Milestone 3 UNIT 3

WGU CS1011 Sophia 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 ...

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...

1.2 SINGLE TABLE CONSTRUCTION The following CREATE TABLE statement creates a table called 'company' that consists of the company_id as the primary key, the company_name, and the address. CREATE TABLE company( company_id INT PRIMARY KEY company_name VARCHAR (100), address VARCHAR (100) ); Identify the line of code that would generate an error in this CREATE TABLE statement.
a.)
2
b.)
4
c.)
1
d.)
3
The following CREATE TABLE statement creates a table called ...

Identify the SQL command that uses an aggregate function that could be used to find the lowest total in the invoice table.
a.)
SELECT lowest(total) FROM invoice;
b.)
SELECT total(min) FROM invoice;
c.)
SELECT min total FROM invoice;
d.)
SELECT min(total) FROM invoice; Identify the SQL command that uses an aggregate function that could be used to find the average total in the invoice table.
a.)
SELECT avg(total) from invoice;
b.)
SELECT average total FROM in...

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

Which of the following statement(s) would successfully delete the invoice_id 353 from the invoice table?
a.)
DELETE FROM invoice_line WHERE invoice_id = 353;
DELETE FROM invoice WHERE invoice_id = 353;
b.)
DELETE FROM invoice WHERE invoice_id = 353;
c.)
DELETE FROM invoice WHERE invoice_id = 353;
DELETE FROM invoice_line WHERE invoice_id = 353;
d.)
DELETE FROM invoice_line WHERE invoice_id = 353 Which of the following statement(s) would successfully delete the inv...