$9$

Which of the following are equivalent $($i$.$e$.,$ would do the same thing in SQL$)?$

A$.$ fname LIKE $\text{'}$J$\%\text{'}$ vs$.$ fname $=\text{'}$J$*\text{'}$

B$.$ WHERE position $=$ 'manager' OR position $=$ 'trainee' vs$.$ WHERE position IN $(\text{'}$manager$\text{'},$ 'trainee'$)$

C ORDER BY age vs$.$ ORDER BY age ASC

D$.$ IS NOT NULL vs$.!="$

$A$&$B$

$A$&$D$

$B$&$C$

$B,C,$&$D$

All are equivalent