Which of the following are true with regards to prepared statements?
Select all that apply. When executing a prepared statement
A.
exactly one value must be given for each parameter.
B.
any number of parameters may be assigned a value; undefined parameters are assigned a default value.
C.
undefined parameters are assigned a value of NULL.
D.
undefined parameters are assigned an empty string.
Explanation:
PREPARE statement_name FROM ‘SELECT STATEMENT….’; options with AS don’t work.