Relational Database Sophia Unit 1 Quizzes Solved 100% Correc

Relational Database Sophia Unit 1 Quizzes
Solved 100% Correct

Which of the following is a correctly formatted INSERT statement that will successfully

add a record into the genre table? - ANSWER insert into genre (genre_id, name) values

(30, 'Funk' )



Consider the following new table:

CREATE TABLE contact(user_id SERIAL PRIMARY KEY,phone VARCHAR

NOT NULL);

Given this new table, which INSERT statement would query from the customer table

to insert the phone number of all customers that have an email address that contains

the word "apple" in it? - ANSWER INSERT INTO contact (phone)SELECT phone

FROM customerWHERE email LIKE '%apple%';



Which of the following would set the track name to "A New Road" for the track with a

track_id equal to 5? - ANSWER UPDATE trackset name = 'A New Road'where track_id

=5

, 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'. - ANSWER ALTER TABLE student ADD CONSTRAINT

student_number_unique UNIQUE (student_number);



Using the WHERE and HAVING clauses, filter the track table for the tracks having the

milliseconds greater than 100,000, grouped by the album_id having the number of

tracks greater than 20. Provide the list of album_id's and the count of tracks that fit

these criteria.

Which of the following queries would provide the correct results? - ANSWER SELECT

album_id, count(track_id)FROM trackWHERE milliseconds > 100000GROUP BY

album_idHAVING count(track_id) > 20



Identify the SQL command that uses an aggregate function that could be used to find

the youngest employee in the employee table. - ANSWER SELECT max(birth_date)

FROM employee;



Which of these SELECT statements would successfully display exactly five columns of

data from the customer table? - ANSWER SELECT customer_id, city, state, phone,

companyFROM customer;