SQL Flashcards

1
Q

begin

A
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

commit

A
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

rollback

A
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

What is a foreign key?

A
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

What is the purpose of a group by clause?

A

group by clause organize result set to buckets

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

json_agg()

A

make target into json

How well did you know this?
1
Not at all
2
3
4
5
Perfectly