CS544 Quiz 3 — Deck 06: SQL

0.0(0)
Studied by 0 people
call kaiCall Kai
learnLearn
examPractice Test
spaced repetitionSpaced Repetition
heart puzzleMatch
flashcardsFlashcards
GameKnowt Play
Card Sorting

1/8

flashcard set

Earn XP

Description and Tags

Original instructor Deck 06, cards 1–9. Quiz 3 scope. Instructor wording and answers preserved.

9 Terms

1
New cards

What SQL clause lets you combine two tables?

JOIN

2
New cards

What are two SQL clauses that let you filter down what rows are included based on some condition, and how do these two clauses differ?

WHERE and HAVING WHERE is prior GROUP BY (if GROUP BY is used), so filters input rows HAVING is after GROUP BY, so filters groups

3
New cards

What SQL clause pulls together related rows?

GROUP BY

4
New cards

In SQL, SUM, AVG, and other operations that work over all rows (or groups of rows) are called ______

aggregates

5
New cards

What SQL clause sorts rows?

ORDER BY

6
New cards

What SQL clause lets you limit results to the first N rows?

LIMIT

7
New cards

What does ACID stand for?

atomiticy: it all happens or nothing happens (partial progress is rolled back) consistency: application invariants (like no negative bank accounts) are supported isolation: others cannot see a transaction in progress (aka atomicity when talking about locks) durability: once finished, it persists (even if machine crashes+restarts)

8
New cards

If conn is a SQLAlchemy connection, and you've made some changes as part of a transaction, how do you finalize that transaction?

conn.commit()

9
New cards

If conn is a SQLAlchemy connection, and you've made some changes as part of a transaction, how do you abandon that transaction?

conn.rollback()