Graded Quiz: Basic SQL >> Databases and SQL for Data Science with Python
TOTAL POINTS 5
1.True or False: The SELECT statement is called a query, and the output we get from executing the query is called a result set.
1 point
2.True or False: The INSERT statement can be used to insert multiple rows in a single statement.
1 point
3.Assume there exists an INSTRUCTOR table with several columns including FIRSTNAME, LASTNAME, etc. Which of the following is the most likely result set for the following query:
SELECT DISTINCT(FIRSTNAME) FROM INSTRUCTOR
1 point
LEON
PAUL
PAUL
PAUL
JOE
PAUL
LEON
JOE
PAUL ZIKOPOLOUS
JOE SANTARCANGELO
4.What does the following SQL statement do?
UPDATE INSTRUCTOR SET LASTNAME = ‘Brewster’ WHERE LASTNAME = ‘Smith’
1 point
5.Which of the following SQL statements will delete the authors with IDs of A10 and A11?
1 point
Related Questions & Answers:
- Graded Quiz: Relational DB Concepts and Tables Graded Quiz: Relational DB Concepts and Tables >> Databases and SQL for Data Science with Python 1.Which of the following ... Read more...
- Graded Quiz: Refining Your Results Graded Quiz: Refining Your Results >> Databases and SQL for Data Science with Python 1.You want to select author’s last ... Read more...
- Graded Quiz: Functions, Sub-Queries, Multiple Tables Graded Quiz: Functions, Sub-Queries, Multiple Tables >> Databases and SQL for Data Science with Python 1.Which of the following queries ... Read more...
- Graded Quiz: Database access from Python Graded Quiz: Database access from Python >> Databases and SQL for Data Science with Python 1.The ibm_db API provides a ... Read more...
- Peer-graded Assignment: Submit Your Work and Review Your Peers Peer-graded Assignment: Submit Your Work and Review Your Peers >> Databases and SQL for Data Science with Python You have ... Read more...
- Final Exam Final Exam >> Databases and SQL for Data Science with Python 1.The ______ statement is called a query, and the ... Read more...