InfoMidterm P3

What is the purpose of using substitution variables in iSQL*Plus?

• To permanently store values

• To restrict the range of data returned

• To create reports without user input

• To delete data from the database

How can you temporarily store values using substitution variables in iSQL*Plus?

• Using no substitution variables

• Using triple-ampersand substitution

• Using quadruple-ampersand substitution

• Using single-ampersand (&) and double-ampersand (&&) substitution

Which clause can substitution variables be used to supplement in iSQL*Plus?

• HAVING clauses

• FROM clauses

• ORDER BY clauses

• GROUP BY clauses

How can you predefine variables in iSQL*Plus?

• Using the DEFINE command

• Using the DECLARE command

• Using the SET command

• Using the CREATE command

What is the purpose of the VERIFY command in iSQL*Plus?

• To verify the user's identity

• To toggle the display of substitution variables

• To delete all data from the database

• To create new variables

When using substitution variables for date and character values in a WHERE clause, how should they be enclosed?

• In single quotation marks

• In double quotation marks

• In square brackets

• In parentheses

What does the double ampersand (&&) substitution variable allow you to do in iSQL*Plus?

• Prompt the user for a value each time

• Reuse the variable value without prompting

• Delete the variable value

• Ignore the variable value

In which part of the SQL statement should substitution variables be enclosed in single quotation marks?

• In the FROM clause

• In the SELECT clause

• In the ORDER BY clause

• In the WHERE clause

What type of values can be substituted for using substitution variables in iSQL*Plus?

• Numeric, string, date values

• Only string values

• Only numeric values

• Only date values

How can you use substitution variables to restrict the range of data returned in a report?

• By prompting users to supply values

• By hard-coding the values

• By ignoring the values

• By deleting the data