Oracle Database 12c SQL 1z0-071 Question # 79 Topic 8 Discussion

Oracle Database 12c SQL 1z0-071 Question # 79 Topic 8 Discussion

1z0-071 Exam Topic 8 Question 79 Discussion:
Question #: 79
Topic #: 8

Which two statements are true about substitution variables?


A.

A substitution variable used to prompt for a column name must be endorsed in single quotation marks.


B.

A substitution variable used to prompt for a column name must be endorsed in double quotation marks.


C.

A substitution variable prefixed with & always prompts only once for a value in a session.


D.

A substitution variable can be used with any clause in a SELECT statement.


E.

A substitution variable can be used only in a SELECT statement.


F.

A substitution variable prefixed with 6 prompts only once for a value in a session unless is set to undefined in the session.


Get Premium 1z0-071 Questions

Contribute your Thoughts:


Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.