Which of the following are placeholders for literal values in a Structured Query Language (SQL) query being
sent to the database on a server?
A.
Bind variables
B.
Assimilation variables
C.
Reduction variables
D.
Resolution variables
Explanation:
Bind variables placeholders for literal values in a Structured Query Language (SQL) query being sent to the
database on a server. The SQL statement is sent to the server for parsing and the later values are bound to the
placeholders and sent separately to the server. This separate step is the origin of the term ‘bind variable’.
Incorrect Answers:
B: An assimilation value is not the correct term for a value that can be bound to a placeholder declared within
an SQL statement.
C: A reduction value is not the correct term for a value that can be bound to a placeholder declared within an
SQL statement.
D: A resolution value is not the correct term for a value that can be bound to a placeholder declared within an
SQL statement.Krutz, Ronald L. and Russell Dean Vines, The CISSP Prep Guide: Mastering the CISSP and ISSEP Exams,
2nd Edition, Wiley Publishing, Indianapolis, 2004, p. 84