Dynamic SQL is most frequently used by an application when _______.

A.
the SQL queries are too complicated to program

B.
the SQL statements for an application are known in advance

C.
the application needs to perform ad hoc queries programmatically

D.
high performance is an important application attribute