Final Exam | Quizerry

Final Exam >> Databases and SQL for Data Science with Python

SELECT ✓

DROP DATABASE

ALTER

CREATE TABLE

DELETE FROM STUDENTS WHERE LAST_NAME FROM ‘Smith’

DELETE FROM STUDENTS WHERE LAST_NAME = ‘Smith’ ✓

DELETE FROM TEACHERS WHERE LAST_NAME = ‘Smith’

DELETE ‘Smith’ FROM STUDENTS

The primary key of a relational table ✓

The textual data

The columns

The secondary key of a relational table

Both of the above ✓

Data Definition Language

None of the above

Data Manipulation Language

SELECT City, count(City) FROM Teachers GROUP BY City ✓

SELECT City, distinct(City) FROM Teachers GROUP BY City

SELECT City, count(City) FROM Teachers

SELECT distinct(City) FROM Teachers

WHERE Pages 450 – 600

WHERE Pages >= 450 and pages <= 600 ✓

WHERE Pages = 450

IF Pages >= 450 and Pages <= 600

SELECT MIN(SALARY) FROM EMPLOYEES ✓

SELECT SALARY FROM EMPLOYEES WHERE MINIMUM(SALARY) = SALARY

SELECT LOWEST(SALARY) FROM EMPLOYER

SELECT MAX(SALARY) FROM EMPLOYEES

SELECT MAX(UNIT_PRICE) FROM PRODUCTS

SELECT PRODUCT_NAME FROM PRODUCTS WHERE UNIT_PRICE IS HIGHEST

SELECT PRODUCT_NAME FROM PRODUCTS WHERE UNIT_PRICE = MAX

SELECT PRODUCT_NAME FROM PRODUCTS WHERE UNIT_PRICE = (SELECT MAX(UNIT_PRICE) FROM PRODUCTS) ✓

Primary key

Connection

Import

Database cursor ✓

Database Name

Hostname or IP address ✓

Table name

Username and Password