A disadvantage of a FULL JOIN statement could be that

A

It retrieves the table rows that don$$t match.

B

It ignores the NULLs for a very small result$-$set.

C

It retrieves a selective result$-$set.

D

It retrieves all rows from the tables for a very large result$-$set.