Question

1) A modification query may cause rows in a view to disappear if a column in the WHERE clause of the view definition is changed by an UPDATE statement.

True

False

2)

A nested query cannot have multiple levels, i.e. you cannot have a nested query inside another nested query.

True

False

3)

Null values affect:

simple conditions involving comparison operators

compound conditions involving logical operators

all of the above

aggregate calculations and grouping

Answer 1

1.

A modification query may cause rows in a view to disappear if a column in the WHERE clause of the view definition is changed by an UPDATE statement.

Modification query can be UPDATE, INSERT, or DELETE.

True

2.

A nested query cannot have multiple levels, i.e. you cannot have a nested query inside another nested query.

False

Since a nested query can have multiple levels, so a nested query inside another nested query.

3.

Null values affect:

• Simple conditions involving comparison operators
• Compound conditions involving logical operators
• aggregate calculations and grouping

Option 3