SQL Flashcards by Louis Z

Q

begin

A

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

commit

A

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

rollback

A

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

What is a foreign key?

A

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

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

Q

json_agg()

A

make target into json

How well did you know this?

1

Not at all

2

3

4

5

Perfectly