2.7f

0.0(0)
studied byStudied by 0 people
linked notesView linked note
learnLearn
examPractice Test
spaced repetitionSpaced Repetition
heart puzzleMatch
flashcardsFlashcards
Card Sorting

1/8

encourage image

There's no tags or description

Looks like no tags are added yet.

Study Analytics
Name
Mastery
Learn
Test
Matching
Spaced

No study sessions yet.

9 Terms

1
New cards

What does NMET represent in numeric data types?

A special value that represents either unknown or inapplicable data, not the same as zero.

2
New cards

What happens when a WHERE clause evaluates to null for values in a row?

The row is not selected.

3
New cards

What is the purpose of a NOT NULL constraint?

It prevents a column from having a NULL value.

4
New cards

What does the SQL statement IS NULL return?

TRUE when the value is NULL.

5
New cards

What does the SQL statement IS NOT NULL return?

TRUE when the value is not NULL.

6
New cards

In NULL logic, what is the result of TRUE AND NULL?

NULL.

7
New cards

In NULL logic, what is the result of NULL OR FALSE?

NULL.

8
New cards

What is the result of NOT NULL in NULL logic?

NULL.

9
New cards

What is the significance of a WHERE clause that selects NULL values?

It never returns any rows because the WHERE clause is always null.