To answer this question, you need to understand the concept of substitution variables in SQL.
Substitution variables are used in SQL to prompt the user for input during the execution of a query. They allow you to dynamically substitute values into a query at runtime.
The default character for specifying substitution variables in select statements is the ampersand (&) symbol. When the SQL statement is executed, the user is prompted to enter a value for the substitution variable.
Let's go through each option to understand why it is correct or incorrect:
Option A) Ellipses - This option is incorrect because ellipses (...) are not used for specifying substitution variables in select statements.
Option B) Quotation marks - This option is incorrect because quotation marks (") are not used for specifying substitution variables in select statements.
Option C) Ampersand - This option is correct because the ampersand (&) symbol is the default character for specifying substitution variables in select statements.
Option D) Asterisk - This option is incorrect because the asterisk (*) is not used for specifying substitution variables in select statements.
The correct answer is Option C) Ampersand. This option is correct because the ampersand (&) symbol is the default character for specifying substitution variables in select statements.