Week 7 Flashcards

1
Q

Predication evaluation in SQL is done by using what type of logic?

A

Three-valued logic

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

What are the three potential values in SQL for predication

A

TRUE

FALSE

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

Are tuples ordered?

A

NO

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

When rows are ordered in SQL, where do NULLS appear?

A

At the end of the ordered list (BY DEFAULT)

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