RDB Unit 1 Milestone 1

pdf

School

Southern New Hampshire University *

*We aren’t endorsed by this school

Course

231

Subject

Information Systems

Date

Feb 20, 2024

Type

pdf

Pages

36

Uploaded by MinisterResolve10240

Report
33736 aim
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. tipsposgressophiar ‘The following CREATE TABLE statement creates a table called ‘album' that consists of the album_id as the primary. Identify the fine of code that would either generate a syntax, logical, or requirements error in this CREATE TABLE statement. °
Using the LIKE operator in the WHERE dlause, use the necessary wildcards to filter the album table to find the. albums that have Disc 1in the fitle. 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 6th album K4 2
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
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. | Using the SELECT statement, query the track table to find the maximum bytes where the milliseconds are greater than 1650, P — =
‘each milestone, you may want or need to use the database and query tool to answer some of the questions. We. Jsing the WHERE and HAVING clauses, ilter the track table for the tracks having the genre_id set o1 or grouped by the album_id with a number of tracks greater than 15. Provide the list of album_id's and the sum o Which of the following queries would provide the correct results?
I B 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 SQL command that uses an aggregate function that could be used to find the newest employee in
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
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. Ve oo i e e el e e fom playlis_track WHERE playist id =3 o from playlist WHERE playlist_id =8 'DELETE FROM playiist_track WHERE playist_id_id
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 following is a correctly formatted INSERT statement that will insert three records into the playlist [ insert nto playist (rameplaylist_id) values (40, Top 40), (41, Top. 40), (42, Top 40) insert nto playlist (playlist_id, name) values (40, Top 401, (40, Top 1), (40, Top 42) insert nto playlist (playlist_id, name) values (40, Top 401 (41, Top. 40) (42, Top 40)
I B 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. ° ALTER TABLE invoice ALTER COLUMN total TYPE VARCHAR (100); Given the invoice table and the data that it contains, and assuming that you have the rights to modiy the table, which of the following ALTER TABLE statements would work without errors? ALTER TABLE customer ALTER COLUMN billing_city TYPE /ARCHAR (); ALTER TABLE invoice ALTER COLUMN billing._state TYPE BOOLEAN; ALTER TABLE invoice ALTER total TYPE VARCHAR (I;
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
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 constraint to the column student_number with the constraint name student_number_unique on the table called ‘student. ALTER TABLE student ADD CONSTRAINT student_number UNIQUE (student_number); ALTER TABLE student ADD UNIQUE student_number CONSTRAINT (student_number_unique};
Using the SELECT statement, query the invoice table to find the average total cost for all orders placed in the. country France. 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. N sconsrszorsns oo o
o 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. Given the tables provided, which of the following DROP TABLE series of statements would correctly remove the tables without causing an error?
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
L 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 following is a correctly formatted INSERT statement that will successfully add a record into the. artist table? o
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. Given the invoice table and the data that it contains, and assuming that you have the rights to modify the table, which of the following ALTER TABLE statements would create an error? ALTER TABLE invoice ALTER COLUMN billng_city TYPE VARCHAR (100 ALTER TABLE invoice ALTER COLUMN billng_state TYPE VARCHAR (100 ALTER TABLE invoice ALTER COLUMN total TYPE VARCHAR (100);
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. Select the correctly constructed CHECK constraint to validate the phone_type column of type string, to ensure that values placed into it are either work, hiome, or mobile e s e i ° CHECK (phone_type IN (work, ‘home, ‘mobile)
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
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 these SELECT statements would successfully display exactly five columns of data from the customer [ 'SELECT customer_id + dity + state + phone + company FROM customer SELECT customer_id, city, state, phone, compar 'SELECT customer_id, city_id, state_id, phone_id, company_id FROM customer
1 B 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 that removes the address column from the customer table.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
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. Using the SELECT statement, query the track table to find the average length of a track that has the genre._id equal to 5, rounded to the nearest millisecond.
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. What is the main function of the FROM clause in SQL? fo refrieve zero or more rows from one or more database columns 0 apply conditions to filter the datase ° o identify one or more tables as the source for a quer
H 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. i S o et ke e A e, s A T
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
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. USING the SELECT statement, query the track table ordered by the track_id. Set the LIMIT o § and OFFSET to 40. S P—— ot e oc ° e Right Through
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
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. Using the GROUP BY clause and the count aggregate function, filter the track table to group the tracks based on album_id How many tracks are in album 997
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
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 following would set the media_type._id to 1 on all tracks where the album_id s set to 37
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
° K
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
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. Using the SELECT statement, query the customer table to find the number of customers that live in the. country Canada. °
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
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. Using the BETWEEN operator, filter the album table to find the albums with an artist ID between 5 and 10. Identify the 5th album ID. °
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
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. Using the ORDER BY clause, sort the customer table by the first name of the customer in descending order and identify the 12th name in the list from among the answer options.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
| O 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. Consider the following tab Which of the following is a correctly formatted INSERT statement that will successfully add a new record that uses the auto-incremented primary key into this table? o T ——————— oo et i e e e b
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
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. PRIMARY KE
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
INSERT INTO locationlist 'SELECT city, country, postal_code FROM customer 'SELECT city, country, postal_code FROM customer,;
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
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. Using the GROUP BY and HAVING clauses, filter the customer table by country. How many countries have more than 3 customers? ° A .
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
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. ‘The following CREATE TABLE statement creates a table called ‘artist' that consists of the artist_id s the primary Identify the fine of code that would generate an error in this CREATE TABLE statement.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help

Related Documents

unit 7 IT4076 Incident Report.docx
9.pdf
IT4071- A2 (1).docx
Chapter 10 Discussion.docx
Test Your Knowledge On Testing Your Data.docx
Test Your Knowledge On Data Integrity and Analytics Objectives.docx
Assignment HW2.docx
Summary ToDo List.docx
Assessment 1- Short Answer Questions.docx
AT1 Written Questions_Concepts.doc
Prepare Data For Exploration Course Challenge (Part 7).docx
CYB 300 Module Three Lab Worksheet.docx