Choose two

Examine this query:

SELECT employee_id,first_name,salary

FROM employees

WHERE hire_date > '&1';

Which two methods should you use to prevent prompting for a hire date value when this query is executed?

A) Use the DEFINE command before executing the query.

B) Store the query in a script and pass the substitution value to the script when executing it.

C) Replace '&1' with '&&1' in the query.

D) Execute the SET VERIFY OFF command before executing the query.

E) Use the UNDEFINE command before executing the query.

F) Execute the SET VERIFY ON command before executing the query.

Answer：AC

(解析：如何解決變量的值無(wú)需輸入 2 次，可以用 AC 的辦法實(shí)現(xiàn)。)