Exam (elaborations)
Relational Database Sophia Unit 1 Quizzes Solved 100% Correc
- Course
- Institution
Relational Database Sophia Unit 1 Quizzes Solved 100% Correc
[Show more]
Seller
Follow
Content preview
Relational Database Sophia Unit 1 QuizzesSolved 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;
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 KenAli. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $12.49. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
81989 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now